Hi All.
I have a Crystal report where it is taking it's data from a stored procedure of SQL Server 2000.
Problem is now that when i deploy the report, I would also have to deploy the stored procedure separately. This basically would cause version issues and possible problem if one forgets to update one and not the other.
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 2000/SQL2005.
I would also have Crystal Report 2008 if needed.
Thanks.
-- gyfu --
Crystal Ver 10
Microsoft SQL
I have a Crystal report where it is taking it's data from a stored procedure of SQL Server 2000.
Problem is now that when i deploy the report, I would also have to deploy the stored procedure separately. This basically would cause version issues and possible problem if one forgets to update one and not the other.
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 2000/SQL2005.
I would also have Crystal Report 2008 if needed.
Thanks.
-- gyfu --
Crystal Ver 10
Microsoft SQL