Solved

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

Posted on 2008-06-12
6
479 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
Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

 

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

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

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

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
Problem Statement In an SAP BI BO Integration project when a BO universe is built on a BEx query, there can be an issue of unit & formatted value objects not getting generated in a BO universe for some key figures. This results in an issue whereb…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

776 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