Skip to main content
Solved

Tabular Report not displaying correctly as a Subreport


meganfriesen37
Captain II
Forum|alt.badge.img+11

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.

Best answer by meganfriesen37

We were not able to get the tabular report to run as a subreport (which would have been nice because then you just get 1 nice file to attach to the customer invoice.  Unfortunately the users have to run the Invoice report separately from the LEM report (Tabular report) and there was a specific request from the Acumatica customer to have the supporting documentation presented in the columns which necessitated a tabular report.

View original
Did this topic help you find an answer to your question?

2 replies

BenjaminCrisman
Acumatica Employee
Forum|alt.badge.img+4
  • Acumatica Support Team
  • 630 replies
  • October 14, 2022

Hi @meganfriesen37! Did you already find an answer to this issue?

As far as I know the tabular option will not work correctly due to tabular report reading left to right and main report reading top to bottom.


meganfriesen37
Captain II
Forum|alt.badge.img+11
  • Author
  • Captain II
  • 566 replies
  • Answer
  • October 14, 2022

We were not able to get the tabular report to run as a subreport (which would have been nice because then you just get 1 nice file to attach to the customer invoice.  Unfortunately the users have to run the Invoice report separately from the LEM report (Tabular report) and there was a specific request from the Acumatica customer to have the supporting documentation presented in the columns which necessitated a tabular report.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings