Solved

Crystal Reports XI dynamic parameters

Posted on 2014-07-23
4
802 Views
Last Modified: 2014-07-24
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},{?MultipleCommaSeparatedParameters}

How would i accomplish this taks?


Thanks!
0
Comment
Question by:MoreThanDoubled
4 Comments
 
LVL 100

Expert Comment

by:mlmcc
Comment Utility
I don't believe you can pass multiple value parameters to a stored procedure.

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
0
 
LVL 18

Expert Comment

by:vasto
Comment Utility
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.
0
 
LVL 4

Assisted Solution

by:Nazermohideeen
Nazermohideeen earned 150 total points
Comment Utility
Why would you want Crystal to make the second procedure call. Did you try to call on sql itself. You can create a new procedure that will call both the procedures and return  the final output back to Crystal.
0
 
LVL 34

Accepted Solution

by:
James0628 earned 350 total points
Comment Utility
As I understand it, you want to run one Stored Procedure that produces a single column, take the values from those records and combine them in a comma-separated list, and then pass that list to a second SP.

 I think you could do that using a subreport.  The main report would run the first SP and save the values in a variable.  A subreport in the report footer would run the second SP.  You'd pass the list in the variable from the main report, to the SP parameter in the subreport.  I think that would work.

 But it does seem like you'd be better off doing this on the server, as Nazermohideeen suggested.

 James
0

Featured Post

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now