Hi Telerik team,
I would like put filter with 2 parameters "quantity" and "operator" (like combo box). For example 100 and >, or 200 and <=.
I've tried to add parameter in report constructor:
and handle PropertyChanged Event
But when I change Par1 nothing happens.
Ok. I've handled ProductList_ItemDataBinding event, and tried to change operator:
but when I try read parameter
I always get what was set in constructor ">", quantity also is constant.
Probably something I don't understand but how can I read parameters, set in the report viewer? Is it even possible?
Any help is apprecitated.
Greetings,
Paweł
I would like put filter with 2 parameters "quantity" and "operator" (like combo box). For example 100 and >, or 200 and <=.
I've tried to add parameter in report constructor:
1.
ReportParameter item =
new
ReportParameter(
"Par1"
, ReportParameterType.String,
">"
);
2.
ReportParameters.Add(item);
3.
string
[] myarray =
new
string
[3] {
">"
,
"<"
,
"="
};
4.
ReportParameters[
"Par1"
].AvailableValues.DataSource = myarray;
5.
ReportParameters[
"Par1"
].AvailableValues.ValueMember =
"=Fields.Item"
;
6.
ReportParameters[
"Par1"
].Visible =
true
;
and handle PropertyChanged Event
1.
ReportParameters[
"Par1"
].PropertyChanged += ProductList_PropertyChanged;
But when I change Par1 nothing happens.
Ok. I've handled ProductList_ItemDataBinding event, and tried to change operator:
01.
void
ProductList_ItemDataBinding(
object
sender, EventArgs e)
02.
{
03.
Console.WriteLine(
"Event: ItemDataBinding"
);
04.
Console.WriteLine(
"Par1: "
+ (
string
)ReportParameters[
"Par1"
].Value);
05.
Console.WriteLine(
"Quantity:"
+ (
string
)ReportParameters[
"Liczba"
].Value);
06.
switch
((
string
)ReportParameters[
"Par1"
].Value)
07.
08.
{
09.
case
"<"
:
10.
Filters[0].Operator = FilterOperator.LessThan;
11.
break
;
12.
case
">"
:
13.
Filters[0].Operator = FilterOperator.GreaterThan;
14.
break
;
15.
case
"="
:
16.
Filters[0].Operator = FilterOperator.Equal;
17.
break
;
18.
default
:
19.
break
;
20.
}
21.
}
but when I try read parameter
1.
Console.WriteLine(
"Par1: "
+ (
string
)ReportParameters[
"Par1"
].Value);
I always get what was set in constructor ">", quantity also is constant.
Probably something I don't understand but how can I read parameters, set in the report viewer? Is it even possible?
Any help is apprecitated.
Greetings,
Paweł