iif expression in Visual studio SSRS report in AX

Finance and Operations/AX Developer Forum
1

Hello guys,

I am stuck to write iif expression in visual studio (SSRS Report) in AX2009

here is my example where i am stucked.

I have a paramtere called Month "where the month value is 1,2,3,4…12 and label as JAN,FEB,MAR…DEC

And in my tablix there are 12 coloumns(budgetJan,Budgetfeb,BudgetMar…BudgetDec)

So, if user selects june in the parameter, then coloumns should appear upto june.

if user selects aug in the parameter, then columns should appear upto aug.

Like this way…

If anybody knows how to write the iif condition…Please suggest.

2

Does it mean that you’re trying to write a condition for the Hidden property, which should do something like “hide if column index is higher than the parameter”?
Shouldn’t you use a matrix for this kind of thing, instead of a fixed number of columns and hiding some of them?

3

Yes, I am asking for hidden property expression…No, i haven’t use matrix

4

Yes, I understand you’re not using using a matrix - that’s exactly what looks wrong to me. It’s seems you’re trying to solve an artificial problem caused by using a wrong tool for the task.