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.
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.
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.
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
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
ASKER
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?
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
It was at one point but has been turned on and off several times now
Is the link used for record selection in the subreport?
Is the subreport saved with data?
mlmcc