OraFAQ Forum: Reports & Discoverer » Print Records On Pages based on column value

Home » Developer & Programmer » Reports & Discoverer » Print Records On Pages based on column value (Oracle reports 10g, Windows 7)

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

Print Records On Pages based on column value [message #655170]

Tue, 23 August 2016 05:53

sanku
Messages: 2
Registered: August 2016

Junior Member

Hi all,
I need to do a report such that each record should be printed on pages based on column values. that is if i have a column named e_id with values (1,2.3,1,5,3 etc), i need to print records with value 1 on page number 1 (2 records in this case) and 2 on page 2, 3 on page 3 etc. Is there any way to achieve this.

Thanks in advance.

Report message to a moderator

Re: Print Records On Pages based on column value [message #655175 is a reply to message #655170]

Tue, 23 August 2016 16:00

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

Senior Member
Account Moderator

What a strange requirement ...

Here's what I'd try: I'd use E_ID column as a group column (which means that it would be, for example, a "Group Above" layout). It could also be used as a page number (such as "Page &E_ID"). Furthermore, as you'd want to display all separate E_IDs, I guess that you should use that column twice in a query:

select e_id group_e_id,
       e_id separate_e_id,
       other_columns_here
from your_table
where ...

In Data Model layout, click and hold GROUP_E_ID and drag it out of its current group in order to create its own group. Let the Wizard create the paper layout.

That's all, I guess.

Report message to a moderator