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.

Report message to a moderator

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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Jul 03 10:39:01 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.