Solved

Oracle Reports - Creteria In first page data after that

Posted on 2006-11-29
4
1,064 Views
Last Modified: 2013-12-12
hi all,

I would like to request your help for solving a scenario i am having in oracle reports 6i.

i have a report having data spanned to multiple pages.

i have a new requirement. In the first page i need to print the report Creteria. (Contains the parameters i am passing thru forms)

 (This should appear on first page only) After that from second page onwards i need to print the data.


how can i do this ..

Please help me.

Best regards

Rajesh

0
Comment
Question by:rajeshnalankal
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 
LVL 12

Accepted Solution

by:
jwahl earned 250 total points
ID: 18037099

1)
in layout editor select all objects (frames, fields, text, ...) and move them down to create free space for the parameters.

2)
on the first frame set the property "page break before" to Yes.

3)
on top of the page create fields to display the parameters. set source property to the desired parameter fields.


hope this works!
0
 
LVL 13

Expert Comment

by:riazpk
ID: 18291928
(1) Create a simple frame and put parameters inside that frame.

set "Print Object On" propoerty to First Page.

(2) Create repeating Frame(s) and put the data items which you want to display on your report.

For the first repeating frame, set "Page Break After" property to Yes
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
Via a live example, show how to take different types of Oracle backups using RMAN.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

717 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question