Subreport not displaying data

Question

My Crystal Report is generated in Visual Studio 2008. I've linked the subreport parameters and everything runs fine when I run it from the report previewer within visual studio.

But when I deploy the report to the production server, the sub-reports don't have any data at all, even though the main data runs fine. What might be causing the subreports to stop working on the production server?

Answer 1

• Right click your subreport
• Open "Change Subreport Links"
• Make sure you have chosen one field from the "Available fields" section.

Answer 2

1. Did you check DataSources for main report and sub report?
2. Did you check if sub report is embedded in the main report?
3. Did you deploy the Sub report if it is not embedded?
4. How many and what kind of parameters do you use Dates, Strings, Integers ...
5. What is the error do you get? This should give you some directions where to look for a problem.
6. Can you try some other sub reports instead of the failing one.

And finally, use the old computer trick. Remove the sub report and then create/embed it again.

Answer 3

In case you have parameters in your report: Have you tried showing the report from code instead of previewer? Is that different? If yes then probably there's a mismatch between your data input from code and previewer

Answer 4

I was facing same issue and changed my code from this:

for (int i = 0; i < SbRptDtSrcs.Count; i++)
{
    rpt.Subreports[i].SetDataSource(SbRptDtSrcs[i]);
}

to:

rpt.Subreports["rpt1.rpt"].SetDataSource(SbRptDtSrcs[0]); 
          
rpt.Subreports["rpt2.rpt"].SetDataSource(SbRptDtSrcs[1]); 


     

and it worked.