Filter Issue/Bug

Question

Adding 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

Answer 1

 

Hi There

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

Many thanks

Syed

Answer 2

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.

Answer 3

You are on the right track. In your filter, instead of just using =Parameters!Mode.Value, use something like this:

=Split(Join(Parameters!Mode.Value,","),",")

---

Think out of the box

Answer 4

I tried that and still the same issue - the first record is completely ignore.

Answer 5

Hi There

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.

Many thanks

Syed Qazafi Anjum

Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful.

Answer 6

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

Answer 7

 

Hi There

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

Many thanks

Syed