Home » Developer & Programmer » Reports & Discoverer » Footer Problem (Oracle 10g Database(10.2.0.3.0), Report 6i(6.0.8.8.3), Windows XP)
Footer Problem [message #346629] Tue, 09 September 2008 03:18 Go to next message
brijal_j_patel
Messages: 28
Registered: May 2007
Location: Surat,India
Junior Member
Dear Tech Leaders,
I have one Problem in Report. In my report, Monthly employee salary details shown like following
Emp code, Gross salary
E001,       4000
E002,       3000
PageTotal : 7000/-
[B]GrandTotal: 7000/-
Grand Total in Words : Seven thousand only,[/B]

I want to get this output. But if I get Page-Total then my grand-Total not shown on last page(or even any page. I am attaching rdf for it.
Create following Table, to run report
create table saltran
(empcode varchar2(6),
salmonth varchar2(6),
grosssal number(10,2)
)
Re: Footer Problem [message #346643 is a reply to message #346629] Tue, 09 September 2008 04:05 Go to previous messageGo to next message
Littlefoot
Messages: 20897
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
"Grand total" is displayed when I run your report. This is (a slightly modified) report output:

./fa/4983/0/

So, what exactly doesn't work in your case?
Re: Footer Problem [message #346657 is a reply to message #346629] Tue, 09 September 2008 04:35 Go to previous messageGo to next message
brijal_j_patel
Messages: 28
Registered: May 2007
Location: Surat,India
Junior Member
Thanks a lot in advance, How u do it?
I want to know what a slight modification u done.
U have not sent rdf file with change. So I still confuse.
Re: Footer Problem [message #346661 is a reply to message #346657] Tue, 09 September 2008 04:50 Go to previous messageGo to next message
Littlefoot
Messages: 20897
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I did nothing special, just removed empty space between the lines and aligned numeric fields to the right (all in Paper Layout Editor).
Re: Footer Problem [message #347001 is a reply to message #346629] Wed, 10 September 2008 06:55 Go to previous messageGo to next message
brijal_j_patel
Messages: 28
Registered: May 2007
Location: Surat,India
Junior Member
Thanks LittleFoot sir,
I also change same as u told and it work fine here. But Now i have other issue.
I want page number must appear at bottom of all pages. So I added other frame bellow Last Label Containing Frame. and Put Page number field there. But it come on last page only. I want it must come on all pages
Updated file is attached.
Regards
Brijal
Re: Footer Problem [message #347116 is a reply to message #347001] Wed, 10 September 2008 15:45 Go to previous messageGo to next message
Littlefoot
Messages: 20897
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
It is easier to do that by selecting the Insert menu - Page Number - choose where to put it (bottom-center, for example).

By the way, F_1 (which is supposed to display page number) field's "Print object on" property is set to "First page". Why, if you want to display it on every page?
Re: Footer Problem [message #347178 is a reply to message #347116] Wed, 10 September 2008 23:55 Go to previous message
brijal_j_patel
Messages: 28
Registered: May 2007
Location: Surat,India
Junior Member
I have change property of F_1 to All Pages but the result is same. It come on last page only. By the way if u notice M_2 Frame property, it is all ready set to All Pages like M_1 and component inside M_2 frame's Property set to first page, still u can see M_1 Frame appear on all pages while M_2 come on Last Page only.
If u move M_2 between M_G_EMPCODE_FTR and M_1 then it work fine. Means M_1 and M_2 come on every page and M_G_EMPCODE_FTR come on last page.
But in my case I
(This is demo report, I want this functionality in other complex report.)
Previous Topic: Preview window
Next Topic: how to design vertical line in rdf
Goto Forum:
  


Current Time: Wed Dec 07 10:49:08 CST 2016

Total time taken to generate the page: 0.10001 seconds