We have several reports based on Stored Procs with multi value parameters.
The stored procs don’t understand the arrays that Crystal passes and I understand the solution is to embed the report as a subreport within a main report that reformats the array to a delimited string, which is then passed to the proc.
This is fine except where a report already has sub reports inside, you can’t embed a sub report within a sub report.
Another possibility is to remove the parameters and the where statement from the proc and put them in the Select Expert in the Crystal report.
This sort of defeats the purpose of having a stored proc, and I’m guessing performance will be worse. Are there other issues with this? Does it mean all data will be passed across the network to the report before it is filtered?
The performance will depend on many things such as: speed of the server versus the local computer, how complex the Record Selection Formula gets, whether you use/ don’t use functions in the Record Selection Formula, whether you use grouping on the server, etc.
If you are really concerned, you should be able to recreate the stored procedure as an Command object in the Database Expert. Depending on your datasource, you should see Add Command before tables. You can type in the same thing as the stored procedure here. Make any modifications you need to get it to format the way you need.
We are using a Sybase Native connection, the Add Command option is not available.
The Architects here expect us to use stored procs, I’d have to have a good reason not to.
So I’m really just wanting to check if using a stored proc as a data source while having the where statement in the Select Expert is as silly as I suspect it is.
Hi,
we have an application where we can upload crystal reports developed on Views. This application does not support stored proc so we migrated all report from stored proc
to views.
Now there are some reports whose veiw cant be designed and we can not use SP.
Is there a way with which i click on run report after passing parameter which will generate
a view or table required to generate the report.
–how can we use commands to do that
–or by some trigger mechanism . is it possinle.
(BOB member since 2006-04-19)
(BOB member since 2008-07-15)