Skip to Content
avatar image
Former Member

what steps are needed view an existing crystal report in crystal server

I'm new to Crystal Reports/Crystal Server. I have 2016 version of both installed on a Windows Server 2008 environment, and have a "TestReport" that connects to my DB and runs perfectly in Crystal Reports.

When I take that same report and put it in Crystal Server, using CMC, I add a "test" folder, add the "TestReport" to that folder, update the Database Configuration to include the DB password, and "view" the report. There's several options there for Database Configuration, and they all give me the same error:

The viewer could not process an event. Failed to open the connection.

TestReport []

---- Error code:0 [CRWEB00000119]

The database connection is an ODBC connection, and it works in Crystal Reports (installed on same server).

What is the normal sequence for moving an existing report into Crystal Server?

And if the sequence I described should work, how might I find out more about what I've done incorrectly in this setup?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Oct 21, 2016 at 01:40 PM

    Have you created a 32-bit ODBC connection on the server? The CRS software itself is 64-bit, but the part that runs Crystal is still 32-bit, so you have to have a 32-bit connection. You can find the 32-bit ODBC Administrator at C:Windows\syswow64\odbcad32.exe.

    -Dell

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thanks Dell, yes I did do this, but still having same problem.

      Any suggestions for how I might get past this? I'd like to move some reports to Crystal Server, but am stuck on the most basic step -- trying out Crystal Reports was so easy, but I've not yet got even one report to run in Crystal Server

  • avatar image
    Former Member
    Oct 24, 2016 at 03:21 PM

    once you open the crystal report go to Database-->Set datasource location --> create a OBDC conenction and update the existing connection and save to reporsitry.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Yes, this is what I've done many times with Crystal Reports -- it ALWAYS works with Crystal Reports. I don't see any options like this on Crystal Server.

      The problem I'm having is that I am unable to add this report to Crystal Server and view it.

      I add the report using "add Local Document", then I right click and "View" -- this is when I see the database connection error. There are several options under "Database Configuration" -- I've tried them all, they all result in same error.

      I do not see any option for what you are describing in Crystal Server, but I do have those options in Crystal Report (and I've used them there without any problem). Are you saying that I need to create connection in Crystal Server?

  • Oct 24, 2016 at 05:36 PM

    Try publishing the report from Crystal instead of using "add Local Document". On the File>>Save As menu you should have an option in the column on the left to connect to "Enterprise", which is your Crystal Server. You need to have Create rights on the folder that you're publishing the report to.

    -Dell

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 07, 2016 at 05:05 PM

    Hi Johannes,

    Try creating a new report with now DB connection and just a text object "Hello World" in it and see if that works.

    It could be your account does not have rights to run the report, check with the Admin for BOE for permissions on your account.

    Or log into CMS under the Admin account and try previewing/setting your log on info for the report.

    What DB client are you using in CRD and setup on BOE? Did you use a System DSN, required for System Processes to access the DSN.

    If the first report works then try adding one table and one field, no parameters...

    If your report has Parameters are you setting them also?

    Next is Run the report in CR Designer and click on File, and check on the Save Data.... and save it. Then publish that report to CRS and there is a check box to discard saved data ( or something like that ) and save it.

    You should now be able to view the report with saved data, once in the Viewer now hit the Refresh button and see what happens, it may prompt for Parameters or Log on info....

    Don

    Add comment
    10|10000 characters needed characters exceeded