About ssrs

Question

hi every one....

i need to filter columns in a report,,,,

i have 12 columns in a report...for that by passing 12 parameters which is   is not good.....

is there other way plz help me

Answer 1

Hi

Not clear from you question what you want to filter.

If you want to filter the records, there are multiple ways:

1.) Filter in the query it self

2.) Filter the dataset.

• click the dataset and click properties, you will see a tab for filter.

3.) You can filter individual chart and table.

• click the chart or dataset and click properties, you will see a tab for filter.

4.) You can filter the row or column groups.

• click the chart or dataset and click properties, you will see a tab for filter.

---

Regards Harsh

Answer 2

hi every one....

i need to filter columns in a report., i mean at browser level only can filter any of the column value..i.e client requirement...

i have 12 columns in a report...for that by passing 12 parameters which is   is not good, and looks ugly.....

so user can filter in a browser only not in query....

2. can we do fixing number of records in a page with out grouping?

3.if we done with grouping then interactive sorting is not working for 1 st value to last value

Answer 3

Hi Srinu,

From you description, you don’t want to add 12 parameters to your report, right? If we want to filter data in browser level, we have to use parameter to do it in Reporting Services currently. And each row can only display two parameters. Maybe you want to add filter like below for each column, I do it like in Microsoft Excel, I am afraid this cannot be achieved currently.

Thank you for your understanding.

Regards,
Charlie Liao

---

Charlie Liao
TechNet Community Support