[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

Crystal Reports sub-report is blank

Posted on 2014-09-30
5
Medium Priority
?
255 Views
Last Modified: 2015-01-14
I have a Crystal Report that passes parameters to a SQL Server dataset and extracts the data. This works as intended but I need to add two sub-reports (1) a set of notes to be added to every report & (2) company details to be added to every report.

For the notes I have a data set in Visual Studio 2013 that extracts and previews the data. I added this to a separate Crystal report which is then added as a sub-report to the main report.

The dataset contains the notes (data) but they never appear in the sub-report so what do I need to do to get the data into the sub-report?

Thanks
0
Comment
Question by:Paul-Brooks
  • 2
4 Comments
 
LVL 35

Expert Comment

by:James0628
ID: 40354212
Does the separate report with the notes show the notes when you run it by itself?

 I would assume that you have some parameters in the notes report, to control which notes are included in the report.  Do you have those parameters linked to something (usually a field) in the main report?  if so, are you sure that the links are correct?


 FYI, there is a CR topic here, under Database > DB Reporting Tools.  It's my understanding that you can't change the topics for a question, so I've submitted a request to the mods that they add the CR topic to this question (so that more CR experts are likely to see it).

 James
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 40354563
DO you pass the dataset to the subreport in your code?

mlmcc
0
 

Accepted Solution

by:
Paul-Brooks earned 0 total points
ID: 40371050
In the end I used parameters to pass the data because I realised I had one dataset containing data for the specific invoice and I needed to add two other sets of non-specific data albeit that they would be in sub-reports. This appeared to mean three datasets for each invoice.

It is a heap of parameters, around 20, but it is working.

Thanks for your interest.
0
 

Author Closing Comment

by:Paul-Brooks
ID: 40548541
I was unable make any of the other suggestions work  and my own comment describes the solution I used.
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Question has a verified solution.

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

For those of you who don't follow the news, or just happen to live under rocks, Microsoft Research released a beta SDK (http://www.microsoft.com/en-us/download/details.aspx?id=27876) for the Xbox 360 Kinect. If you don't know what a Kinect is (http:…
Wouldn’t it be nice if you could test whether an element is contained in an array by using a Contains method just like the one available on List objects? Wouldn’t it be good if you could write code like this? (CODE) In .NET 3.5, this is possible…
As many of you are aware about Scanpst.exe utility which is owned by Microsoft itself to repair inaccessible or damaged PST files, but the question is do you really think Scanpst.exe is capable to repair all sorts of PST related corruption issues?
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…
Suggested Courses

613 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