Hi,

Sorry but I can't find a solution to my problem, and I hope anybody can realy help on this ...

Using CR XI, I created a report based on a stored procedure (SQL Server 2008R2) asking for 3 parameters and on several other parameters input by the user.

The SP returns from 1 to n records (usually 2 or 3) from which 1 column is used by a cascading parameter.

So the parameters are:
3 params for the SP
1 param cascading from the resultset
6 params input by the user and used on the report as well

My problem now is that when running the report, CR first asks for the 3 params of the SP on a first window and then displays a second window asking for all the params including the 3 first already asked on the first window!

As CR already knows these 3 parameters, I should expect it doesn't ask it twice or at least fulfills the input boxes with the known values.

I hopes it makes sense.

So my question is how can I avoid this from happening?

Many thanks for your answers ...

rv


Edited by rvroth - 25 Sep 2014 at 2:32am

under report options do you have Verify Stored Procedures on First Refresh enabled?

Thanks for your answer Z9962

I understand CR must first run the SP to generate the dynamic list and yes, indeed, I can write a new query to generate the data required.

But I don't see how to make CR only ask once for the parameters.

And as I'm not a daily user of Crystal, I'm not a comfirmed expert

ok, but this is the problem ... the list depends on the user input and this input needs to be on the report.

is there any way to tell CR to reuse the parameters intially input? actually, in my report, they're listed only once each.