OraFAQ Forum: Reports & Discoverer » Sorting Data and Hidden Frames

Home » Developer & Programmer » Reports & Discoverer » Sorting Data and Hidden Frames (Oracle Reports ,10g, Windows XP )

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

Sorting Data and Hidden Frames [message #535612]

Thu, 15 December 2011 04:20

waqar_majeed
Messages: 3
Registered: December 2011
Location: Pakistan

Junior Member

Hi,
how can i sort field data getting from formula column.
The filed that i want to sort have source of that fomula column.
When i use order by clause with :abc ---(formula column) then it doest not work.

please Help.
Thanx

Report message to a moderator

Re: Sorting Data [message #535616 is a reply to message #535612]

Thu, 15 December 2011 05:08

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Create a break group based on a formula column. Set formula column's Break Order property to ascending or descending.

Report message to a moderator

Sorting and Hidden Frames [message #535769 is a reply to message #535612]

Fri, 16 December 2011 04:40

waqar_majeed
Messages: 3
Registered: December 2011
Location: Pakistan

Junior Member

hi,
1- i have some more columns from query displaying on this report.
i ve tried already to set break order as descendind/ascending, but its not working.

at report one column has a source of that formula column.

2- one more please i ve different numbers getting from this formula column. i have hide the repeating frame when value is Zero(0).
a summary colum counts this hidden repeating frame value. i want to neglect this one. basically i want continuous series to neglect this hidden frame value when it goes to 0.

have any other idea plz.

Report message to a moderator

Re: Sorting Data [message #535845 is a reply to message #535616]

Fri, 16 December 2011 10:23

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I think that you didn't understand what I said. Not only you need to set the break order - you need to extract that column into its own break group (above the "original" group). Moreover, it means that layout you'll create is no longer "Tabular", but "Group above" (or similar).
I'm not sure I understood the question. Why don't you create a summary column and adjust its break point (whether it is a report, a page, or one of frames)?

Report message to a moderator

Previous Topic:	How to present report in XLS format with proper column headings
Next Topic:	REP-52251: Cannot get output of job ID 69 you requested

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 02 10:02:28 CST 2024