Crystal Reports Server 2008 guides

[Schnappa]

All

I have looked high and low for a guide to CRS 2008. I am in charge of implementing this product, using CR 2008 to write the reports and SQL 2008 as the db back end.

I have been playing with the main management page, but am a little lost as to the process required to get an existing report up and running on the system utilising all the functionality of CRS.

Does anyone have any suggestions as to where to look for manuals etc. SAP have been absolutely hopeless.

Thanks peoples

GV

 

[Turkbear]

Hi,
Do none of the docs here help?:

http://help.sap.com/content/bobj/bobj/index.htm

(Choose CR Server and Cr Server 2008 from the 2 drop down boxes...)





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[Schnappa]

Thanks Turk

Yep - seen that one before. Good to set it up, and the IT boys have done that. It's more about very simply (?) loading a pre created crystal report (2008) and getting it to run, without coming up with twenty different error. OK twenty is probably a bit of overkill - but you know what I mean.

Thanks again

GV

 

[Turkbear]

Hi,
Without some idea of the errors you encounter, it is hard to find a solution..Usually, publishing a report to CR Server using the Publishing Wizard is pretty straightforward ( Unless they have really changed things from the methds used in BOE XI )
- what has been happening when you try?






To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[Schnappa]

Ok - Updated - sorry for the delay

I have been using Crystal Reports as a report writer since version 8.5, so am an advocate for BO. I was asked for a more robust report delivery system than the old RAS I have used in the past and of course found that CRS advertised exactly what we need, so we bought it and now I am in charge of installation. Suffice to say, I am not a major techo and am now having some problems.

Our setup is thus

Crystal Reports 2008 on my machine.
Crystal Reports server on a server machine - Pyxis.
SQL Server 2008 standard on the same server machine - Pyxis.
Small SQL warehouse - ManRep on Pyxis
ODBC setup on both my machine and Pyxis set up identically - System DSN on both

I create a report on my machine - a simple list from the database and save it to Enterprise.
I open CMC and locate the crystal report - right click - view.
I then get the error 'Failed to open the connection' -< Report name>.

I have looked at the database connection within the CMC - Report - and note that the server name is actually description name from the ODBC connection setup - not Pyxis. I have tried to amend the name and update the connection to no avail - I still am getting the same error.

Is there anything resembling a setup guide or guide book for CRS 2008? I can;t find anything and SAP Australia sent me on a wild goose chase that ended up with me rereading the sales brochure, telling me how easy it is to set this thing up - go figure.

Thanks heaps

GV

 

[Turkbear]

Hi,
Check the user account that the CR Server servces are running under and be sure that it has full access rights to the Report Database and the ODBC DSNs - Usually a Domain account with the correct permissions is the preferred way to run the services - This is a different situation from when you run the report on your PC - Your user account probably has the correct rights.

In the CMC under the database tab for the report you published, is there an options to provide a connection other than the one saved with the report? If so, have you tried that method to change it ( Maybe to a Native SqlServer driver, not ODBC - if one exists for your server.)






To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[Schnappa]

Turk

Thanks again for your help.

We looked at it again with a fresh set of eyes and realised that the problem was based on the fact we installed a brand new server running 64 bit. It turns out that the ODBC 32 bit connection was bottling up the whole process.

We cleared out the 32 bit connections (and some other techo stuff that is beyond this mere report writer) and we are moving forward again.

Great work on giving us some leads Turk - it's appreciated

GV

 

[Turkbear]

Hi,
Glad you got it up and running...






To Paraphrase:"The Help you get is proportional to the Help you give.."