Tuesday, May 01, 2012 8:36 PMAdding a multi value filter removes the first record from the dataset. Everything else looks fine. Why is that? is it a Bug? I am using SQL Reporting Services 2005
Tuesday, May 01, 2012 9:28 PMModerator
can you please explain further what do you mean by multi value filter.
Are you trying to put filter on table ?
Please give more details so that I will be able to help you out
Wednesday, May 02, 2012 2:08 PM
I created a parameter call Mode - this parameter is a multi-value parameter.
This parameter is using a different Data Source and the available values are from a query (so "From a query" is selected).
Then I added a filter to the table that I want to filter. I accomplished this by accessing the table properties, selecting the filters tab.
In the filters tab I selected the value that I want to filter, I am using the "In" operator and assigning =Parameters!Mode.Value.
Everything works well, the filter does what it suppose to do except the first record is ignored. If I removed the filter from the table that record shows up - is the very first record in the table and the value for that record is in the filter list.
Wednesday, May 02, 2012 2:24 PM
You are on the right track. In your filter, instead of just using =Parameters!Mode.Value, use something like this:
Think out of the box
Wednesday, May 02, 2012 7:13 PMI tried that and still the same issue - the first record is completely ignore.
Wednesday, May 02, 2012 11:53 PMModerator
You do not need to use split or join inside tablix please use in operator and just use the parameter name as I have shown in the screenshot
by the way how many value you are selecting in which one row is missing ? please update
I am putting some screenshot for your help.
If you still have a questions please let me know.
Syed Qazafi Anjum
Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful.
- Proposed As Answer by Syed Qazafi AnjumMicrosoft Community Contributor, Moderator Wednesday, May 02, 2012 11:53 PM
- Unproposed As Answer by Diaz-Mayo Thursday, May 03, 2012 6:34 PM
Thursday, May 03, 2012 11:05 PMI know how to add a multi-value filter - it works just fine with and without the split. Those are the step I already taken. The issue is that after I take those steps the first record is not display.
Thursday, May 03, 2012 11:11 PMModerator
Can you please let e know when is the first record display ? i mean is it any value isnide your parameter which links to that first record.
I suggest you that there might be some issue with your data(or data type) please try ltrim(rtrim()) and see if it resolve this.
Please give me some more details about your first record by putting screenshot or its linkage with parameter