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 |
|
Villanuev
Constraint Violating Yak Guru
478 Posts |
 Posted - 2012-06-18 : 03:56:57
|
Hi Forumer'sI have a report in SSRS with from and to date parameter. the records pullout based on the Date. So, i have where Condition that determine the date range. i have also a column header in SSRS that contains the Month.I would like to hide the month based on the where date condition. EX. Where between Trandate From "2012/04/01" and "2012/06/18"--meaning i will pullout records based on this date range. Based on the date only Apr up to May that have a records and the rest i would like to hide. Can you plase help me on how to do this. Thanks..Jan--Feb--March--Apr--May up to Dec------------------------------------ 0 -- 0 --98 --55 --60---------0 0 -- 0 --10 --0 --75---------0 I tried this condition in Column Visibility but not working..=IIF(Sum(Fields!Jan.Value) > 0, "True","False")Thank you in advance..jov |
|
|
Villanuev
Constraint Violating Yak Guru
478 Posts |
Posted - 2012-06-20 : 03:27:05
|
| Hi Forumer'sI tried these two iifs in Expression to hide the column with zero values but im not successful and it's not working. any idea guys. thanks.=iif(isNothing(Sum(Fields!Jan.Value))=True, True, False)=iif(isNothing(Fields!Jan.Value)=True, True, False) Tablix-----Column Visibility----Show or Hide to an expression and Tablix-----Tablix Properties----Visibility----Show or Hide to an expression |
 |
|
|
Villanuev
Constraint Violating Yak Guru
478 Posts |
Posted - 2012-06-20 : 03:52:59
|
| Hi Guys,I try this:Hidden properities ------- =Count(Fields!Jan.Value)<=0and it's working, the problem, theres a white spaces in the column were it hide by the condition.any inouts guys.Thanks.. |
|
|
|
|
|
|
Hide Column Dynamically..