OraFAQ Forum: Reports & Discoverer

Home » Developer & Programmer » Reports & Discoverer » Footer Problem (Oracle 10g Database(10.2.0.3.0), Report 6i(6.0.8.8.3), Windows XP)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Footer Problem [message #346629]

Tue, 09 September 2008 03:18

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)
)

Attachment: rpt_salary_paid.rdf
(Size: 52.00KB, Downloaded 1156 times)

Report message to a moderator

Re: Footer Problem [message #346643 is a reply to message #346629]

Tue, 09 September 2008 04:05

Littlefoot
Messages: 21811
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:

/forum/fa/4983/0/

So, what exactly doesn't work in your case?

Attachment: grand_total.PNG
(Size: 2.33KB, Downloaded 1259 times)

Report message to a moderator

Re: Footer Problem [message #346657 is a reply to message #346629]

Tue, 09 September 2008 04:35

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.

Report message to a moderator

Re: Footer Problem [message #346661 is a reply to message #346657]

Tue, 09 September 2008 04:50

Littlefoot
Messages: 21811
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).

Report message to a moderator

Re: Footer Problem [message #347001 is a reply to message #346629]

Wed, 10 September 2008 06:55

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

Attachment: rpt_salary_paid.rdf
(Size: 52.00KB, Downloaded 1133 times)

Report message to a moderator

Re: Footer Problem [message #347116 is a reply to message #347001]

Wed, 10 September 2008 15:45

Littlefoot
Messages: 21811
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?

Report message to a moderator

Re: Footer Problem [message #347178 is a reply to message #347116]

Wed, 10 September 2008 23:55

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.)

Report message to a moderator

Previous Topic:	Preview window
Next Topic:	how to design vertical line in rdf

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jun 28 01:29:16 CDT 2024