Home » Developer & Programmer » Forms » Re: once again (Trouble in Total)
Re: once again (Trouble in Total) [message #78520] Thu, 28 February 2002 00:22 Go to next message
annu
Messages: 34
Registered: February 2002
Member
Dear Pratap ,

I really thankfull to u for your valueable advise for my prob. i work on it and now my form is error free and really works in very good consitions. Now i want to know about report. I m using reports very first time. So didnt have such knowledge about it, but i understand lot of things ..Now tell me how to make report as same as my form is ... suppost if i want to print ledger of the same account displaying on the screen or any spesified account. So what is the select I m using in report while I need also a running total same as in form which u told me as a solution .

Condision Calling parameter form
-------
Account number 01

Date from 01-01-2002

Date to 31-01-2002

Report is
------
date description dr amount cr amount balance
01-01-02 trans 1 500 500
03-01-02 trans 2 750 1250
10-01-02 trans 3 250 1000


now tell me how to make this report and what select I use in it . and how to make running total field

Annu
Re: once again (Trouble in Total) [message #78525 is a reply to message #78520] Thu, 28 February 2002 04:13 Go to previous message
pratap kumar tripathy
Messages: 660
Registered: January 2002
Senior Member
create a formula coulmn

and write this code for that

return(nvl(:cf_1,0)+:sal);

where cf_1 is the formula column
and sal is the column u want to add to the running total
Previous Topic: Calling Reports from Database
Next Topic: Form/Report 6i in Windows XP installation problem
Goto Forum:
  


Current Time: Fri Aug 14 10:09:08 CDT 2020