Home » Developer & Programmer » Reports & Discoverer » retreiving a number instead of 0 (windows xp,form6i,report 6i,oracle 9i)
retreiving a number instead of 0 [message #352491] Wed, 08 October 2008 01:12 Go to next message
anasjamil
Messages: 28
Registered: April 2008
Location: KARACHI
Junior Member

hi,
i have created a report in report builder 6i and columns are as under

debit credit checkno voucherno balance
1000 2000 2121 111 60000
0 222 222 222 54554

so if the first column(debit) is zero then i want to have the value of balance from previous row in it just like as under


debit credit checkno voucherno balance
1000 2000 2121 111 60000
6000 222 222 222 54554

all the columns are being retrieve through formula column
except debit(column).

i would be greatful to you.

thanks in advance,
regards,
anas jamil



Re: retreiving a number instead of 0 [message #352532 is a reply to message #352491] Wed, 08 October 2008 04:53 Go to previous messageGo to next message
mudabbir
Messages: 235
Registered: April 2006
Location: Kuwait
Senior Member

I am not sure.. maybe you can search for Placeholder column. It may help
Re: retreiving a number instead of 0 [message #352558 is a reply to message #352532] Wed, 08 October 2008 06:44 Go to previous messageGo to next message
mudabbir
Messages: 235
Registered: April 2006
Location: Kuwait
Senior Member

Global Variables may help...

Save the balance in a global variable when every record is fetched. if the value of debit is 0 then assign debit the global variable.

Re: retreiving a number instead of 0 [message #352568 is a reply to message #352491] Wed, 08 October 2008 07:06 Go to previous messageGo to next message
anasjamil
Messages: 28
Registered: April 2008
Location: KARACHI
Junior Member

thanks once again for the reply.i have tried to sort out the problem through placeholder now the condition is that i have an extra column and things are like this.

debit credit voucherno etc bal placeholder
222 222 333 092 1000 1000
213 345 234 434 2000 2000
0 234 333 322 3000 3000



now the question is i want to copy the value from placeholder
(previous one)and paste to the column debit where there is 0 only
just like as under


debit credit voucherno etc bal placeholder
222 222 333 092 1000 1000
213 345 234 434 2000 2000
2000 234 333 322 3000 3000


would be waiting for reply.

thanks in advance,
regards,
anas jamil
Re: retreiving a number instead of 0 [message #353818 is a reply to message #352491] Wed, 15 October 2008 04:20 Go to previous messageGo to next message
dude4084
Messages: 221
Registered: March 2005
Location: Mux
Senior Member
Hi

In Layout model, delete placeholder column so that it is not displayed in the report.

-Dude
Re: retreiving a number instead of 0 [message #353837 is a reply to message #353818] Wed, 15 October 2008 05:15 Go to previous message
anasjamil
Messages: 28
Registered: April 2008
Location: KARACHI
Junior Member

i have found the solution.

it is by creating an extra column in data base and by using
a trigger before report and applying an update query over there



regards,
anas jamil
Previous Topic: Difference between report level / table / formula columns
Next Topic: How to set base line automatically
Goto Forum:
  


Current Time: Sat Dec 10 16:26:43 CST 2016

Total time taken to generate the page: 0.05319 seconds