Database report output shows multiple pages

115 pts.
Tags:
Database administration
Database reporting
TOAD
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.

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Ms123
    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.
    115 pointsBadges:
    report
  • carlosdl
    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?
    69,065 pointsBadges:
    report
  • Ms123
    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
    115 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following