Difference OpenDocument Crystal Reports and WebI

I experienced some frustations when trying to open 2 different reports (Crystal Reports and WebI), however both were built on same universe and used same objects, from the same URL button in Xcelsius.

The OpenDocument statement for the WebI report was quickly set up, however the Crystal Reports took some time. Even after consulting chapter 3 Crystal Reports in the PDF Viewing Reports and Documents using URLs (for BOXI 3.1) I could not get it to work.

Finally I figured it out by reading several forum topics, in the end the URL was built as follows:

../../../OpenDocument/opendoc/openDocument.jsp?

Crystal Command Value Function
&s no idea why used
&sType= rpt Identifies Crystal Reports report
&iDocID= 1234 ID of report (not CUID!)
&OutputFormat= H H stands for HTML, unfortunately in 3.1 pdf is not supported anymore
sWindow= new forces reports to open in new window
isApplication= true Keeps Xcelsius dashboard “alive”
&promptex-CustomerCode= “0019″ CustomerCode is name of prompt, 0019 is customer code value, note “” to identify string
WebI Command Value Function
sPath= [QS Dashboards] foldername in Infoview, don’t forget []
&sIDType= CUID identification type, preferred in OTAP streets
&iDocID= AX9_uZS0zyVAhum8a2SnaaM CUID of report
sWindow= new forces reports to open in new window
isApplication= true Keeps Xcelsius dashboard “alive”
&lsSCustomerCode= 0019 CustomerCode is name of prompt, 0019 is customer code value
Recent Related Posts
Femke Kooij is a dashboard and report designer, developer and educator specializing in SAP | BusinessObjects Dashboards (better known as Xcelsius) and Crystal Reports. She has also a lot of experience with other SAP | BusinessObjects toolings like, Web Intelligence (WebI), Information Design Tool (Universe Designer), BusinessObjects Data Services (BODS) and the overall server platform BusinessObjects Enterprise (Launchpad, CMC). She spends a lot of her time thinking about and sharing her knowledge of Xcelsius to others through her own blog. Lately she is exploring other visualization tools like Qlikview and Tableau. On the later she is also posting some experiences. Currently she is in the employment of Cognizant Technology Solutions. Her blog only contains her personal views, thoughts and opinions. It is not endorsed by Cognizant Technology Solutions nor does it constitute any official communication of Cognizant Technology Solutions.

This entry was posted in Crystal Reports, OpenDocument, Xcelsius and tagged , , , . Bookmark the permalink.

4 Comments to Difference OpenDocument Crystal Reports and WebI

  1. I like your posting. Thanks for your posting.

  2. Pingback: Kylie Batt

  3. JR Beltman says:

    The SAP BO Open Document manual for Crystal does make some sense, especially from page 13 onwards.

    I is a good read for those that wish to find out all possible parameters of the opendocument function for Crystal Reports.