Re: parameter formula

[ecsrs]

I have a cross-tab report that has service type in the column and month in the row. The summarized field is sum of service units. I want a parameter that filters by employee, however the employees change from month to month. I am trying to add a parameter that states if month{service.date} = [1,2,3] then {emp.id} in ["100", "101", "102"] AND IF month{serv.date} = [4,5,6] then {emp.id} in ["103","105"] etc. The employee changes from quarter to quarter. I tried this formula as a parameter and my report produced no data, if I take this out it works fine. What could I be doing wrong?

 

[midearth]

May be the way the formula is written. Try:

If month({service.date}) in [1,2,3] then {emp.ID} in ["100","101","102"] else
If month({service.date}) in [4,5,6] then {emp.ID} in ...

or better yet,

If {service.date}in Calendar1stQtr then {emp.ID} in ["100","101","102"] else
If {service.date} in Calendar2ndQtr then {emp.ID} in...

 

[ecsrs]

Thanks so much the 2nd formula worked!

 

[midearth]

You're welcome. Should have had [] around the {emp.ID} number set, however, but if it's working...