Home » Developer & Programmer » Forms » Oracle Reports 6i
Oracle Reports 6i [message #78605] Tue, 05 March 2002 08:29 Go to next message
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 #78625 is a reply to message #78605] Wed, 06 March 2002 03:48 Go to previous messageGo to next message
pratap kumar tripathy
Messages: 660
Registered: January 2002
Senior Member
is the data is being selected from one table ?

why do not u create different queries from different page.

can u explain more about the table structure and how many column is there .
Re: Oracle Reports 6i [message #78641 is a reply to message #78605] Wed, 06 March 2002 23:41 Go to previous messageGo to next message
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
Re: Oracle Reports 6i [message #79386 is a reply to message #78605] Wed, 05 June 2002 05:33 Go to previous message
Mrityunjay Jha
Messages: 1
Registered: June 2002
Junior Member
I think format trigger should solve ur problem
U can write in format trigger that for first page col6, 7 ,8,9,10,11 as false
and col 3,4,5 as true
Previous Topic: clear fields in a tabular form
Next Topic: To directly run the oracle report for forms without any interface
Goto Forum:
  


Current Time: Sat May 25 12:40:03 CDT 2024