| Oracle Reports 6i [message #78605] |
Tue, 05 March 2002 08:29  |
kiran kumar
Messages: 17
Registered: June 2001
|
Junior Member |
|
|
question1
how can i get a Report which has 2 columns repeated in all the pages and rest of the
columns are continuous, Oracle Reports 6i and Oracle 8.1.7 are used for developing this
reports
My requirement is something in the format mentioned below
In ReportPage1 I have
col1 col2 col3 col4 col5
In ReportPage2 I have
col1 col2 col6 col7 col8
In ReportPage3 I have
col1 col2 col9 col10 col11
so in the above case col1 & col2 have repeated in all the pages and rest of the columns keep changing.How do i do such type of report
Thanks in advance.
kiran
|
|
|
|
|
|
| Re: Oracle Reports 6i [message #78641 is a reply to message #78605] |
Wed, 06 March 2002 23:41  |
pratap kumar tripathy
Messages: 660
Registered: January 2002
|
Senior Member |
|
|
1. one option is to create different queries for different page
2. second option is to create query like this
select col1 col11,
col2 col21
col3,
col4,
col5,
col1 col12,
col2 col22,
col6,
col7,
col8,
col1 col13,
col2 col24
col9 ,
col10,
col11,
from .............
means selecting col1,col2 3-times and then displaying like this
In ReportPage1 I have
col11 col21 col3 col4 col5
In ReportPage2 I have
col12 col22 col6 col7 col8
In ReportPage3 I have
col13 col23 col9 col10 col11
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
