Skip to Content

How to Schedule/View BI Server hosted reports from a .Net Web Application

I'm working on a .Net Web Application that needs to be able to run and view Crystal reports the reside on a BI Server. I've been told that I should be using Cryal Reports for Visual Studio and that I should use the InfoObject model to schedule the reports to run immediately and then view the resulting instance once it completes. But I'm having a hard time finding any documentation/examples/tutorials to help me figure out how to do this. Can someone please point me in the right direction?

Thanks,

John

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Dec 05, 2018 at 03:28 PM

    You would only use the Crystal Reports for Visual Studio SDK if you're on BusinessObjects (BOBJ) 3.1/Crystal 2008 or older. If you're on a newer version of BOBJ (4.x) and Crystal 2011 or newer, the code to connect to BOBJ was taken out of the Crystal for VS SDK and is only available in the BOBJ .NET SDK. This is available as an option in the Client Tools install and is also available as a separate .NET Runtime install.

    Here's what you'll need to do to get the functionality you're looking for:

    1. Log in to your BOBJ system in your application to get a serialized session or a session token. This can be done either through the .NET SDK or using the new RESTful Web Services SDK.

    2. Get either the SI_CUID or the SI_ID value for the report you want to display. If Promotion Management is being used to move reports from a lower environment to Production, the SI_CUID value will remain the same in all environments and the SI_ID value will potentially change between environments.

    3. Build an "OpenDocument" url that uses the information from steps 1 and 2 to open a viewer that contains the selected report.

    I have sample C# code on my website that should get you started - it's older code, but the login information will still work. You can find it at http://www.dellstinnett.com/sample_code.html. Look for "Code for BOECommonInfo Assembly".

    Documentation for building an OpenDocument call is available at https://help.sap.com/viewer/p/SAP_BUSINESSOBJECTS_BUSINESS_INTELLIGENCE_PLATFORM. Search for OpenDocument. At least one of the results will be for a document named "Viewing Documents Using OpenDocument". This is where you'll find the information you need.

    -Dell

    Add comment
    10|10000 characters needed characters exceeded