Home » Developer & Programmer » Reports & Discoverer » report is not printing all information (reports 10g)
report is not printing all information [message #409274] Sun, 21 June 2009 16:11 Go to next message
nastyjillu
Messages: 211
Registered: February 2009
Senior Member
hi,

i have a report. there are some points like 1,2,3.

if the information regarding point 1 is more then one page then it is not printing the excess information that has to be printed on next page.
i want to print information that is not printed on first page duse to insufficient space to print on next page.

also there is another field besides point called ID.

as of now report is sorted as order by point. then order by ID.

i want to have whole report order by ID only not by point.

but i didnot see ORDER By clause in any of the datamodel query. then how is it sorting??

and point field is a formula column and ID is database column.

i datamodel query where there is ID i wrote ORDER BY ID DESC it didnot work. still it is doing what it was doing before.

is there any other place where we can do sort by ??

i have 2 questions mentioned above.

thanks
jillu
Re: report is not printing all information [message #409344 is a reply to message #409274] Mon, 22 June 2009 04:14 Go to previous messageGo to next message
cookiemonster
Messages: 12422
Registered: September 2008
Location: Rainy Manchester
Senior Member
For the ordering read up on the break order property in report builder help.
Re: report is not printing all information [message #409436 is a reply to message #409344] Mon, 22 June 2009 13:25 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
In addition to Cookiemonster's answer, you'll recognize "order by" columns in Data Model Editor as they'll have blue arrows pointing up (ascending) or down (descending).

As of printing the rest of information on the second page (if it doesn't fit the first one), check whether repeating frame's "Maximum records par page" property is set to "1". If so, change it to "0" (zero).
Re: report is not printing all information [message #409748 is a reply to message #409436] Tue, 23 June 2009 19:19 Go to previous messageGo to next message
nastyjillu
Messages: 211
Registered: February 2009
Senior Member
maximum records per page was 0 .

there are no order by columns
Re: report is not printing all information [message #409859 is a reply to message #409274] Wed, 24 June 2009 04:42 Go to previous messageGo to next message
cookiemonster
Messages: 12422
Registered: September 2008
Location: Rainy Manchester
Senior Member
Did you read up on the break order property?
Re: report is not printing all information [message #409979 is a reply to message #409859] Wed, 24 June 2009 11:52 Go to previous messageGo to next message
nastyjillu
Messages: 211
Registered: February 2009
Senior Member
yes i read break order.

the break order for ID is ascending. if i change it to descending also there is no change. its still printing in ascending.

Re: report is not printing all information [message #409981 is a reply to message #409274] Wed, 24 June 2009 11:54 Go to previous messageGo to next message
cookiemonster
Messages: 12422
Registered: September 2008
Location: Rainy Manchester
Senior Member
How many groups have you got in your data model?
Re: report is not printing all information [message #409989 is a reply to message #409981] Wed, 24 June 2009 13:23 Go to previous messageGo to next message
nastyjillu
Messages: 211
Registered: February 2009
Senior Member
i got 4 groups
Re: report is not printing all information [message #410129 is a reply to message #409274] Thu, 25 June 2009 07:17 Go to previous message
cookiemonster
Messages: 12422
Registered: September 2008
Location: Rainy Manchester
Senior Member
It might be simplest if you post a screenshot of your data model along with the query you are using.

But as far as I can tell, if reports is ignoring the order by in your select statement you've got to have a break order set somewhere that overrides it.
Previous Topic: code not working
Next Topic: Error A READ-ONLY bind variable used in OUT or IN-OUT context
Goto Forum:
  


Current Time: Thu Dec 08 20:00:01 CST 2016

Total time taken to generate the page: 0.07198 seconds