• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1070
  • Last Modified:

Oracle Reports - Creteria In first page data after that

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


1 Solution

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

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

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

hope this works!
(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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now