MoreThanDoubled
asked on
Crystal Reports XI dynamic parameters
Hello All,
I will try to explain this the best tha I can. I am not accustomed to multiple value parameter passing to stored procedures in Crystal Reports.
1. i currently have a command that executes a stored procedure and prompts the user to enter three parameter values. This stored procedure will return one column with x-number of records.
2. i would like to take those x-number of records and pass the records to another command that will recieve the values as parameters in order to run another stored procedure, in the format of a comma delimited string for example: abc,123,def
EXEC sp_XYZ {?Param1},{?MultipleCommaS eparatedPa rameters}
How would i accomplish this taks?
Thanks!
I will try to explain this the best tha I can. I am not accustomed to multiple value parameter passing to stored procedures in Crystal Reports.
1. i currently have a command that executes a stored procedure and prompts the user to enter three parameter values. This stored procedure will return one column with x-number of records.
2. i would like to take those x-number of records and pass the records to another command that will recieve the values as parameters in order to run another stored procedure, in the format of a comma delimited string for example: abc,123,def
EXEC sp_XYZ {?Param1},{?MultipleCommaS
How would i accomplish this taks?
Thanks!
This is known as data driven reports and is not supported by Crystal. In Crystal you can create a command , which will return all the data ( combined result from the first and second command ) and use grouping to present the data. Later you can use bursting , if you want to print the results separately.
There is 3rd party software -R-Tag Manager , which can be used to do exactly what you are trying to do. Check this video for a similar scenario: http://www.r-tag.com/Pages/Preview_CreateBatchJob.aspx
It runs a stored procedure, which returns records and then runs a report using parameters from the returned records.
As far as I know there is a community edition , which is free and can be used for bursting, but I don't know if data driven reports are included with the free license. Sample bursting video is available here : http://www.r-tag.com/Pages/Preview_Bursting.aspx . My guess is that you can use it too.
There is 3rd party software -R-Tag Manager , which can be used to do exactly what you are trying to do. Check this video for a similar scenario: http://www.r-tag.com/Pages/Preview_CreateBatchJob.aspx
It runs a stored procedure, which returns records and then runs a report using parameters from the returned records.
As far as I know there is a community edition , which is free and can be used for bursting, but I don't know if data driven reports are included with the free license. Sample bursting video is available here : http://www.r-tag.com/Pages/Preview_Bursting.aspx . My guess is that you can use it too.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Since Crystal works on one record at a time, you can't pass the recordset to another stored procedure.
What are you trying to do with the second SP?
mlmcc