Database report output shows multiple pages
When I run a report, I see multiple pages, but running the query directly on the database using TOAD gives me only one record. How do I find why the query gives multiple pages? I can ofcourse set printing option as "First Page" for all the fields, but I need to know why the duplication occurs.
Software/Hardware used:
Software/Hardware used:
ASKED:
March 8, 2009 9:08 AM
UPDATED:
March 11, 2009 12:01 PM
Answer Wiki:
Is this a 'Developer' (Reports) report ?
Are you sure the query is exactly the same ?
If so, you should look for problems in the report's layout model.
To see all answers submitted to the Answer Wiki: View Answer History.
Thanks for the response, it is a developer report indeed. And the query is exactly the same.
Where exactly do I look for problems in the report layout model? I am asking because I am new to oracle reports, but am strong with the concepts because I have been using a lot of other report development tools.
I was thinking about some misplaced repeating frame, or grouping problem, but I have not been able to replicate the situation.
The only way I was able to somehow simulate the problem, was changing the parent repeating frame’s “print object on” property to “all pages” (It should work when set to “default”).
Does the query use some user parameter ?
Have you tried creating a new report (using the wizard) with the same query to see if the problem persists?
Thank you very much Carlos, I have checked the fields in the report, and found that the “Vertical Elasticity” for one particular field was set to Expand, and this field had a really long value which caused the field below it to shift to the next page. The problem was solved by changing the long data (it was a newly created bank account name) to a shorter one. Thanks once again for your advice.
Regards,
MS