OraFAQ Forum: Reports & Discoverer » retreiving a number instead of 0

Home » Developer & Programmer » Reports & Discoverer » retreiving a number instead of 0 (windows xp,form6i,report 6i,oracle 9i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

retreiving a number instead of 0 [message #352491]

Wed, 08 October 2008 01:12

anasjamil
Messages: 31
Registered: April 2008
Location: Sydney

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

Report message to a moderator

Re: retreiving a number instead of 0 [message #352532 is a reply to message #352491]

Wed, 08 October 2008 04:53

mudabbir
Messages: 235
Registered: April 2006
Location: Kuwait

Senior Member

I am not sure.. maybe you can search for Placeholder column. It may help

Report message to a moderator

Re: retreiving a number instead of 0 [message #352558 is a reply to message #352532]

Wed, 08 October 2008 06:44

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.

Report message to a moderator

Re: retreiving a number instead of 0 [message #352568 is a reply to message #352491]

Wed, 08 October 2008 07:06

anasjamil
Messages: 31
Registered: April 2008
Location: Sydney

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

Report message to a moderator

Re: retreiving a number instead of 0 [message #353818 is a reply to message #352491]

Wed, 15 October 2008 04:20

dude4084
Messages: 222
Registered: March 2005
Location: Mux

Senior Member

Hi

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

-Dude

Report message to a moderator

Re: retreiving a number instead of 0 [message #353837 is a reply to message #353818]

Wed, 15 October 2008 05:15

anasjamil
Messages: 31
Registered: April 2008
Location: Sydney

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

Report message to a moderator

Previous Topic:	Difference between report level / table / formula columns
Next Topic:	How to set base line automatically

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 30 05:20:27 CST 2024