AugForums.com

An Acumatica User Group

  • Free
    • Start Here
    • Rolodex
    • Podcast
    • Blog
    • Forums
  • Paid
    • AugSQL
    • GI Course
    • GI Library
    • Consulting
  • Register
Acumatica Forums

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

Forums
AUG Forums
Acumatica Report De...
Creating "Harvester...
 
Notifications
Clear all

#AcumaticaTnT Creating "Harvester" Parameters

 
Acumatica Report Designer
Last Post by Tim Rodman 4 years ago
1 Posts
1 Users
3 Reactions
2,739 Views
RSS
Tim Rodman
Posts: 3193
 Tim Rodman
Admin
Topic starter
May 26, 2021 10:20 pm
(@timrodman)
Famed Member
Joined: 10 years ago

I was working on an Acumatica Report in Acumatica Report Designer recently and I created a drop-down parameter on the Parameters tab in File -> Build schema... to make it easier to choose a date range for the report:

image

 

Of course, the Parameter doesn't do anything until you go use it in the Filters tab so I started to setup this construct where different date range filters will get applied depending on which parameter option is chosen. I tried using @MonthStart and @MonthEnd on the Filters tab like this:

image

 

I like @MonthStart and @MonthEnd because they save me from having to write a formula. I also like @MonthStart and @MonthEnd because they respect the Business Date that you chose in Acumatica, unlike the Today() and Now() functions which only look at the system date on the web server which is always today's date, regardless of which Business Date you've chosen.

But, when the report runs, the @MonthStart and @MonthEnd values get translated into empty values which then causes the report to be empty.

I know that values like @MonthStart, @MonthEnd, @QuarterStart, and @QuarterEnd are legitimate values because they are visible in the Parameters section of the Expression Editor:

image

 

But it appears that @MonthStart, @MonthEnd, @QuarterStart, @QuarterEnd, etc. can only be used on the Parameters tab and not the Filters tab.

So why not create "harvester" parameters that do nothing but get the values in @MonthStart, @MonthEnd, @QuarterStart, @QuarterEnd, etc. Then use those "harvester" parameters on the Filters tab?

I built 4 "harvester" parameters: MyMonthStart, MyMonthEnd, MyQuarterStart, and MyQuarterEnd. Each "harvester" parameter does nothing but "harvest" the values from @MonthStart, @MonthEnd, @QuarterStart, and @QuarterEnd as you can see with the MyMonthStart parameter in this screenshot:

image

Note in the screenshot above that I unchecked the Visible checkbox. I did that for each of the 4 "harvester" parameters so they aren't visible when you go to run the report.

 

On the Filters tab, I changed @MonthStart to @MyMonthStart and @MonthEnd to @MyMonthEnd as you can see here:

image

 

Now the report runs and returns the data that I expected to see.


KimM, AhmedBahar and Dianne A reacted
Forum Jump:
  Previous Topic
Next Topic  
Forum Information
Recent Posts
Unread Posts
Tags
  • 12 Forums
  • 2,526 Topics
  • 10.9 K Posts
  • 37 Online
  • 2,324 Members
Our newest member: Michael Kiley
Latest Post: Pick List report suddenly not splitting on Shipment
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

 No online members at the moment

Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

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

‹›×

    ‹›×