Skip to Content
0

Creating Crystal Reports multi-tier environment

Apr 29 at 11:06 AM

33

avatar image
Former Member

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Dell Stinnett-Christy Apr 30 at 01:38 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Don Williams
May 01 at 01:36 PM
0

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


lock.png (68.1 kB)
rvnti.png (60.7 kB)
Share
10 |10000 characters needed characters left characters exceeded