Home » Developer & Programmer » Reports & Discoverer » Print Records On Pages based on column value (Oracle reports 10g, Windows 7)
Print Records On Pages based on column value [message #655170] Tue, 23 August 2016 05:53 Go to next message
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.
Re: Print Records On Pages based on column value [message #655175 is a reply to message #655170] Tue, 23 August 2016 16:00 Go to previous messageGo to next message
Littlefoot
Messages: 21598
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.
Re: Print Records On Pages based on column value [message #655194 is a reply to message #655175] Wed, 24 August 2016 06:25 Go to previous messageGo to next message
sanku
Messages: 2
Registered: August 2016
Junior Member
"What a strange requirement ..." Laughing . Sadly for me it was an question asked during an interview Sad Sad
Re: Print Records On Pages based on column value [message #655206 is a reply to message #655194] Wed, 24 August 2016 14:07 Go to previous message
Littlefoot
Messages: 21598
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
So, what was YOUR answer?
Previous Topic: Discoverer 11g :Unable to connect oracle application user
Next Topic: how to save report in client pc
Goto Forum:
  


Current Time: Mon Sep 28 23:28:45 CDT 2020