how to run crystal report in business objects xi 3.1 sp3

building reports crystal reports
1

hi, i created crystal reports thru crystal reports 2008, i have the crystal reports locally on my machine. the source for the crystal report is stored procedure to get the data from database

the main thing is i need to import these reports into business objects xi 3.1 and i need to run the report in business objects. the bo server is on solaris and the reports i have r in my local machine (i.e windows).

i am using this way to import the report into bo server.

In Crystal Reports: File>Save As>My Connections (Define your BO Server) and save the reports to your BO Server.

but the main thing is i cannot run the crystal report in cmc. what am i doing wrong, do i need to set any database configuration in business objects ?

ruchi :us: (BOB member since 2010-09-16)

2

Yes, there are database settings for login / password that need to be managed for each Report Object in the CMC.

Also, if you are using ODBC / TNS for database connection you will need to ensure that those NAMED connections are configured on your BOE servers.

MJRBIM :canada: (BOB member since 2007-03-23)

3

we r using tnsnames for database connection

can u explain me how i need to configure the named connections on boe server.
i mean were i need to go and set these settings
thanks for ur reply

ruchi :us: (BOB member since 2010-09-16)

4

Highlight the RPT object in the CMC under Folders.

Actions menu -> Database Configuration

Set the User and Password for the Report Object

Define which option you want to handle database connection for View-On-Demand reports.

Click UPDATE.

**NOTE : This assumes that your Oracle Drivers and TNS files have already been installed on your BOE Servers.

MJRBIM :canada: (BOB member since 2007-03-23)

5

when i am trying to enter the details of my db , its taking everything but it is not saving the password what i gave for that userid. this is weird, if anyone know anything please let me know. thanks alot

ruchi :us: (BOB member since 2010-09-16)

6

I hope you have proper access to change the pwds.

Rajasopa (BOB member since 2007-08-22)