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.
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.