I am trying to filter data at the dataset level after it is returned.
However, the filters tab on in the Dataset window does not appear to work correctly.
I have tried the following expressions:
Expression Operator Value
=(Fields!IdLog.Value = Parameters!Id_Log.Value) = =True
=Fields!IdLog.Value = =Parameters!Id_Log.Value
When I rerun my dataset query, the entire dataset is returned, instead of the filtered dataset. This same behavior occurs if I try to run the report itself.
I do not understand why the filtering does not occur.
Any help would be greatly appreciated.
Dataset Filtering Not Working
sohamraj
BenniG,
Thank you for your comment. However, I am try to filter the results that are returned from a Web Service, and therefore, I cannot specify the SQL Statement used to query the database.
Calvin Willman
I tried the filter-tab:
=Fields!ID.Value = =Parameters!ID.Value
works if both fields have the same datatype, if one is a string and one an integer I get an error.. Maybe you have to change the datatype for the Parameter
I think the filter has no effect on the !-Icon in datasets, but in my case it worked in preview mode..
Fasjam
To get maximum performance with filtering its the best to build the parameter into the SQL-Query:
="select your_colums from your_table where ID='" & Parameters!Id_Log.Value & "'"
I never tried something different, because its waste of resources to retrieve 1000records from a database and filter out 999 of them..