views:

805

answers:

2

I currently have a crystal report that I'm generating in Visual Studio 2008 which has a sub-report. I've linked the sub-report parameters and when I run the report from the report previewer within visual studio, it runs fine.

HOWEVER

When I deploy the report to my production server, the report runs and the main report has data, but the sub-reports don't have any data at all.

Does anyone have any idea what might be causing the sub-reports to not work on the production server?

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

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

Robert Vuković
unfortunately, the only thing that worked was removing the sub report and creating it again from scratch! arrrhggggghhh so annoying!
lomaxx
+1  A: 

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

PoweRoy