Changing datasources

[Former Member]

Hi Team,

I have a wierd issue. I have reports with multiple groups. In all the reports, one of the groups is a formula for dynamic sorting based on the user input.

So far, everything works fine. Now, the issue is as below.

1. I've ran the report from Crystal Reports 2008 against DataSource1

2. I publish this report to BO server and configure Database credentials to point to DataSource2

3. When the report in scheduled from Infoview, the report fails with the error Invalid Group condition

4. If I remove the group for dynamic sorting, the report runs fine even when I switch from DataSource to other

5. One more observation is if I remove all other groups and have only the group for dynamic sorting, even then the report runs fine

The report fails only with the combination of dynamic sorting formula combined with groups in DB fields.

Please do give your valuable thoughts to get this fixed.

Thanks

Naresh

[former_member292966 · Accepted solution]

Hi,

What version of Crysal 2008 are you running and what version of BO Server are you running?

I ran into a similar problem where it runs fine in the designer but from InfoView it fails.

I found out the problem was fixed in Crystal 2008 but the same fix has not been done in BO Server. To get around the problem, I installed Crystal 2008 with the same service pack onto the same machine as BO Server and that fixed the problem.

Good luck,

Brian

[Former Member · Accepted solution]

Thanks for the suggestion Brian!!

I did checked for the service packs and fix packs on CR2008 and BO Server and they are in sync. But, the issue still persists.

Any other thoughts will be of great help.

Thanks

Naresh

[former_member11696 · Accepted solution]

Open the report up and manually set it to DataSource 2 and then publish it to verify the report does work properly.

Thank you

Don