Need Page Footer after it was deleted 1

[sstrobel]

I inherited a Crystal 9 report where the Page Footer was deleted on a supreport. Outside of recreating the entire report (there are number of formulas) is there a way to recreate the page footer?

Thanks,

Steve

 

[synapsevampire]

Deleting a footer won't delete formulas.

Place the formulas back into this additional page footer section (you can't delete a Page Footer, only additional Page Footer sections).

Right click the page footer and selection insert section below, or perhaps it's just suppressed or hidden.

A little Crystal training might be a good thing as well.

-k

 

[sstrobel]

Thanks for the quick post.

I would agree with you that normally you cannot and should not be able to delete the page footer, but for some reason on this subreport, when you bring up the section expert, the page header and footer are not listed.

If there is a way to post a jpg I would be glad to show the what I as saying (a picture is worth a thousand words.)

Thanks,

Steve

 

[GJParker]

Steve

A sub report will never have a page header or footer section, so you cannot delete, createor re-create them.

If you think about it logically a sub report is just a container field placed onto the main report and it is the main report which controls the page printing of the whole report.

What is it you are trying to achieve ? If you let us know what it is you want to do perhaps we could offer solutions.

HTH

Gary Parker
MIS Data Analyst
Manchester, England

 

[sstrobel]

Thanks for the information.

I am trying to get on the bottom of every page a text field that I am conditional suppressing. It is currently in the a group footer, but the group overflows to the following page on occasion.

Thanks,

Steve

 

[GJParker]

If the text field is on the sub report then you will need to use shared variables in order to pass the value to a formula field in the main report Page Footer.

Create a formula in the subreport to hold the text value as a variable

//@TextVal
WhilePrintingRecords;

Shared Stringvar MyString := {TextField};

Then use a formula on the main report (make sure the formula is in as ection after the subreport create a group footer b section if necessary.

//@SubTextVal
WhilepPrintingRecords;

Shared StringVar MyString;

This will return the text field for each group in your main report, this can then be used in the page footer section of your main report, taking into consideration what to do if more than one group appears on a page and the the fact that your field was conditionally suppressed.

If this doesn't fix you r situation, provide information of your report layout, (main and sub), any formulas used including conditional suppression of any fields.

HTH



Gary Parker
MIS Data Analyst
Manchester, England

 

[sstrobel]

Crystal 9
Access DB
Issue: Value of Shared variable is not passed to Page Footer from SubReport located in a Report Footer while printing the pages contained within the subreport.

Other know facts:
-Shared variables are pased to sections below the Subreport that defines the value in question.
-After subreport is completed, page footer does have correct value of variable.
-I inherited the report. Redoing the report is possible, though costly if there exists a better way of laying out report structures.

Desired Outcome:
-Value of shared variable at the end of a page (it can change) within the Subreport is passed from the Subreport to the Main Report/Page Footer and properly evaluated and displayed while the Subreport is being generated.

Thanks,

Steve

 

[synapsevampire]

Ahhh, sorry, I missed that it was in a subreport.

A Page Header/Footer occurs on every page (except if the Report Header exceeds 1 page), Report Footer executes at the end of the report ONLY.

A shared variable is ONLY returned to the main report AFTER the subreport has executed, not during execution. Typically one would place the subreport in it's own section PRIOR to trying to use the shared variable returned by it.

Perhaps you need the subreport to fire in the Report Header?

Rather than posting your current architecture and trying to make it work, consider posting example data and required output, there may be another approach that will make sense to you.

-k

 

[lbass]

It is unclear what you are trying to display in the page footer. Is it standard text that you want to display on all pages where the subreport is printed? Or is the text intended to change on each page, and if so, on what basis? If it is standard text, add a text box to the page footer with the desired text. Create a formula that will be true for all records of the main report, as in {@all}:

{table.customerID} > 0

Then group on {@all}. Insert a copy of your subreport or recreate the subreport (that you have in the report footer) in this group footer (let's call this subreport B) and format the group footer to "New Page Before". Format your subreport A in the report footer by right clicking on it->format subreport->common and uncheck "Keep object together." This will allow the subreport A to immediately follow the group footer containing the other subreport B.

In subreport B, create a shared variable and place it on your subreport B canvas, something like:

whileprintingrecords;
shared numbervar prodid := {table.prodid};

Then suppress all sections of subreport B. Finally, right click the text box containing the desired text->format text->common->suppress->x+2 and enter:

whileprintingrecords;
shared numbervar prodid = 0;

This should cause the text box to only display on the pages containing subreport A (in the report footer).

-LB