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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Sub-report formatting

Status
Not open for further replies.

LT2

MIS
May 24, 2006
232
US
Using CRXI and SQL Svr

I have a report grouped by LOC that includes 5 sub-reports each placed in a report footer.

In the main report just like the sub-reports, I use a flag to end the printing of the page header beginning with RFa where @True - is placed.

Code:
whileprintingrecords; 
booleanvar flag:=true;


@False - is placed in both the report header and page footer.

Code:
whileprintingrecords; 
booleanvar flag:=false;


The Page Header contains the following:

Code:
whileprintingrecords;
  booleanvar flag:
  flag =true

All report footers of the main report with the exception of RFa do not have 'New Page After' checked.

All sub-report footers do not have 'New Page After' checked on RFc which is the last footer for each report.

All reports include the following which are placed in the Page Footer:

@ReportFileName - To display report name.

Code:
StringVar Array File:=Split (Filename, '\');  
NumberVar i := Ubound(File); 
File[i];

@ReportCreated - To display report creation date

Code:
"Creation Date: " & Totext(filecreationdate)

1)Why do I see a page in between each sub report that displays just the Page Header?

2)Why doesn't the ReportFileName and ReportCreated display on the subreports?

Your time is appreciated.
LT
 
since no one else has answered, i'll try to help.

1. Have you suppressed/hidden all the unused sections in the subreports and shortened up any "deadspace" in the used sections? i find that i forget to tidy up the used sections and it creates a lot of white space.

2. when you run the subreport alone, do your fields reportname and filename show correctly?
 
1) Select the subreport(s)->right click->format subreport->uncheck "Keep Object Together".

2) Place the two formulas in the page footer of the main report, not in the subreport where there ARE no page footers.

-LB
 
Yes Tatertot (cool name),

1)All sections are suppressed on all sub-reports with the exception of RFb & c and the Page Footer.

2)Yes, all the sub-reports run nicely independently.

LB,

1)Did as you said and now the Page Header displays on every page.

2)I removed the formulas from the sub-reports and left on the main page. Didn't realize page footers of sub-reports don't exist. Any suggestion aside from manually entering the file name to display somewhere on the sub-report?

-LT

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top