How can we use Dynamic Cascading Prompts with Stored Procs??? 2

[paulmarr]

Hi Everybody

Using CRXI r2 and BOEXI r2 - and I am trying to create dynamic cascading parameters for use on a report that uses a stored procedure as it's data source.

Is it possible? Has anyone successfully accomplished this?

CR_XI_Dynamic_cascading_prompting.pdf mentions that it is possible - and dedicates a whole 15 lines of text to the subject - but doen't mention how! (Perhaps the author hadn't worked it out at the time of writing?)

I would appreciate your input Crystal gurus!!

Cheers
paulmarr

 

[kenhamady]

Have you created a cascading parameter in a non-SP report? I think it works the same way. You just need to have a multi column data set (table, SP or command) to use as your source data.

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guides for Formulas, Parameters, Subreports, VB, .NET, Tips and Tricks

http://www.kenhamady.com/

 

[paulmarr]

Hi Ken

Thanks for replying - good to see you are still here.

Yes - I have been successful in a non SP report - no problems. The stored proc becomes an issue when you want to cascade from let's say State to City because it is expecting a single parameter for each value that was named in the sp - for example @State - but CRXI does not give us the ability to separate the prompts into single values - it wants to create a Prompt Group which the stored proc isn't expecting - and throws an error.

Any help is appreciated Ken!
Cheers
paulmarr

 

[kenhamady]

OK, I see the problem. One workaround would be to put the SP report in as a subreport to an empty shell main report. Create the prompt group in the main report and link the subreport parameters to the main report parameters.

This means that the main report can't simply draw from the same SP. You will need another source for the parameter data but it is probably more efficient to create a simpler data source for the parameter anyway.

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guides for Formulas, Parameters, Subreports, VB, .NET, Tips and Tricks

http://www.kenhamady.com/