By using this website, you agree to our Terms of Use (click here)
Notifications
Clear all
August 31, 2022 6:29 am
I have a Parameter (@Summary) that has Values ( S, P, D) with the Label ( Summary, Project , Detail).
I would like to report Title to list the Label Values. Please advise on how to do.
@Summary - displays the values
=concat(format('{0:MM/dd/yyyy}', [@StartDate])
, ' thru ' ,
format('{0:MM/dd/yyyy}', [@EndDate])
, ' Summarized by : ' , [@Summary])
2 Replies
September 2, 2022 11:55 pm
I can't think of a way to do it other than using a SWITCH statement and converting the values manually.
September 4, 2022 5:40 pm
thanks, the switch command works and that is what I was using, but I was hoping that there was a function like in MS Report Builder.
Enjoy