Hi,
Is it possible to place a subreport in the report footer? I find that a subreport will only work when placed in a group or the details section.
Thx
D. "I want to play..."
(Guess the episode!)
I have a linked subreport placed in the report footer using the parameter field from the main report. All I want to do (to start with at least) is reproduce the data from the main report in the subreport, however every time I prompt for new parameter values my main report is populated correctly but the subreport comes out with no records!
Perhaps you know of a workaround to this? I was thinking of placing the subreport in the group footer and conditionally supressing it so it printed only once at the end??
Ta,
D. "I want to play..."
(Guess the episode!)
I don't really understand what it is you are doing with the subreport....is it a summary of values created in the main report??
if so...why don't you just collect the data you need and save it to variables while in the main report then using formulas just display the results in the report footer.
Something to test your subreport with.. Save the subreport by itself outside the main report and try running it and see if it populates. It could be the linking you are using and the first place I'd check is your record selection criteria within the subreport.
-Bruce Seagate Certified RCAD Specialist.
-Bruce Thuel-Chassaigne
roadkill150@hotmail.com
The subreport populates fine with the {?pm-...} default parameter and the parameter selection box informs me the main and subreport views will be refreshed. The parameter is a date range and I have to change the subreport's parameter format from a single date/time to a date range to match the main parameter field (thought it may have to do with inconsistent datatypes).
However my main question is, do subreports work in a report footer? Or does the location of it matter? All the examples I have seen place the subreport in the detail or group footer section.
Thx
D. "I want to play..."
(Guess the episode!)
location matters if the subreport is linked to data returned by the query generated by the Crystal Report itself...if the subreport is independant of the data returned, you can place it anywhere...the page footer or report footer if you want Jim
If the subreport is coming back with no data and your only condition is the parameter from the main report, you may not be passing the condition for some reason. Try creating a shared variable in the header of the main report that accepts the value of the parameter. Then pull the subreport on the condition of the shared variable rather than the parameter.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.