| report is not printing all information [message #409274] |
Sun, 21 June 2009 16:11  |
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 #410129 is a reply to message #409274] |
Thu, 25 June 2009 07:17  |
cookiemonster
Messages: 13958
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
