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

Posted on 2005-04-08
Last Modified: 2008-02-07
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.  

Question by:PhilChandler
    1 Comment
    LVL 1

    Accepted 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:

    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.

    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    Join & Write a Comment

    I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
    Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
    To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now