Dynamic Filtering on a report

2 posts, 0 answers
  1. Derek
    Derek avatar
    118 posts
    Member since:
    Oct 2008

    Posted 13 Sep 2011 Link to this post

    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"
    "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.
  2. Peter
    Peter avatar
    1631 posts

    Posted 19 Sep 2011 Link to this post

    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,
    the Telerik team

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

Back to Top