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