Home » Developer & Programmer » Reports & Discoverer » Report Query
Report Query [message #198619] Wed, 18 October 2006 00:39 Go to next message
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.


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

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

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

Current Time: Thu Oct 27 19:54:20 CDT 2016

Total time taken to generate the page: 0.09569 seconds