I have a procedure pr.test which has 3 parameters @id @date_from @date_to. This procedure is set as datasource to a report.Report's parameter id is set as multivalue and in preview i saw my values perfectly ,but with now functionality because i have forgotten to connect them with procedure parameters.When finally i connected them i lost multivalues that i had before. I have the dropdown box but with no values.Please help.I've tried with no luck to setup the datasourse firstly and then to make new parameters but nothing different happened . i have the drop down box but with no values.I ve attached you a screenshots with parameters settings.
ps if i set pamameter as a single textbox and write the id works perfectly but my point is to have as a display value a name(it field in my procedure) and as a value my id(it is also field in db)
5 Answers, 1 is accepted
Please check if the DataSource component used by the report parameter has a parameterized SQL query. If the SQL query expects external values, you will have to map the SQL parameters to report parameters, and as a result to control one parameters' values through another parameter - How to: Cascading Parameters with applied filtering on data source level.
Then to use the multivalue parameter to filter data, please check How to use MultiValue Report Parameter in a SQL query.
I hope this helps.
Regards,
Stef
Telerik by Progress
Please serialize the report in XML and post the XML here. Include also the create statement of the stored procedure.
This will let us create a local test.
Regards,
Stef
Telerik by Progress
We will need the report definition in order to investigate further. We need to check if the data-retrieval methods used by report parameters expect input and if they depend on other report parameters (like in the Filters collection of hotel_id .
Please post the XML produced after serializing the report.
In addition, you can set initial value to each parameter like =First(Fields.hotel_id) or a value existing in the parameter's available values.
Regards,
Stef
Telerik by Progress