Skip to Content
avatar image
Former Member

Creating Crystal Reports multi-tier environment

Hello, trying to find info/diagrams on multi-tier crystal report environments.We have Crystal Reports 11; I believe designer/developer.I am looking to create an environment where users can access reports and even refresh them but not change them.We don’t have a Crystal Reports Server and I am not counting on that being available though I would like to know how it works and what are the real advantages.I have been looking for architecture diagrams, 2 tier or 3 tier, but have not found any.

Hopefully you can get me pointed in the right direction.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Apr 30 at 01:38 PM

    You have a couple of options:

    1. Crystal Reports Server, which lets you publish reports from Crystal so that your users can view them interactively or schedule them to run at specific times. When using the scheduling function, the result is saved as an "instance" that the user can view at any time after the schedule has run. Reports can also be set up on recurring schedules.

    2. Purchase a third-party too that will provide this functionality. You can find a pretty complete list of what's available at http://www.kenhamady.com/bookmarks.html.

    3. Write your own code using either the .NET or Java SDK to provide view functionality either on the desktop or through a web application. There are limitations on this in terms of how many users can be actively working with reports (5, if they're accessing it through a web app) as well as limits on the number of subreport instances can appear on a report when it's run.

    -Dell

    Add comment
    10|10000 characters needed characters exceeded

  • May 01 at 01:36 PM

    Hi Alton,

    First thing to do is upgrade to XI R2, use the same keycode you used to install XI:

    http://downloads.businessobjects.com/akdlm/crystalreports/crxir2_sp4_full_bld_0-20008684.exe
    http://downloads.businessobjects.com/akdlm/crystalreports/CRYSTALREPORTS06_0-20008684.EXE

    It's version 11.5 SP 4 with the last SP 6 patch.

    Another option is to upgrade to CR 2016, there are a few options with it.

    https://www.sap.com/products/crystal-reports.html

    On the File menu, Report Options you can now secure the report using a password:

    lock.png

    Or Using the .NET SDK you can export the report the RPTR format and that format can only be viewed using a Report Viewer using the SDK package from here:

    https://wiki.scn.sap.com/wiki/display/BOBJ/Crystal+Reports%2C+Developer+for+Visual+Studio+Downloads

    If you don't have a code Developer available it is easy to create a simple app for viewing your locked reports.

    Or by locking the report in CR Designer that will give you the same ability without developing an app yourself.

    Or use any of the 2rd party application will work as well, as long as they have that feature enabled.

    Don

    Add comment
    10|10000 characters needed characters exceeded