Skip to Content
avatar image
Former Member

How to share SAP crystal reports with users?

Hi,

I have created various crystal reports for different business users, some are drill down, some are parameter based using SAP Crystal Reports for Enterprise version 14.0.7. I am facing issue with deployment of these reports.

We need to provide some interface to users to view these reports, users are located at different locations, just wanted to know from SAP BI experts here, what is the best way to distribute various crystal reports for viewing  to different users at Head Office, Stores and different levels such as managers and staff.


I've created a publication at Crystal Reports Server to schedule reports and send as an attachment (PDF/excel) to users by mails, this solution was not approved as they don't want to receive reports in their mails, they want to generate reports as and when they want or require, also the data is these reports are static  and drill-down reports are not working in PDF .

Then I suggested to view reports directly from server using BI Launchpad or CMC, but they think that this is way too complicated to  going through CMC & BI Lauch pad folders to view their reports. Also there is some license issue so they have only 5 BI users (I want to know from experts here is there any such restriction with any license, otherwise what's the use?).

I have tried following tools so far

  1. Crystal Report viewer  - (Need to install at each & every location, drill-down working here, but again need to select from various reports)
  2. BI Launch pad (already explained above)
  3. PDF / Excel (already explained above)
  4. Dashboards (They just want to see their data i.e. crystal reports(daily, monthly, weekly etc), not graphics, thus not interested in dashboards)
  5. Central Management Console (already explained above)

But the senior management is not satisfied with the ways, they want real time data (not static like crystal reports exported to pdf, excel or any other format) with the options to select

a) which report they want to view (I think they are looking for some menu based system where they can select  say 'Daily Reports' and under that can see all types of daily reports and select which one they want  to view from the list by clicking on it as hyperlink or some other way like dropdowns)

b) where they can select different parameters such as location, period etc.

c) It should be user friendly and easy to operate,they don't  like going through CMC & BI Lauch pad folders to view their reports.

d)Also they want to view all reports on their mobiles, ipads at any time, any place whenever they travel overseas.

Please suggest/advice.

Thnaks,

Poonam

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Oct 20, 2015 at 08:37 AM

    Hi Poonam,

    If they don't like logging on to LaunchPad to view their reports, why would they like logging onto any other thrid party solution?

    If they don't want reports to be scheduled to their email, or view reports on demand or export to PDF, why would they invest in a CR Server in the first place?

    If you're looking for third-party alternatives, a good place to start looking for them is here:

    The Crystal Reports® Underground

    http://www.kenhamady.com/productlinks/default.html#serversched

    -Abhilash

    Add comment
    10|10000 characters needed characters exceeded

    • You could write an application using either the .NET or Java SDK to give users a list of reports they have access to and then use OpenDocument calls to view the reports.  But my point was that there is no SDK to run Crystal for Enterprise reports outside of the BI Platform, so BI Launchpad or a custom app using the SDK is the only way to view these reports.

      Something you might want to look at is building a "Workspace" that contains links to the reports that users don't want to navigate the folder structure to get to.

      Last week at TechEd I saw some things that they're trying to do for the 4.2 release that is due out either 1st or 2nd quarter of next year - they're looking at a "tiled" approach to presenting reports to users that will be easier for your users to navigate.  However, it's not available yet.

      -Dell