[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1227
  • Last Modified:

URL Reporting in Crystal Enterprise(CE) 10 with single sign on (SSO), authentication type Windows AD

We have been using Crystal Report RAS 9 for some time now and we are planning to migrate all reports to CE10 Crystal Enterprise (CE).  

Currently, to provide users access to the reports in CR RAS 9, we just place a URL within their application that links directly to the reports.  For example, within Cold Fusion web applications we include a URL to call a report (*.RPT) on the web server Crystal Report 9 RAS, then the report is launched in the crystal report viewer and customers can see it or print. See example:   http://MySERVER/crystal/En/ASP/rPortfolio/HTMLViewers/interactiveViewer.asp?ReportName=D%3A%5CCrystal%5CMYDEMO%5CMYFOLDER%5CMYREPORT+%SHEET%2Erpt
 
We are having difficulty determining how to do construct a URL to access the reports published in Crystal Report 10 CE.

We have published the reports via Crystal Wizard version 10.  The published reports are assigned a unique ID within Crystal E-portfolio.  We are also using single sign on (SSO), so our authentication type is Windows AD.

With the new version of Crystal I am unable to capture the URL and submit it from a Cold Fusion application, because it appears to require a logon to the E-portfolio environment.  Then the user has to click on Windows AD as the authentication type, and click login before the report parameter screen will be displayed.  Even if I add the parameter to the URL string for the authentication type of WindowsAD, the user is still presented with the Crystal login screen.  

0
PhilChandler
Asked:
PhilChandler
1 Solution
 
dtaylor92Commented:
use the syntax for "viewrpt.cwr".  This a URL syntax which will allow you to view a report by simply specifying the information on the URL.

Here is the full syntax you can use:  http://support.businessobjects.com/communityCS/TechnicalPapers/ce8_urlcommands.pdf.asp

Although the information it still works.  In CE10, BO does some translation for you.

Here is the sample syntax:

http://mycrystalserver/businessobjects/enterprise11/viewrpt.cwr?id=55&apsuser=mike&apsauth=secWinAD&viewer=html

if you have SSO set up, it should go ahead and sign them in...  however the downside to this model is that you are creating a new session every time someone wants to access a report.  A better way would be to write a quick script such as "viewreport.aspx", which takes URL commands and displays the report for the user.  You could then use the window.close javascript to log them out when they close the windows.  OR you could simply look for the existence of a CMS token and sign them in that way.
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now