By using this website, you agree to our Terms of Use (click here)
In order to allow me to focus on Consulting (click here) and Courses (click here), I continue to review all posts here in the Forums, but, in general, I'm only personally responding to posts that I mark as #AcumaticaTnT (click here). For Questions (click here), others may respond, or you can post over at Community.Acumatica.com (click here).
Sincerely,
Tim Rodman
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])
I can't think of a way to do it other than using a SWITCH statement and converting the values manually.
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