Subreport with Command calling Stored Procedure with linked parameter blank

[Former Member]

Hi,

I'm currently using Crystal Reports version 11.5.0.313.

I'm creating a standalone report that connects to a SQL Server database. I prompt the user for a few items which builds the parameter used by stored procedures that are called from subreports. The prompt results are concatenated together into a string in a formula which is used to link to the Subreport Command parameter. However, when I enter the prompts, the main report works fine, but all the subreports are blank. If I double click on a subreport, the subreport opens in a new tabbed window and all the data is there as I would expect.

I have other subreports that call stored procedures and do not require any parameters and the data for them show up just fine.

What can I do to make the subreports that use parameters have their data show up in the main report?

Thanks,

Rich

[former_member11696 · Accepted solution]

Hi Rich,

First thing you need to do is install all of the service packs. Start with Service Pack 4 full build and then install SP 5 and 6.

Requires you to uninstall first so make sure you have your keycode handy.

https://smpdl.sap-ag.de/~sapidp/012002523100011802732008E/crxir2_sp4_full_build.exe

https://smpdl.sap-ag.de/~sapidp/012002523100013876392008E/crxir2win_sp5.exe

https://smpdl.sap-ag.de/~sapidp/012002523100015859952009E/crxir2win_sp6.exe

Then test again

Don

[Former Member · Accepted solution]

Don,

Thanks very much! It is now working as I expected it should. Appreciate it greatly.

Rich