Iloveoracle
Programmer
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
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