Hello!
Firstly - thanks for taking the time to read this post.
The problem at hand is this. I have a large dataset returned by my SP that I want to filter to return a smaller
subset of the data (for the purpose of creating multiple data regions).
In RS BOL the method for creating a filter is:
To add a filter to a dataset
In Data view, from Dataset, select the dataset to which to apply the filter and click the edit (...) button.
1) On the Filters tab, for Filter, do the following:
* In Expression, type or select the expression that you want the filter to evaluate.
* In Operator, select the operator that you want the filter to use to compare the evaluated field and the value.
* In Value, type the expression or value against which you want the filter to evaluate the value in Expression.
... my problem is that I have no idea of what the proper syntax should be for specifying a "value" (not a VB
coder). I have a text field in the dataset returned named 'desc'. I want to filter values based on the first 4
chars then a wildcard.
eg.
Text field (DESC) returned by SP has value "SalesXXXXXXX"
I have: =Fields!description.Value LIKE "Sales*"
Questions
1) For the operator, should I be using '=' or 'LIKE' for a string comparison?
2) For the value; what is the correct syntax for specifying a string?
3) When looking at the returned data in the 'Data' window, should I expect to see the filtered data or the
whole unfiltered dataset?
4) Where can I go (www) for a decent quick and dirty VB.NET tutorial.
Thanks in advance!
Casey.
Firstly - thanks for taking the time to read this post.
The problem at hand is this. I have a large dataset returned by my SP that I want to filter to return a smaller
subset of the data (for the purpose of creating multiple data regions).
In RS BOL the method for creating a filter is:
To add a filter to a dataset
In Data view, from Dataset, select the dataset to which to apply the filter and click the edit (...) button.
1) On the Filters tab, for Filter, do the following:
* In Expression, type or select the expression that you want the filter to evaluate.
* In Operator, select the operator that you want the filter to use to compare the evaluated field and the value.
* In Value, type the expression or value against which you want the filter to evaluate the value in Expression.
... my problem is that I have no idea of what the proper syntax should be for specifying a "value" (not a VB
coder). I have a text field in the dataset returned named 'desc'. I want to filter values based on the first 4
chars then a wildcard.
eg.
Text field (DESC) returned by SP has value "SalesXXXXXXX"
I have: =Fields!description.Value LIKE "Sales*"
Questions
1) For the operator, should I be using '=' or 'LIKE' for a string comparison?
2) For the value; what is the correct syntax for specifying a string?
3) When looking at the returned data in the 'Data' window, should I expect to see the filtered data or the
whole unfiltered dataset?
4) Where can I go (www) for a decent quick and dirty VB.NET tutorial.
Thanks in advance!
Casey.