?
Solved

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

Posted on 2008-06-12
6
Medium Priority
?
550 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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 

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 2000 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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

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. …
Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.
Suggested Courses

800 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