Print Records On Pages based on column value [message #655170] |
Tue, 23 August 2016 05:53 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/6272d1ecd8029af93c672708e84d08d4?s=64&d=mm&r=g) |
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 message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21811 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.
|
|
|
|
|