Telerik Reporting issue

[Dimitris]

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)

 

 

[Stef]

Hi Dimitris,

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

[Dimitris]

As i've told the problem happens when i map procedure parameters with reports parameter...if i understand that is what you tell me to do...my procedure wait three parameters that are mappef with reports parameter!and then i configure the one parameter to be masked! for example procedure waits id!id has values 1,2,3 etc!the problem i have is when i am trying to bind values e.g value id=1 display value=italy nothing happens! the result is an empty box!

[Stef]

Hi Dimitris,

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

[Dimitris]

I a attaching new some screenshot. I've attached datasource without parameters and i configured parameters in report and i have the same problem

[Stef]

Hello Dimitris,

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