OraFAQ Forum: Reports & Discoverer » Displaying One Record per page for all retrieved records

Home » Developer & Programmer » Reports & Discoverer » Displaying One Record per page for all retrieved records (10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Displaying One Record per page for all retrieved records [message #517454]

Tue, 26 July 2011 02:59

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

Report message to a moderator

Re: Displaying One Record per page for all retrieved records [message #517457 is a reply to message #517454]

Tue, 26 July 2011 03:10

shanie
Messages: 118
Registered: January 2011

Senior Member

Dear All,

Form layout will allow each record per page.

Sorry for this post.
Regards,
Shanie

Report message to a moderator

Re: Displaying One Record per page for all retrieved records [message #517460 is a reply to message #517457]

Tue, 26 July 2011 03:27

Littlefoot
Messages: 21807
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Set "Maximum records per page" property to 1.

Report message to a moderator

Re: Displaying One Record per page for all retrieved records [message #517461 is a reply to message #517457]

Tue, 26 July 2011 03:30

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

Report message to a moderator

Re: Displaying One Record per page for all retrieved records [message #517462 is a reply to message #517461]

Tue, 26 July 2011 03:32

Littlefoot
Messages: 21807
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Put them into the header section (or into the margin).

Report message to a moderator

Re: Displaying One Record per page for all retrieved records [message #517464 is a reply to message #517462]

Tue, 26 July 2011 03:46

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

Report message to a moderator

Re: Displaying One Record per page for all retrieved records [message #517472 is a reply to message #517464]

Tue, 26 July 2011 04:38

Littlefoot
Messages: 21807
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.

Report message to a moderator

Re: Displaying One Record per page for all retrieved records [message #517479 is a reply to message #517472]

Tue, 26 July 2011 05:09

shanie
Messages: 118
Registered: January 2011

Senior Member

Thanks for your kind help.

Regards,
Shanie

Report message to a moderator

Previous Topic:	TRACEFILE in report10g
Next Topic:	Need help with averages across the columns

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 16 06:11:36 CDT 2024