CrystalReportViewer VS2010 Need to load report without repository

[Former Member]

I've created a report with Crystal using our Universe and Warehouse. I ran the report and then saved it with the data and uploaded it to our website. When I try to view that report using the CrystalReportViewer is gives an about loading the report failed. The inner exception appears to be "failed to logon to crystal reports object repository".

The web server isn't on our local network and doesn't have access to the universe or warehouse. I was hoping to use the viewer to just view the report and allow printing/exporting without the ability to refresh it.

Is there some special way to load the report that would allow me to view the saved data without it needing a database connection??

[Former Member · Accepted solution]

It's 13.0.2000.0 and I'm currently doing all my testing with the machine that has VS2010 and I installed the CR for VS2010 package on.

[Adam_Stone · Accepted solution]

If you have anything in the report that is from the repository, or uses a connection to a Universe or Business View you cannot load it without having a connection to Enterprise. If you want to run this report without being connected to Enterprise you will need to redesign it.

[Former Member · Accepted solution]

That wasn't really the answer I was hoping for, but thanks anyway.

Is that limitation only with the VS2010 version, or would I have the same problem with the VS2008 version?

[Adam_Stone · Accepted solution]

All versions. If you design the report using Enterprise functionality, you need Enterprise for it to function.

[Former Member]

Thanks for the responses.

I'm using BO Edge 3.1 with CR 2008 and CR for VS2010. The Viewer is embedded into a DotNetNuke module.

I attempted the suggestion you gave and opened a Crystal Report instance we have in InfoView. I then exported it as a RPT and saved it to the website. When I tried to open the report on the web site using the viewer I got the 'Load report failed' error.

The snippet from the code that loads the report is:

Dim fi As New IO.FileInfo(ResolvedPath)
If fi.Exists Then
    Dim rd As New CrystalDecisions.CrystalReports.Engine.ReportDocument
    rd.Load(ResolvedPath)

    ctlReportViewer.ReportSource = rd
End If

If I step through this code I get an exception at the rd.Load() statement with the Inner Exception being:

Error in File Test4 {84D370D0-179F-47C6-B95B-8805DC804A4B}.rpt:

Failed to logon to the Crystal Report Object Repository.

Based on other articles I've checked that C:\Windows\Temp folder has permissions for the ASP user. I've also created a basic report that just pulls in data from a table on the local sql server using an OLE DB connection and that loads and displays fine. I only seem to have a problem so far if I'm trying to load a report that was built using the universe connection.

Any ideas?

[former_member11696]

Hello,

What version of the Cr assemblies are you using in your project?

Don

[former_member11696]

There is no connectivity to BOE through CR for VS 2010 which is the only supported version of CR in VS 2010.

Only way I can suggest is to Schedule the report in BOE and export it to RPT format which has saved data. Assuming you are using this report in BOE, exporting it to a common folder then your app can open it through code ( unmanaged ) and the users can preview it. If you want to use the RPT file and exporting to RPT is not an option the use the PDF option.

You can get to the RPT with saved data then disable the refresh button in the viewer.

Thank you

Don

[former_member183750]

What version of CR are you using?

Follow us on Twitter http://twitter.com/SAPCRNetSup

Got Enhancement ideas? Try the [SAP Idea Place|https://ideas.sap.com/community/products_and_solutions/crystalreports]