Solved

Crystal Reports sub-report is blank

Posted on 2014-09-30
5
207 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

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
location of a form 2 25
how to check group permission on a file located on a remote server ? 3 24
Open a link in vb.net 2 15
Get month and date in a format 4 31
A basic question.. “What is the Garbage Collector?” The usual answer given back: “Garbage collector is a background thread run by the CLR for freeing up the memory space used by the objects which are no longer used by the program.” I wondered …
Recently while returning home from work my wife (another .NET developer) was murmuring something. On further poking she said that she has been assigned a task where she has to serialize and deserialize objects and she is afraid of serialization. Wha…
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

840 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