Deploy crystal report

building reports crystal reports
1

Hi All.
I have a Crystal report where it is taking it’s data from a stored procedure of SQL Server 2008.

I want to deploy crystal report to our BO4.
Problem is now that when i deploy the report, I would also have to deploy the stored procedure separately and the connections.

My question is there a way to embedded the stored procedure into the crystal report.

To answer some possible question, for why not use the database tables as the source, the answer will be that the report comes from 3 different tables with a many to many relationship.

I am using Crystal Report 10/11 as well as SQL 2008.

Thanks.

syamkuriseti (BOB member since 2012-06-01)

2

What do you mean by this? You need to make sure that the stored procedure is in the database that your BOE system is connecting to. With ANY Crystal Report that you publish (unless it gets its data through a universe), you need to go into the CMC and set the database login properties, regardless of whether it’s using a stored procedure, tables, or a command.

-Dell

hilfy :us: (BOB member since 2007-04-16)