I'm in a similar situation though in SSRS 2008.

I am interested in knowing how to write an expression that says;

iif the row_description is A then return Count(item_id)

Iif the row_description...

for example. I tried to follow the directions on msdn and they didn't jive with what I was seeing ie. I don't see a Data tab when I open Chart...

happycat, are you suggesting that instead of a single series called Years, I might have had 3 series eg. YearSeries1 (current yr), YearSeries2 (2014), YearSeries3 (2013) and that I then...

Hi pietlindin I will next time preface it with (am not going to change the query) 🙂 Ttyl!!!!

pietlinden. i get a little ticked off by these suggestions. If I have to explain,the report is used to deliver customized subscriptions to various partners. Some partners want to see...

have relevant question for this old posting. Goal in my space is to reduce the quantities of this error generated in the log files after night IIS reset:

Exception:

...

Phil and Nevyn, thanks for reply.

With your vote behind mine, that this is non-logical behavior, I set up setting up bare bones package to deal with just the ingestion of...

adjustment to expression that I made and worked:

iif(parameter = 0, true, false)

am not able to bust past cause of even the Boolean parameter + expression not working for controlling visibility of a single tablix item.

expression for default state of hidden in...

The only way I could get SSRS to interpret the parameters as T/F like I intended was to have 3 separate parameters defined as booleans. Maybe see if HappyCat59 has...

Yooohoooo, HappyCat59, come in HappyCat59 , SSRS, ahem multi valued parameters for conditional settings of tablix visibility....HappyCat59 !

I tried this for first tablix:

=iif(Parameters!MonthlySet.Value(1)=1, false, true)

this for second tablix:

=iif(Parameters!MonthlySet.Value(1)=1 & " " & Parameters!MonthlySet.Value(2)=2, false, true)

this for third:

=iif(Parameters!MonthlySet.Value(1)=1 & " " & Parameters!MonthlySet.Value(2)=2 &" "& Parameters!MonthlySet.Value(3)=3, false, true)

error...

Hi pietlinden,

pietlinden (2/18/2015)

---

Looks like the simple answer to this is to use 3 separate Boolean parameters instead of one Multi-valued integer.

Just to test my theory, I tried creating a multi-valued...

I changed visibility to Show, put expression into the fx next to 'Use This Image' and is working. 😎

Thanks gazareth!

OK, I will use External images.

I took the expression and pasted it to the General tab's Tooltip fx field. That returns an error: 'Enter a valid expression for initial...