Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
1821
Starting Member
18 Posts |
 Posted - 2008-07-16 : 17:54:57
|
| Hi Guys,I have a table with 2 columns and I need a different filter for each column. The reason for this is because in the table I am displaying field 'test' in column one but it is displaying information based on the filter. In column 2 I am also trying to display information based on field 'test' but with a different filter.This does not work as the 'test' field will not know which column to display the different filter information so it displays the same information on both columns.I was just wondering if there is a way round this problem?Thanks. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
1821
Starting Member
18 Posts |
Posted - 2008-07-16 : 19:30:54
|
Hi tkizer,Sorry my explaination was not clear, below is some example database data I would use. I need to create a table in reporting services that will display 'answer1' in the first column so it should appear twice based on the data being filtered. So I filter the table using the 'filter2' database column and the value of 'ON'.Also in the report table I need to have another column displaying the corresponding 'answer2' information so now I filter the table using the 'filter1' database column and the value of 'ON'.In the report designer the value put it both columns of the table will be 'test' but I need to filters to get the two different results.How would I go about doing this?If this is still unclear please let me know.Thanks.quote:
db data: test filter1 filter2--------------------------------------------- answer1 NULL ON answer2 ON NULL answer1 NULL ON answer2 ON NULL
|
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-07-17 : 13:18:06
|
| is this what you want?yourtablecol1expression=IIF(Parameters!Filter2.Value="ON",Fields!Test.Value,"")col2Expression =IIF(Parameters!Filter1.Value="ON",Fields!Test.Value,"") |
|
|
|
|
|
|
Tables Filter Question