Web reports w/ subreports using crystal 8.0?

[Bontebok]

Hi All,

Recently a contractor developed a report that uses a subreport to drill into unrelated data. Unfortunately it is too late to avoid this report as he has already shown it to too many people. As a result, I have been told to put it on the intranet (using rptserver.asp).

The main report runs just fine, but when the user attempts to drill down into the subreport, the progress bar in the activex viewer flashes, but nothing happens. Does anyone know if this is even supported through the web, and if so, how do I make it work?

Thanks,
Bontebok

 

[Bontebok]

Solved!

When I changed the subreport from an on-demand subreport to a regular one, it crashed the activex viewer when it ran. I ran ethereal and captured the packets coming back from the rptserver.asp, I found the following error:

CRXDRT Error Occured on Server. -2147192184 : Server has not yet been opened.

I found this PDF file on Crystal's website with troubleshooting help:

http://support.businessobjects.com/communitycs/technicalpapers/cr_server_not_yet_been_opened.pdf

Although the document didn't immediately help, it indicated that it could be a credential problem. Even though the report runs inside of the Crystal Reports Designer, I wondered if it was that the RDC needs credentials supplied for each table in the subreport.

I downloaded this piece of code from Crystal which has a sample VB app that opens a subreport and does something with it:

http://support.businessobjects.com/communityCS/FilesAndUpdates/cr8_vb_rdc_print_drilldown.exe.asp

Upon looking through the code, I found a method called OpenSubreport() that can be called against an open report object. I tried this, supplying it with the name of the subreport and it worked, it returned a report object. I then passed credentials via the .Database.Tables.Item(1).SetLogonInfo() and...

It worked! I can now view the web report and click on a subreport link and the subreport opens in a new tab in the activex viewer. I can do this over and over for each subreport drilldown.

Bontebok