Skip to Content
0
Former Member
Dec 08, 2011 at 03:00 PM

CR XI Cascading Prompt on Dynamic Parameter Value

23 Views

Hi friends need a help related to Cascading prompt parameter in CR XI.

I need to modify an existing report wherein Stored Procedure having a parameter is used as a datasource. Now in Report when I go in edit mode for that parameter under the value section of it a query (&select col1,col2 from tbl where userid='value coming from front end app') is written which populates the value to select the particluar value to pass as a parameter. First of all what this functionality is termed as I am not aware of it please help me with it if somebody knows it. Also in the select list its mention 2 columns but when we run the report at that time the col2 data is only being displayed in dropdown and col1 which is a id field is passed in record selection formula.

Now as per our requirement we need to introduce 1 more parameter for record filtering i.e. based on the above parameter value. This can be achieve through Dynamic Cascading Prompt. But the challenge is to use Cascading Prompt funcionality its necessary that both the parent & child field should be populate from db but here the parent value is populate using a query as I stated so in that case how to achieve this.

Sorry if I am not able to explain the scenario properly.

Please friends help as soon as possible.