Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

FOOTER SECTION BLANK AFTER SOME PAGES IN A REPORT WITH MANY LAYOUTS

Status
Not open for further replies.

Iloveoracle

Programmer
Oct 2, 2006
22
US
Hi ,

I have a problem with footer frame.The 4data field values in the footer frame will display in each page at the end of the page.But in my report only 3 values are coming in all pages,one value i.e approved_date field ,not showing in the last page .My report design will give multiple reports for a given set of system _ids.If I give only one system_id then all 4 values will display in all pages at the end of each page.If I give more then one system_id ,then it won't show the approved_date value in
the last page of the report.

For example system2 is having date 03-NOV-06 and system 4 is not having any date,then if we want to display details for system2 and system4,it will display date for system2 in all pages except last page.For system4 report looks ok.

Now we consider two more systems like system1 with no date value in the database and system3 with 06-DEC-06.Now my report works like this:

1.If we pass system1 and system4 then report works fine
2.If we pass system2 and system3 then report works fine
3.If we pass system1 and syste2 then report won't look
nice
4.If we pass system2 and system1 then report won't
looks nice
5.Even if I pass single system_ids then also report works fine.
Please help me to show the date in all pages in the footer frame.

Thanks
GP





 
Two questions:
How do you pass multiple system IDs?
How do you control showing and hiding of date fields based on system ID or IDs?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top