creating dynamic parameter without cascading

[americvish]

Is there any way to create dynamic parameter without cascading the fields?

Like i am creating a report based on stored procedure. so there are multiple parameter coming up while creating.

In my situation i have customer parameter and grouppath parameter . So when the user run the report when he selects customer parameter all the grouppath available to that customer must be coming up in the list of values for the grouppath parameter.

when i go with the cascading option the customer parameter appear twice, one for the customer parameter and other for cascading parameter for grouppath.

i want to have the list of values appearing for grouppath from the customer name selected from customer parameter. so that i can avoid having customer parameter appearing twice.

can somebody pls do let me know is there any way without cascading customer and grouppath.

 

[briangriffin]

I don't think you have your parameter set up correctly - you may want to delete it and start over.

When you define the hierarchy for the parameters, you can create parameters for any or all of the levels within that same dialog - on the right side you'll see "Click to create parameter". In your case, you want to create parameters for both customer and grouppath.

If done correctly, in the field exporer you'll see two entries - one for YourParameterName - Customer, and another for YourParameterName - Grouppath. If you see another parameter for customer, delete it.

Then in the select expert, you'll define two criteria - CustomerDBField = YourParameterName - Customer, and GroupPathDBField = YourParameterName - GroupPath.

Dynamic parameters are designed to do exactly what you describe, without prompting for the same information twice.

 

[americvish]

i am getting one parameter for customer and when i am doing dynamic cascading prompt to get all grouppath values for the customer, there it appear other customer prompt.

and i cannot delete the customer parameter since it is from stored procedure.

i want to remove the customer prompt appearing with grouppath parameter.

any thoughts?

 

[briangriffin]

Rather than modify the behavior of the parameter, it's probably easier to modify the behavior of the stored procedure.

Base the report on a command object instead of the sp:

exec yourspname 'YourParameter - Customer'

That way the customer value still gets passed to the sp but the extra parameter is not created automatically.

The select expert will only need to reference grouppath, since the customer filtering is done within the sp.