using ReportParameters

[c]

Hi There,

There are 2 problems about the Report Parameters.

1,I have a textbox in the pageHeaderSection and i want to set its value at runtime.Now i have add a parameter named 'Title',but i can't find any event of the report like 'loaded',there is only disposed event .So how i pass the parameter value to the textbox at runtime?

2.As we know,the SqlDataSource component supports parameterized SQL query and i'm using Oracle provider.Now i write a sql as

'SELECT * FROM Person WHERE Name in :Name' .The parameter 'Name' is a array,and my code is like ' new Parameter() {Key = "Name",Value = "('A','B','C')"}',But it doesnt work.How should I edit the 'Value' set to the parameter 'Name'?

Thanks

[Steve]

Hi,

Thanks for your interest in Telerik Reporting and up to your questions:

1. You can have the report parameter value directly as expression in the TextBox in page header, see Using Report Parameters in Expressions help article for more info.
2. As explained in Using Multivalue Parameters article, the report engine rewrites queries for data sources that cannot process parameters as an array. The rewrite logic is triggered when a parameter is defined as multivalue and the database query uses an IN statement to specify the parameter.

All the best,
Steve
the Telerik team