Solved

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

Posted on 2008-06-12
6
457 Views
Last Modified: 2013-11-16
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.
0
Comment
Question by:alfamale
  • 3
  • 3
6 Comments
 
LVL 100

Expert Comment

by:mlmcc
ID: 21771664
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
0
 

Author Comment

by:alfamale
ID: 21776548
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.
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 21776665
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
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 

Author Comment

by:alfamale
ID: 21777274
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?
0
 
LVL 100

Accepted Solution

by:
mlmcc earned 500 total points
ID: 21782975
It could be.  Is REIMPORT ON OPEN checked in te subreport format of the main report?

mlmcc
0
 

Author Comment

by:alfamale
ID: 21792250
It was at one point but has been turned on and off several times now
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

1. Set up your parameter at the report level as usual, check the box Multi-value, and set the Data Type to String 2. Set the Stored Procedure Parameter to varchar(max)  --<---- This part here is the key to it's success Example:    @cst_key var…
I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
As a trusted technology advisor to your customers you are likely getting the daily question of, ‘should I put this in the cloud?’ As customer demands for cloud services increases, companies will see a shift from traditional buying patterns to new…

867 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now