Solved

Crystal Reports sub-report is blank

Posted on 2014-09-30
5
199 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
5 Comments
 
LVL 34

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 100

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

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

This document covers how to connect to SQL Server and browse its contents.  It is meant for those new to Visual Studio and/or working with Microsoft SQL Server.  It is not a guide to building SQL Server database connections in your code.  This is mo…
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
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 …
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

920 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

13 Experts available now in Live!

Get 1:1 Help Now