Link to home
Create AccountLog in
Avatar of alfamale
alfamale

asked on

How do I automatically refresh the data displayed in a subreport?

I have a Crystal report which includes a subreport.

Both reports are written against field definition files. The subreport does not display data from the recordset passed to it unless I set it as an on-demand subreport (in the main report, right-click the subreport, select format subreport, select subreport tab and check the on-demand subreport checkbox).

My clients do not want to have to click on a link in the main report in order to view the subreport data.

I have written subreports before but not against field definition files.
Avatar of Mike McCracken
Mike McCracken

Is the subreport linked to the main report?
Is the link used for record selection in the subreport?

Is the subreport saved with data?

mlmcc
Avatar of alfamale

ASKER

It is an unlinked subreport and the data is not saved with it. The data was originally saved with it but I unchecked that option.

When the report is run from the application, the main report displays the data correctly but the subreport simply displays the data from the field definition file UNLESS I set it as an on-demand subreport in which case the data for the subreport displays correctly.
Was the subreport added as a separate report or did you build it in the main report?

When you unchecked the saved data was it while editting the main report or just the subreport?

DId you reimport the subreport after turning off saved data

mlmcc
Hi there,

I'm not sure what you mean by the first question: the subreport was built as a report and then added as a sub-report to the primary report rather than created from within the primary report; ie, it already existed before it was added as a subreport.

Save data was unchecked whilst editing the subreport from within the primary report; ie, I double-clicked on the subreport from within the primary report to edit it, selected the subreport tab and then unchecked save data with report.

Yes, the subreport was reimported.

Have just opened the subreport as a seperate report and Save Data was still checked - could this be the issue?
ASKER CERTIFIED SOLUTION
Avatar of Mike McCracken
Mike McCracken

Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
See answer
It was at one point but has been turned on and off several times now