Sub-Report from different database is blank

[smilbert]

I'm using Crystal XI with MS SQL 2000 (two different SQL Servers).

I'll try to give as much info as I can (without writing a novel).

Essentially, I've built a report that lists exams (by exam ID. IF there is information about that Exam ID in another database, that information is shown via a sub-report.

The report works fine in CR, but when I put it in CR Server, all of the sub-report data is blank.

I tried importing ONLY the sub-report, and that works.

Any ideas? Do you need any more info?

Thanks.

 

[Schnappa]

Does the machine where CR Server located have access to the database used in the report, and is it named as it is in the report?

GV

 

[lbass]

You might have better luck in forum782, as the problem only arises upon distribution, and CR Server is a mini-version of CE.

-LB

 

[smilbert]

Thanks for the ideas. I confirmed that the SERVER running this report CAN access all databases.

1) I added the sub-report ONLY (with a parameter) and that works fine.
2) I ran the report on the server in Crystal XI and that works fine with sub-reports.

Any other ideas?

 

[Madawc]

Check the SQL query from the subreport. My guess is that you're doing something non-standard and that the interpretation is different in Crystal Enterprise.



Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10