AUGForums.com

An Acumatica User Group

  • Free
    • Start Here
    • Rolodex
    • Podcast
    • Blog
    • Forums
  • Course
  • Consulting
  • Login
  • Register
Acumatica Forums

By using this website, you agree to our Terms of Use (click here)

  • Overview
  • Member List
  • All-Stars
  • Stats
  • Recent Posts
  • Help
Forums
AUG Forums
Acumatica Report De...
How to format the P...
 
Notifications
Clear all

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

Questions How to format the Parameter List in Text Box?

Acumatica Report Designer
Last Post by pmarotta 5 months ago
3 Posts
2 Users
1 Likes
217 Views
RSS
pmarotta
Posts: 3
 pmarotta
Topic starter
August 31, 2022 6:29 am
(@pmarotta)
Member
Joined: 2 years ago

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
Tim Rodman
Posts: 2957
 Tim Rodman
Admin
September 2, 2022 11:55 pm
(@timrodman)
Member
Joined: 7 years ago

I can't think of a way to do it other than using a SWITCH statement and converting the values manually.

Reply
pmarotta
Posts: 3
 pmarotta
Topic starter
September 4, 2022 5:40 pm
(@pmarotta)
Member
Joined: 2 years ago

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 

Reply
Tim Rodman reacted
Forum Jump:
  Previous Topic
Next Topic  
Forum Information
Recent Posts
Unread Posts
Tags
  • 11 Forums
  • 2,239 Topics
  • 9,872 Posts
  • 8 Online
  • 1,813 Members
Our newest member: Marion Hooley
Latest Post: Export Scenario - Export same row twice (Conditionnal)
Forum Icons: Forum contains no unread posts Forum contains unread posts
Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Online Members

Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

Copyright © 2023 · AUG Forums, LLC. All rights reserved. This website is not owned, affiliated with, or endorsed by Acumatica, Inc.

‹›×

    ‹›×