Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: page footer for subreport Post Reply Post New Topic
Author Message
abhijeetp
Newbie
Newbie


Joined: 06 May 2008
Online Status: Offline
Posts: 5
Quote abhijeetp Replybullet Topic: page footer for subreport
    Posted: 19 May 2008 at 3:36am
I have a main report and in detail section i have a subreport.
parameters are passed from main report to subreport.

now in the subreport i have

reportHeader
GroupHeader:@FakePageHeader
Detail
GroupFooter:@FakePageHeader
reportFooter

-------
formula  @FakePageHeader  has code as

WhileReadingRecords;
1

by grouping on this field i created fake page header and checked option
repeat group header on each page. that displays group header on each page, but not the group footer.

but i want some fix text on each page of subreport, same as group header.

AS My detail section has dynamic text which can span 2-3 pages so that i cant put check on line numbers count and show footer at the page bottom.
i refered link
http://technicalsupport.businessobjects.com/KanisaSupportSite/search.do;jsessionid=234750D86C34C128C8551DFABDC5C37D?cmd=displayKC&docType=kc&externalId=c2014229&sliceId=&dialogID=360384&stateId=1%200%20356275

but is for fixed row numbers.

please help me out.
thanks in advance.





Edited by abhijeetp - 19 May 2008 at 3:46am
IP IP Logged
Lugh
Senior Member
Senior Member
Avatar

Joined: 14 Nov 2007
Online Status: Offline
Posts: 377
Quote Lugh Replybullet Posted: 19 May 2008 at 5:19am
Ouch.  You have a tricky problem.

As a possible solution, have you tried creating a second fake page header, and selecting "Print at Bottom of Page" in the Section Expert?  I don't know if that would actually work, but it might.

The only other approach I can think of is to somehow break up the text into roughly page-size segments with a formula.  Precisely how you would go about this, I don't know.


IP IP Logged
abhijeetp
Newbie
Newbie


Joined: 06 May 2008
Online Status: Offline
Posts: 5
Quote abhijeetp Replybullet Posted: 19 May 2008 at 6:26am
thanks for ur reply.
 
"have you tried creating a second fake page header, and selecting "Print at Bottom of Page" in the Section Expert?"
 
this will not work as it will show "first phake header" then blank spance then "fake groupheader two" at the bottom ..then on next page fake group header one and then rest content.
 
 
second approch will also not work for me as detail content is html text and its dynamic. i dont know how much lines it will span, then also i want footer text on every page of that subreport.
 
 
any ideas?
IP IP Logged
Karty
Newbie
Newbie
Avatar

Joined: 07 Aug 2012
Location: India
Online Status: Offline
Posts: 7
Quote Karty Replybullet Posted: 29 Nov 2012 at 11:44pm

To create fake page footers in subreports you need to insert and format a second Details section and a second Report Footer section.
These sections will act as page footers.
You must decide how many records you want per page.
The number of records must be static, as must the fields.
The 'Can Grow' option cannot be selected for any fields.
It is also recommended that you have a static number of groups per page.
The following example creates ten records per page in the Details section without any groups

1. Right click the gray area to the left of the Details section and then click 'Insert Section Below'. You will now have a 'Details a' and a 'Details b' section.
2. On the 'Report' menu, click 'Section Expert'.
3. Click 'Details' (not 'Details a' or 'Details' b) and then click the 'X+2' button next to 'New Page After'.
Insert the following formula in the 'Format Formula Editor':

Remainder(RecordNumber, 10) = 0 Click the 'Save and Close' button.
(This ensures the subreport will have 10 records per page. Change the second argument of the Remainder function in every formula to the number of records you want to see per page.)

4. In the Section Expert, click 'Details b' and then select the 'Print at Bottom of Page' check box.
Then click the 'X+2' button next to 'Suppress (No Drill-Down)'.
Insert the following formula in the 'Format Formula Editor':

Remainder(RecordNumber, 10) <> 0 Click the 'Save and Close' button.
(This makes the 'Details b' section appear at the bottom of each page, every tenth record.)

5. In the Section Expert, click 'Report Footer a' and then select the 'Print at Bottom of Page' check box.
Then click the 'X+2' button next to Suppress (No Drill-Down).
Enter the following formula in the 'Format Formula Editor':

Remainder(RecordNumber, 10) = 0 Click the 'Save and Close' button.

6. Click 'OK' to close the Section Expert.
7. Insert fields and other objects that you want in the fake page footer into both the 'Details a' and 'Report Footer a' sections. Format these two sections so that they are identical.

When the report is previewed, the subreport will have ten records per page with the 'Details b' section at the bottom of each page acting as the page footer. If the last page has less than ten records, the 'Report Footer a' section will act as the page footer instead.


Thanks
Karty
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.016 seconds.