Sub-Report is blank in CR Server

[smilbert]

I'm using Crystal XI (with Crystal Server) 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 stand-alone CR (including on the CS Server). However, when I run through the CR Server, all of the sub-report data is blank. (Blank Subs are supressed by default, but I even tried showing them--and there is no data in them).

I also tried importing ONLY the sub-report (with an Exam ID parameter) to make sure that the CR Server could communicate with the SQL server, and it works fine.

Any ideas? Do you need any more info?

 

[groggle]

Is the data source for the subreport an ODBC connection to tables or views or something else? (stored proc or something else)