AUGForums.com

An Acumatica User Group

  • Forums
  • Podcast
  • Blog
  • Rolodex
  • Login
  • Start Here
  • Courses
  • 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...
Ability to add a To...
 
Notifications
Clear all

Ability to add a Total Column on a tabular report  

    Last Post
RSS

megan.friesen
Posts: 50
 megan.friesen
November 22, 2019 5:50 pm
(@megan-friesen)
21-50 Posts
Joined: 10 months ago

I am working on building a custom financial report in Report Designer to compare actual project transactions coming from PMHistory and the period specific budget amounts from PMForecastDetails.  I am not able to use ARM reports as there is no way to access the PMForecastDetails information when using a PM module ARM report.  I also considered using a pivot table, but since I needed to use a subreports to bring in the correct information from the tables as I wasn't able to join the 2 tables directly.

Currently, I have this report set up as a tabular report to allow the user to run for a range of periods (i.e. they want to run inception to date, and this would allow them to cover multiple years).  The report is working, but the customer would like a total column on the far right side.  Does anyone know of a way to get a total column or have any suggestions?  My current thought would be to use variables to keep a running total, but then I feel like I would need to include these running totals in every tabular column.

Thanks!

7 Replies
Tim Rodman
Posts: 2468
 Tim Rodman     ★★ All-Star ★★
December 14, 2019 6:31 pm
(@timrodman)
Over 200 Posts
Joined: 5 years ago

I haven't done much with Tabular in Report Designer because it's limited. You might be able to do totals, but I'm not sure.

Have you considered using Excel to connect to Acumatica over OData, then using the Power BI functionality that's now available in Excel to build the Pivot Table? It's a bit of a learning curve, but it can handle the one-many situation that caused you to need a Subreport in Report Designer.

Reply
megan.friesen
Posts: 50
 megan.friesen
December 17, 2019 10:30 am
(@megan-friesen)
21-50 Posts
Joined: 10 months ago

The client ended up purchasing a Velixo Reports subscription since that would meet their needs for the project reports (since ARM does not include any of the project forecast data).  Gabriel at Velixo was great to work with and rolled out the functionality we needed for the client.  I haven't worked much with the OData functionality, so probably something to put on my "to do" list of things to learn.

Reply
Tim Rodman
Posts: 2468
 Tim Rodman     ★★ All-Star ★★
January 4, 2020 11:18 pm
(@timrodman)
Over 200 Posts
Joined: 5 years ago

Good move. Velixo is great!

Reply
megan.friesen
Posts: 50
 megan.friesen
April 15, 2020 11:14 am
(@megan-friesen)
21-50 Posts
Joined: 10 months ago

Hi Again...different report, but same topic so I figured I would keep it all here.  We had a tabular report in 2019 R1 that we built for a customer.  We had a total that summed up the tabular column totals in the page footer.  Now that we've moved the customer to 2019 R2, the total in the footer only reports the total from the first tabular column.  Has anyone else come across this or have a solution to resolve this?

 

Edited to add: I have submitted a support case to Acumatica now on this and will update with any response I receive.

Reply
Tim Rodman
Posts: 2468
 Tim Rodman     ★★ All-Star ★★
June 15, 2020 9:23 am
(@timrodman)
Over 200 Posts
Joined: 5 years ago

I haven't done much with Tabular in Report Designer personally. I opt for Pivot Tables in that situation instead so far.

Did you get a solution from support?

Reply
megan.friesen
 megan.friesen
(@megan-friesen)
Joined: 10 months ago

21-50 Posts
Posts: 50
June 15, 2020 10:30 am
Reply toTim RodmanTim Rodman

@timrodman Thanks for the reminder to update this thread.  The response I got from Acumatica was "there is a known issue regarding totals on tabular reports which is currently in development" and the support person didn't have a time frame for a fix, though I haven't checked the latest sets of release notes.  We were able to get a temporary fix using a variable to get the totals to work. 

Reply
Tim Rodman
 Tim Rodman
    ★★ All-Star ★★
(@timrodman)
Joined: 5 years ago

Over 200 Posts
Posts: 2468
June 15, 2020 2:09 pm
Reply tomegan.friesenmegan.friesen
Tim Rodman

Ah, got it. Tabular Reports seem like one of those features that wouldn't be high on the priority list for fixing now that there are Pivot Tables.

Reply
  All forum topics
  Previous Topic
Next Topic  
  Forum Statistics
11 Forums
1,645 Topics
7,641 Posts
4 Online
1,100 Members

Latest Post: Adding bill description on check stub Our newest member: thanh thuy Recent Posts Unread Posts

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 © 2021 · AUG Forums, LLC. All rights reserved. This website is not owned, affiliated with, or endorsed by Acumatica, Inc.

‹›×

    ‹›×