Home » Developer & Programmer » Reports & Discoverer » Report Query
Report Query [message #198619] Wed, 18 October 2006 00:39 Go to next message
Vaish
Messages: 7
Registered: October 2006
Junior Member
Hello Everyone

I'm having some problem with a report. If anyone can help me out..

I have a field which is Varchar2 datatype, It stores account balances for an employee, and after the last balance it stores a sentence like "End of Statement" in the same field.

I want to display the balance which is above "End of Statement" in the report. How can i achieve this??? In the report im displaying all the balances with the "End of Statement" as its stored in the same field. But i need to display the balance which is above "End of Statement" separately elsewhere as well.

Please some one help me out. I'm designing this report in Developer 10g.


Thanks

Vaishali.
Re: Report Query [message #198685 is a reply to message #198619] Wed, 18 October 2006 04:29 Go to previous message
hozskar
Messages: 3
Registered: October 2006
Junior Member
hello
vaishali

you can try this way see if you have fld_nbr or id number for your table use it.

thanks
hozefa
Previous Topic: Main Section and Trailer Section in reports
Next Topic: Call report from form
Goto Forum:
  


Current Time: Sun Dec 11 02:37:36 CST 2016

Total time taken to generate the page: 0.08349 seconds