• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1236
  • 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.  

1 Solution
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:


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.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

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