This is a migrated thread and some comments may be shown as answers.

Dynamic Filtering on a report

1 Answer 169 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Derek
Top achievements
Rank 1
Derek asked on 13 Sep 2011, 06:15 PM
We have a form that includes a radgrid, and a section at the top where users can specify various filtering criteria (NOT filtering in the grid). When the user activates the filter, there is some code that looks at the various filtering items, and builds a filter string based on which ones are populated.

We also have a report designed to contain the same data as this radgrid, so that users can print the data in a formatted report.

I'd like to pass the filtering over to the report, but the filtering is a string that could contain multiplle variables and expressions, for example;

"startdate >= '01/01/2011' and startdate <= '12/31/2011' and ClientID = 3"
or
"CategoryID = 7 and Description like '%test%'"

Let's say my report parameter is called rpFilter, and rpFilter has the value

 "CategoryID = 7 and Description like '%test%'"

...then I'd like to have my filter expression be just the value of rpFilter with no operator and no comparison value. Is there a way to do that? I am trying to avoid having to generate and deal with a bunch of parameters, since this is going to be used from a number of sources.

1 Answer, 1 is accepted

Sort by
0
Peter
Telerik team
answered on 19 Sep 2011, 07:49 AM
Hello Derek,

Telerik Reporting has it's own expression engine to cover it's extended needs. More information on the topic is available in Expressions help article.

Kind regards,
Peter
the Telerik team

Explore the entire Telerik portfolio by downloading the Ultimate Collection trial package. Get it now >>

Tags
General Discussions
Asked by
Derek
Top achievements
Rank 1
Answers by
Peter
Telerik team
Share this question
or