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...
Tabular Report not ...
 
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 Tabular Report not displaying correctly as a Subreport

Acumatica Report Designer
Last Post by megan.friesen 9 months ago
1 Posts
1 Users
1 Likes
170 Views
RSS
megan.friesen
Posts: 68
 megan.friesen
Topic starter
May 11, 2022 10:36 am
(@megan-friesen)
Member
Joined: 3 years ago

Hello,

I have a tabular report that I’ve generated.  It prints fine if it’s run as a standalone report.  It’s to summarize AR Invoice data to assist with invoice reconciliation to the supporting documents.  Along the left side I have the employees grouped by the field tickets/LEMs that the data came from (custom solution) and the columns are the inventory/labor items.  

The issues is when I add my tabular “LEM Summary” report to the AR Invoice, the rows are not grouping/displaying correctly.  At the beginning of the subreport I’m getting all my group header/footers, but for the detail sections, I’m just getting the records for employees with the first inventory item instead of all the employees.  All the rows do eventually print further down, but the grouping is not correct.

Here’s an extract of my “Invoice LEM Summary” when it’s embedded as a subreport in the AR Invoice template.  The only parameters for the subreport are the Invoice DocType and RefNbr.  All the data in the subreport is coming from ARTran.

 

For the highlighted LEM (timecard) in the invoice above there should be 8 employees listed.  Here’s what it looks like when I run the standalone “Invoice LEM Summary”

 

Because every invoice will potentially have different labour types, I have to have the summary section as a tabular report, as I cannot hardcode the inventory/labor item IDs as my column headers.  

Any suggestions on how to get the tabular report to display correctly when run as a subreport?  Or are we stuck running the “subreport” as a separate report. 

I've also cross-posted this in the Acumatica Community forums: https://community.acumatica.com/reports-and-generic-inquires-115/tabular-report-not-displaying-correctly-as-a-subreport-9562  

Tim Rodman reacted
Forum Jump:
  Previous Topic
Next Topic  
Forum Information
Recent Posts
Unread Posts
Tags
  • 11 Forums
  • 2,239 Topics
  • 9,872 Posts
  • 9 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.

‹›×

    ‹›×