Data connection issue in subreports

building reports crystal reports
1

I have few linked sub reports(not on-demand) in my main report. Values have been passed using parameters.

It works fine in Crystal reports and Infoview when I refresh and view directly.

But when I schedule the report in as Crystal report, I am unable to open the sub report. It says ‘Incorrect logon parameters’. :frowning:

There is an option in Crystal to ‘Re-import the sub report on open’ but that is not used here.

Any idea what could be the issue?

Thanks in Advance!

Manimekalai :india: (BOB member since 2007-11-12)

2

Is the subreport using the same connection as the main report?

In the CMC, look at the Database Configuration for the report. Make sure that all of the connections have been set up correctly - if you’ve used a different connection for the subreport, there will be multiple connection names in the top left of the screen.

If that doesn’t work, edit your report and Set Datasource Location to make sure the main and the subreports are using the same connection then republish.

You don’t mention which version of Crystal you’re using or which version of BO or CRS you’re using. Make sure you have the latest service packs/fix packs for both.

-Dell

hilfy :us: (BOB member since 2007-04-16)

3

I am actually having a similar issue, we are using CR2010. Freehand SQL being used in both the Main & subreport.

The subreports don’t seem to be picking the the DB connection, I verified in CMC DB configuration to see that they are both identical (main report & subreport).

Also, they are pointing to the same Data source.

What could be the issue here? Any help would be appreciated.

RayRay83 (BOB member since 2007-11-14)