running balance report

Hello,
I want to make a report that display running balance of a customer

I have those tables:
1- invoices (detail of customers table)
2- invoices items (detail of invoices)
3- payments (detail of customers)

I need the report to be like this :

==================================================================
Date | Description | Quantity | Price | Debit | Credit | Balance |
==================================================================
1/1   opening balance  0          0         200    0       200
5/1   sales            10         15        150    0       350
6/1   payments         0           0          0    -200    150
etc...

I use FastReport

Thanks
0
no
9/2/2008 5:52:30 PM
embarcadero.delphi.reporting 487 articles. 0 followers. Follow

4 Replies
862 Views

Similar Articles

[PageSpeed] 35

I think you should make a Query/View/Stored Procedure to retrieve that 
data sorted/formatted as you mentioned, then link the query to a 
MasterData band, then insert the Memo fields. It's easy.

Leonardo.

isaac sam escribió:
> Hello,
> I want to make a report that display running balance of a customer
> 
> I have those tables:
> 1- invoices (detail of customers table)
> 2- invoices items (detail of invoices)
> 3- payments (detail of customers)
> 
> I need the report to be like this :
> 
> ==================================================================
> Date | Description | Quantity | Price | Debit | Credit | Balance |
> ==================================================================
> 1/1   opening balance  0          0         200    0       200
> 5/1   sales            10         15        150    0       350
> 6/1   payments         0           0          0    -200    150
> etc...
> 
> I use FastReport
> 
> Thanks
1
Utf
9/9/2008 6:17:02 PM
1. Make SQL-Query based on your tables.
2. Create report based on this Query.

"isaac sam" <no@no.com> wrote: news:9532@forums.codegear.com...
> Hello,
> I want to make a report that display running balance of a customer
> 
> I have those tables:
> 1- invoices (detail of customers table)
> 2- invoices items (detail of invoices)
> 3- payments (detail of customers)
> 
> I need the report to be like this :
> 
> ==================================================================
> Date | Description | Quantity | Price | Debit | Credit | Balance |
> ==================================================================
> 1/1   opening balance  0          0         200    0       200
> 5/1   sales            10         15        150    0       350
> 6/1   payments         0           0          0    -200    150
> etc...
> 
> I use FastReport
> 
> Thanks
0
Michael
9/10/2008 12:20:19 PM
1. Make SQL-Query based on your tables.
2. Create report based on this Query.

"isaac sam" <no@no.com> сообщил/сообщила в новостях следующее: 
news:9532@forums.codegear.com...
> Hello,
> I want to make a report that display running balance of a customer
>
> I have those tables:
> 1- invoices (detail of customers table)
> 2- invoices items (detail of invoices)
> 3- payments (detail of customers)
>
> I need the report to be like this :
>
> ==================================================================
> Date | Description | Quantity | Price | Debit | Credit | Balance |
> ==================================================================
> 1/1   opening balance  0          0         200    0       200
> 5/1   sales            10         15        150    0       350
> 6/1   payments         0           0          0    -200    150
> etc...
>
> I use FastReport
>
> Thanks
0
Michael
9/10/2008 12:20:20 PM
1. Make SQL-Query based on your tables.
2. Create report based on this Query.

"isaac sam" <no@no.com> сообщил/сообщила в новостях следующее:
news:9532@forums.codegear.com...
> Hello,
> I want to make a report that display running balance of a customer
>
> I have those tables:
> 1- invoices (detail of customers table)
> 2- invoices items (detail of invoices)
> 3- payments (detail of customers)
>
> I need the report to be like this :
>
> ==================================================================
> Date | Description | Quantity | Price | Debit | Credit | Balance |
> ==================================================================
> 1/1   opening balance  0          0         200    0       200
> 5/1   sales            10         15        150    0       350
> 6/1   payments         0           0          0    -200    150
> etc...
>
> I use FastReport
>
> Thanks
0
Michael
9/10/2008 12:20:22 PM
Reply:

Similar Artilces:

about report reports generation and emailing reports
hi i am a bit new to Bugzilla, i am using 2.18rc3version. and i am facing two problems with report generation. 1) the checksetup.pl shows all the perl modules includig optional perl modules to be installed and available including thse required for graphical report generation. but despite this i am able to get tabular reports generated but when i click for line/bar reports of the same tabular report the next page does not show the required pie/bar reports. 2) is there any facility for sending these generated reports to the client via email through Bugzilla? kindly help. regards...

Converting Crystal Reports 9 report to Crystal Reports .NET report
I have a web page that is supposed to display a crystal report.  The report is fully written and functional in crystal 9 (non-.Net)  .  Is there a way to convert my .rpt so that I can just include it in the new web site? why you don't try to compile project with .net and include your report. then if crystal report is power tool will suggests you with conversation tool    My blog is here.Please remember to 'Mark as Answer' if this post answered your question! Wow it really was that easy!  I just added the old crystal report into my .NET proj...

ANN: Delphi HTML Reports preview
Very simple to use - buid complex reports in 10 minutes. All you need to know - SQL, HTML, CSS. Use all power of HTML4 and CSS3 in any part of report. Features: Barcodes Multiline headers Groups Cross-tabs (any level) Transformations (cross-tab with range) Pictures (+from database) Master/Detail (any level) Supports all databases and db-libraries (writing adapter for any db-acess library takes only 5 minutes) Standalone reports - no need for delphi forms/datasets. 100% native Delhi code. All Delphi versions - from Delphi 6 to XE6 (VCL). 32/64 bit. Supports Unicode for...

how to run a report made in Crystal Reports
Hi all. I use Pb10 and CR10. I woudl like to run a report made in CR10 and pass to it few parameters. (id_customer,range of date, ...) Is it possible without any additional components or dll-s. Maybe any links or examples of sorce code? Thanks in advance. Adam There are several examples in this newsgroup. For example: http://groups-beta.google.com/group/sybase.public.powerbuilder.general/browse_frm/thread/e8a3f1e94221ce66/b22af7ca53173cf7?hl=en&lr=&rnum=1&prev=/groups%3Fhl%3Den%26lr%3D%26q%3Dpowerbuilder%2Bcrystal%2Bchestnut%2Boleobject%26btnG%3DSearch#b22af7ca531...

report server not running reports properly
Hi, I keep getting the below error meassages when trying to run reports on a shared intranet. The reports deploy ok and its just when i try to open them from the intranet. Im in depare here so any help would be appreciated. Object reference not set to an instance of an object. I then click on the refresh button and get:·         Server Error in '/Reports' Application. ·         ·         Input string was not in a correct format. ·   &n...

Report Control (report viewer and report designer)
Hi there! ive looked over the forums and other websites that you referred but i dont have any luck for reports. i created a page that has simple data-entry, aside from that, i do want to have a printable report on what are the items i have added this day. i am using a report designer (rdlc) and a report viewer, which is in a aspx page. ive explored how it works for a simple select statement but i want to know how it will work for parameter passing. a referral for a tutorial website for the report viewer and report designer is very much appreciated. or if you want to share your...

Are there other reporting tools other than reporting services and crystal reports
Has anyone had any experience with any reporting tools other than Reporting services and Crystal reports? If so, is there one that you would strongly recommend? Or, are these two the top choice on the market for report generation from .NET? I have heard some moaning and groaning about reporting services. Specifically in regards to the amount of time needed to design a report. Crystal reports seems kind of difficult to me, as I don't have any training with it. Basically I am looking for a reporting tool that is easy to use, and can be used from .NET....

how to run report made in Crystal Reports 10
Hi all. I use Pb10 and CR10. I woudl like to run a report made in CR10 and pass to it few parameters. (id_customer,range of date, ...) Is it possible without any additional components or dll-s. Maybe any links or examples of sorce code? Thanks in advance. Adam I think you might have posted in the wrong forum. This sounds like a PowerBuilder question. -- Mike Nicewarner [TeamSybase] http://www.datamodel.org mike@nospam!datamodel.org (can you figure what to remove?) Sybase product enhancement requests: http://www.isug.com/cgi-bin/ISUG2/submit_enhancement Adam Pol...

How to find out who is running or started a Reporting service report
We have various report service reports on the intranet.  I want to be able to see what user is CURRENTLY running a report in progess.  How can I find that out?  SQL Activity Monitor will not show the windows user, it only shows a system account.  I can see the stored procedure that the report is using in the activity monitor....any thoughts?   We could always see such a thing on the 400 :P Hi,  Try as below,take a text box and right clik select Expression -> write expression as below =User!UserID  when you run the report it will show the ...

Run Report Builder outside Report Server
Hi, Is it possible to integrate Report Builder into a web application? In other words, it can execute Report Builder not from Report Server. Thanks...

View Microsoft Reporting Services Reports in Delphi
Do you ever think (or can) Delphi take the leap of providing a report viewer for Microsoft Reporting Services RDL reports. I have been using Fast Reports for years. Recently I have been developing MS Reports and Cubes. This is a far better alternative for developers and end users than the current solutions written for Delphi. Can someone comment on this or provide an alternative for me? Or even better provide me with a product that 3rd party product that can view ms reports. Delphi need to take the next step in medium to enterprise reporting and what I see, lags behind in this department. ...

Error running SqlServer Reporting Services Report
Hi Everyone Im running SQLSefrver Reporting Services 2000 SP 1 on Windows Server 2003 and getting the error below. Can anyone point me in the right direction as to what this could mean and how I could fix the problem. This is the error that is being logged in the reportserver error log: w3wp!runningjobs!364!8/02/2007-18:37:17:: w WARN: Previous request for Memory stats updatestill executing, skipping... w3wp!runningjobs!364!8/02/2007-18:38:17:: w WARN: Previous request for Memory stats updatestill executing, skipping... w3wp!runningjobs!364!8/02/2007-18:39:17:: w WARN: Previous requ...

VS 2005 Reporting Services
Hi, I'm starting to work with reporting services.  In VS2005 I create a new page and want a standard report (an .rdlc).  I create a data source to a table in a database of my SQL 2000 server, run the query and all the data appears to be present.  Then I go to the designer and add a few text boxes and bind them to the report.  So far, so good. But.. how do I run the report to see what it looks like?  If I hit <F5> or <cntr><F5> VS2005 brings up a screen that shows a directory listing of the files in my project, not the report. Do I have some othe...

Web resources about - running balance report - embarcadero.delphi.reporting

Running - Wikipedia, the free encyclopedia
This article is about the type of locomotion in humans. For running in horses, see Horse gait . For locomotion in dogs, see Gait (dog) . For ...

The iPad Pro could turn around the long-running decline in iPad sales, says IDC
... for more breaking coverage of iOS Devices , iPad , and iPad Pro . What do you think? Discuss "The iPad Pro could turn around the long-running ...

The Running Imam by @BloggersRUs
The Running Imam by Tom Sullivan More tales of the drone wars. Citizen, now you can do your part to fight international terrorism from the ...

US investigators are accusing a bitcoin entrepeneur of running a $20 million Ponzi scheme
US investigators are accusing a bitcoin entrepeneur of running a Ponzi scheme that brought in nearly $20 million (£13.2 million). Josh Garza, ...

​Armed teen running toward school shot by Wichita cop
17-year-old student who police call a documented gang member hospitalized in critical but stable condition

How to choose the right running app for you
... it’s hard to decide which one to use. Should you go for a familiar brand like Nike, or a specialist like Runkeeper? Ultimately, all running ...

All-American Running Back Diagnosed With Hodgkin’s Lymphoma
All-American Running Back Diagnosed With Hodgkin’s Lymphoma

Packers running back Eddie Lacy had five attempts for four yards and one catch for a loss of three y
Packers running back Eddie Lacy had five attempts for four yards and one catch for a loss of three yards in last night’s game. His lack of touches ...

Cruz: Other GOPers running to manage decline of U.S.
LENOX, Ia. — Fellow Republican presidential candidates are not looking to save the country but only ease its pain, U.S. Sen. Ted Cruz said Saturday. ...

Are you having trouble running Just Cause 3?
According to reports on Reddit, some players are experiencing significant issues with newly launched Just Cause 3 . As reported by VG24/7 , ...

Resources last updated: 12/6/2015 5:31:56 AM