Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

setiing row total into next row column

Status
Not open for further replies.

krimya

Programmer
Feb 14, 2005
8
US
Ihave a report like this

ID Begin Balance End Balance Total
1 0 100 100 (BBalanceN row)
2 100 200 300
3 300 (100) 200
4 200 200 400
i will get some dates and end balance from database.
How to accomplish this.

Please let me know.
Thanks in advance
 
That would depend upon HOW you are getting data.

A basic requirement when doing any analysis is to understand your data, so post the structure of the data.

You also state thatyou'll get the end balance from the database, are you saying that you won't get the begin and end?

Try to be thorough with requirements and environment.

Crystal version
Database/connectivity used
Example data
Expected output (based on the data)

-k

 
I am using CE 10 with oracle database.
The out put of the data table will be ID and End Balance and I have to input o as begin balance. The total is beginbal + end bal.
for the next row the begin balance = Total.
This will continue till end of the records.

ID Begin Balance End Balance Total
1 0 100 100
2 100 200 300
3 300 (100) 200
4 200 200 400
How to accomplish this.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top