Solved

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

Posted on 2008-06-12
6
528 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
6 Comments
 
LVL 101

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 101

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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

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 101

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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Jaspersoft Studio is a plugin for Eclipse that lets you create reports from a datasource.  In this article, we'll go over creating a report from a default template and setting up a datasource that connects to your database.
I recently went through setting up a JasperReports Server using the AWS EC2 instance, and this article will cover some basic administration tasks I had to perform.
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…
In this video, viewers will be given step by step instructions on adjusting mouse, pointer and cursor visibility in Microsoft Windows 10. The video seeks to educate those who are struggling with the new Windows 10 Graphical User Interface. Change Cu…

688 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