Home » Developer & Programmer » Reports & Discoverer » Displaying One Record per page for all retrieved records (10g)
Displaying One Record per page for all retrieved records [message #517454] Tue, 26 July 2011 02:59 Go to next message
shanie
Messages: 118
Registered: January 2011
Senior Member
Dear All,

Thanks for cooperating and helping.
I developed a report in 10g which displays more than 100 records.
The requirement is to display each record on single page.
Does Oracle Reports have the option to display each on single page?

Please help!

Thanks & Regards,
Shanie
Re: Displaying One Record per page for all retrieved records [message #517457 is a reply to message #517454] Tue, 26 July 2011 03:10 Go to previous messageGo to next message
shanie
Messages: 118
Registered: January 2011
Senior Member
Dear All,

Form layout will allow each record per page.

Sorry for this post.
Regards,
Shanie
Re: Displaying One Record per page for all retrieved records [message #517460 is a reply to message #517457] Tue, 26 July 2011 03:27 Go to previous messageGo to next message
Littlefoot
Messages: 19305
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Set "Maximum records per page" property to 1.
Re: Displaying One Record per page for all retrieved records [message #517461 is a reply to message #517457] Tue, 26 July 2011 03:30 Go to previous messageGo to next message
shanie
Messages: 118
Registered: January 2011
Senior Member
But Image & Heading is displayed on first page of the report only.
I need to display these on every page.

Please help.
Regards,
Shanie
Re: Displaying One Record per page for all retrieved records [message #517462 is a reply to message #517461] Tue, 26 July 2011 03:32 Go to previous messageGo to next message
Littlefoot
Messages: 19305
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Put them into the header section (or into the margin).
Re: Displaying One Record per page for all retrieved records [message #517464 is a reply to message #517462] Tue, 26 July 2011 03:46 Go to previous messageGo to next message
shanie
Messages: 118
Registered: January 2011
Senior Member
I put them in Header Section
But Logo and Heading is coming on First Page
From Second Page Records are coming with no Logo and Heading.

Margin doesn't allow me to put or create any thing.

Regards,
Shanie
Re: Displaying One Record per page for all retrieved records [message #517472 is a reply to message #517464] Tue, 26 July 2011 04:38 Go to previous messageGo to next message
Littlefoot
Messages: 19305
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I created a sample report based on DEPT table in SCOTT schema. I used Wizard and accepted all default settings.

"YOUR Inc. COMPANY" logo is, by default, placed into the margin section. I didn't touch it, but I added a report title ("Departments") into the margin.
I modified report frame's "Maximum records per page" property to 1 (one).

Then I ran the report.
Logo and title appear on every page. Every department is displayed on its own page.

I don't know what you did and how, but - apparently, it works if you do it correctly. Saying that "margin doesn't allow you to put or create anything" means what exactly? Do you know how to go to margin? There's the "Edit margin" button in the toolbar - you have to click it.
Re: Displaying One Record per page for all retrieved records [message #517479 is a reply to message #517472] Tue, 26 July 2011 05:09 Go to previous message
shanie
Messages: 118
Registered: January 2011
Senior Member
Thanks for your kind help.

Regards,
Shanie
Previous Topic: TRACEFILE in report10g
Next Topic: Need help with averages across the columns
Goto Forum:
  


Current Time: Thu Jul 24 18:59:21 CDT 2014

Total time taken to generate the page: 0.05928 seconds