Skip to main content
Question

sub reports

  • Nov 16, 2026 5:37 PM UTC
  • 6 replies
  • 22 views
  • Translate All

dalesimmerly58
Pro I
Forum|alt.badge.img+1

do you know of a way to create a list of all reports that contain a subreport ?

6 replies

dalesimmerly58
Pro I
Forum|alt.badge.img+1

​@BenjaminCrisman any thoughts on this ?

Translate

mohammadnawaz51
Varsity I
Forum|alt.badge.img+8

​@dalesimmerly58 Do you have any example of sub report added to main report, I don't think we don't have a seperate list but everything you can find here only,https://www.acumatica.com/media/2018/02/Acumatica-ERP-Reports-Quick-Reference.pdf

Translate

BenjaminCrisman
Acumatica Employee
Forum|alt.badge.img+4

​@dalesimmerly58 There’s no real way to identify from the report if it contains a subreport, at least that I’m aware of. What’s the request that you’re looking for subreports in every report?

Translate

dgodsill97
Varsity II
Forum|alt.badge.img+6
  • Varsity II
  • Nov 16, 2026 7:47 PM UTC

.RPX files are XML files and I would suppose subreports are identified in the .rpx file.  But, you would have to go thru each file in the server.

Translate

KrunalDoshi
Pro I
Forum|alt.badge.img+9

Hi ​@dalesimmerly58,

You can query the UserReport DAC and filter the XML column for the subreport tag. The UserReport table contains all custom reports, as well as any out-of-the-box reports that have been modified.

You can use the following SQL query:

SELECT *
FROM UserReport
WHERE Xml LIKE '%subreport%'

If you also want to identify subreports used in standard, out-of-the-box reports that haven't been modified, the easiest approach would be to extract all report XML files, store them in a custom database table, create a DAC for that table, and then query the XML column.

Hope this helps!

Translate

willhowardnz
Freshman I
Forum|alt.badge.img
  • Freshman I
  • Nov 16, 2026 10:03 PM UTC

If you have access to a local instance, you can use PowerShell to query out this kind of information.
 

Powershell code behind the hide below:

#Replace Folderpath with desired folderpath.  I've run this for ReportsDefault
$folderPath = "C:\Acumatica\AcumaticaDB2\ReportsDefault"

$results = Get-ChildItem -Path $folderPath -Filter "*.rpx" -File -Recurse | ForEach-Object {
$file = $_
try {
[xml]$xml = Get-Content -Path $file.FullName -Raw
}
catch {
Write-Warning "Skipping invalid XML file: $($file.FullName)"
return
}

# Check for StylesTemplate (handles both element <StylesTemplate> and attribute StylesTemplate="")
$stylesNode = $xml.SelectSingleNode("//*[local-name()='StylesTemplate']")
$stylesAttr = $xml.DocumentElement.GetAttribute("StylesTemplate")

$hasStylesTemplate = $false
$stylesContents = $null

if ($null -ne $stylesNode) {
$hasStylesTemplate = $true
$stylesContents = $stylesNode.InnerText
}
elseif (-not [string]::IsNullOrEmpty($stylesAttr)) {
$hasStylesTemplate = $true
$stylesContents = $stylesAttr
}

# Collect all SubReport elements in the file
$subReports = $xml.SelectNodes("//*[local-name()='SubReport']")
$hasSubReport = $subReports.Count -gt 0

$subNames = @()
$subReportNames = @()

if ($hasSubReport) {
foreach ($sub in $subReports) {
$subNames += $sub.GetAttribute("Name")

# Look for ReportName as a child element, attribute, or immediately following sibling
$reportNameNode = $sub.SelectSingleNode("./*[local-name()='ReportName']")
$followingNode = $sub.SelectSingleNode("./following-sibling::*[local-name()='ReportName']")

$reportNameVal = if ($null -ne $reportNameNode) {
$reportNameNode.InnerText
}
elseif ($sub.HasAttribute("ReportName")) {
$sub.GetAttribute("ReportName")
}
elseif ($null -ne $followingNode) {
$followingNode.InnerText
}
else {
""
}

$subReportNames += $reportNameVal
}
}

# Output a single row per file if either StylesTemplate or SubReport is present
if ($hasStylesTemplate -or $hasSubReport) {
[PSCustomObject]@{
FileName = $file.Name
HasStylesTemplate = $hasStylesTemplate
StylesTemplateContents = $stylesContents
HasSubReport = $hasSubReport
SubReportCount = $subReports.Count
SubReportNameAttributes = ($subNames -join "; ")
SubReportReportNameValues = ($subReportNames -join "; ")
}
}
}

# Display in console table
$results | Format-Table -AutoSize

# Optional: Export to CSV
$results | Export-Csv -Path "C:\Acumatica\AcumaticaDefaultReportAudit26R1_Consolidated.csv" -NoTypeInformation

 


My local development Sales demo has 86 reports that include subreports:

FileName    HasStylesTemplate    StylesTemplateContents    SubReportCount    SubReportNameAttributes    SubReportReportNameValues
AM600000.rpx TRUE TemplateReport.rpx 1 subReport1 AM600010.rpx
AM611000.rpx TRUE TemplateReport.rpx 3 Materials; Tools; Overheads AM611001.rpx; AM611002.rpx; AM611003.rpx
AM612000.rpx TRUE TemplateReport.rpx 5 Steps; Materials; Tools; Overheads; Reference AM612003.rpx; AM612001.rpx; AM612004.rpx; AM612002.rpx; AM612005.rpx
AM625000.rpx TRUE TemplateReport.rpx 2 Material; Steps AM625001.rpx; AM625002.rpx
AM625010.rpx TRUE TemplateReport.rpx 2 Material; Step AM625011.rpx; AM625002.rpx
AM641000.rpx TRUE TemplateForm.rpx 2 PriceBreak; Materials AM641002.rpx; AM641001.rpx
AM642000.rpx TRUE TemplateForm.rpx 1 LotSerial AM642001.rpx
AM652000.rpx TRUE templatereport.rpx 5 Subcontract Summary - AM652005; Materials - AM652002; Sub Details - AM652004; Material Transactions - AM652003; Oper Details - AM652001 AM652005.rpx; AM652002.rpx; AM652004.rpx; AM652003.rpx; AM652001.rpx
AR641000.CA.rpx TRUE TemplateFormExternal.rpx 1 srTaxDetails AR641001.CA.rpx
CA627000.rpx TRUE TemplateReport.rpx 1 subReport1 CA627001.rpx
CA656500.rpx FALSE   1 depositDetailsByPaymentMethod CA656550.rpx
CA657003.rpx FALSE   1 Cash Accounts Subreport CA657010.rpx
CR604500.rpx TRUE TemplateFormExternal.rpx 1 AMEstimate cr6045am.rpx
FS631000.rpx TRUE TemplateFormExternal.rpx 2 subReport1; subReport2 FS631500.rpx; FS632500.rpx
FS641000.CA.rpx TRUE TemplateFormExternal.rpx 4 subReport1; subReport2; subReport3; subReport4 FS641001.CA.rpx; FS641002.CA.rpx; FS641003.CA.rpx; FS641004.CA.rpx
FS641000.rpx TRUE TemplateFormExternal.rpx 4 subReport1; subReport2; subReport3; subReport4 FS641001.rpx; FS641002.rpx; FS641003.rpx; FS641004.rpx
FS642000.CA.rpx TRUE TemplateFormExternal.rpx 4 subReport1; subReport2; subReport3; subReport4 FS642001.CA.rpx; FS642002.CA.rpx; FS642003.CA.rpx; FS642004.CA.rpx
FS642000.rpx TRUE TemplateFormExternal.rpx 4 subReport1; subReport2; subReport3; subReport4 FS642001.rpx; FS642002.rpx; FS642003.rpx; FS642004.rpx
FS642500.CA.rpx TRUE TemplateFormExternal.rpx 5 subReport1; subReport2; subReport3; subReport4; subReport5 FS642501.CA.rpx; FS642502.CA.rpx; FS642503.CA.rpx; FS642504.CA.rpx; FS642505.CA.rpx
FS642500.rpx TRUE TemplateFormExternal.rpx 5 subReport1; subReport2; subReport3; subReport4; subReport5 FS642501.rpx; FS642502.rpx; FS642503.rpx; FS642504.rpx; FS642505.rpx
fs660000.rpx TRUE TemplateFormExternal.rpx 2 schedulesReport; periodReport fs660001.rpx; fs660002.rpx
PJ644000.rpx TRUE TemplateFormExternal.rpx 14 AttachmentsReport; ImageAttachmentsReport; WeatherReport; EmployeeActivitiesReport; ProgressWorksheetsReport; ChangeRequestsReport; ChangeOrdersReport; SubcontractorsReport; ProjectIssuesReport; PhotoLogsReport; NotesReport; EquipmentReport; VisitorsReport; EmployeeExpensesReport PJ644002.rpx; PJ644001.rpx; PJ644006.rpx; PJ644003.rpx; PJ644015.rpx; PJ644004.rpx; PJ644009.rpx; PJ644005.rpx; PJ644007.rpx; PJ644013.rpx; PJ644010.rpx; PJ644011.rpx; PJ644008.rpx; PJ644012.rpx
PJ644003.rpx TRUE TemplateFormExternal.rpx 2 AttachmentsReport; ImageAttachmentsReport PJ644002.rpx; PJ644001.rpx
PJ644004.rpx TRUE TemplateFormExternal.rpx 2 AttachmentsReport; ImageAttachmentsReport PJ644002.rpx; PJ644001.rpx
PJ644005.rpx TRUE TemplateFormExternal.rpx 2 AttachmentsReport; ImageAttachmentsReport PJ644002.rpx; PJ644001.rpx
PJ644006.rpx TRUE TemplateFormExternal.rpx 2 AttachmentsReport; ImageAttachmentsReport PJ644002.rpx; PJ644001.rpx
PJ644007.rpx TRUE TemplateFormExternal.rpx 2 AttachmentsReport; ImageAttachmentsReport PJ644002.rpx; PJ644001.rpx
PJ644008.rpx TRUE TemplateFormExternal.rpx 2 AttachmentsReport; ImageAttachmentsReport PJ644002.rpx; PJ644001.rpx
PJ644009.rpx TRUE TemplateFormExternal.rpx 2 AttachmentsReport; ImageAttachmentsReport PJ644002.rpx; PJ644001.rpx
PJ644010.rpx TRUE TemplateFormExternal.rpx 2 AttachmentsReport; ImageAttachmentsReport PJ644002.rpx; PJ644001.rpx
PJ644011.rpx TRUE TemplateFormExternal.rpx 2 AttachmentsReport; ImageAttachmentsReport PJ644002.rpx; PJ644001.rpx
PJ644012.rpx TRUE TemplateFormExternal.rpx 2 AttachmentsReport; ImageAttachmentsReport PJ644002.rpx; PJ644001.rpx
PJ644013.rpx TRUE TemplateFormExternal.rpx 2 AttachmentsReport; ImageAttachmentsReport PJ644002.rpx; PJ644014.rpx
PJ644015.rpx TRUE TemplateFormExternal.rpx 2 AttachmentsReport; ImageAttachmentsReport PJ644002.rpx; PJ644001.rpx
PJ644050.rpx TRUE TemplateFormExternal.rpx 13 AttachmentsReport; ImageAttachmentsReport; WeatherReport; EmployeeActivitiesReport; ChangeRequestsReport; ChangeOrdersReport; SubcontractorsReport; ProjectIssuesReport; PhotoLogsReport; NotesReport; EquipmentReport; VisitorsReport; EmployeeEspensesReport PJ644052.rpx; PJ644051.rpx; PJ644006.rpx; PJ644003.rpx; PJ644004.rpx; PJ644009.rpx; PJ644005.rpx; PJ644007.rpx; PJ644013.rpx; PJ644010.rpx; PJ644011.rpx; PJ644008.rpx; PJ644012.rpx
PJ661000.rpx TRUE TemplateFormExternal.rpx 6 MailCC; subReport2; subReport3; subReport4; subReport1; Drawings_500 PJ661001.rpx; PJ661002.rpx; PJ661004.rpx; PJ661005.rpx; PJ661006.rpx; PJ661003.rpx
PJ663000.rpx TRUE TemplateFormExternal.rpx 2 fromEmail; fromSubmittal PJ663002.rpx; PJ663003.rpx
PJ664000.rpx TRUE TemplateFormExternal.rpx 3 MailCC; RFI Outstanding List; RFI Owner Info PJ664001.rpx; PJ664003.rpx; PJ664002.rpx
PJ664003.rpx TRUE TemplateFormExternal.rpx 1 subReport1 PJ664004.rpx
PM621000.rpx TRUE TemplateFormExternal.rpx 1 ProjectTotalSubreport PM621001.rpx
PM622000.rpx TRUE TemplateFormExternal.rpx 2 byEmpl; ByProject PM622002.rpx; PM622001.rpx
PM641000.CA.rpx TRUE TemplateFormExternal.rpx 1 srTaxDetails PM641001.CA.rpx
PM643000.CA.rpx TRUE TemplateFormExternal.rpx 1 changeRequests ChangeRequests.rpx
PM643000.rpx TRUE TemplateFormExternal.rpx 1 changeRequests ChangeRequests.rpx
PM643500.rpx TRUE TemplateFormExternal.rpx 1 subReport1 ChangeRequestMarkups.rpx
PM644000.rpx TRUE templateformexternal.rpx 2 subReportRetainage; subReportChangeOrders PM644050.rpx; PM644060.rpx
PM644500.rpx TRUE templateformexternal.rpx 2 subReport1; subReportChangeOrders PM644050.rpx; PM644060.rpx
PM650500.rpx TRUE TemplateFormExternal.rpx 2 cbrCODate; cbrsubdaterange PM650550.rpx; PM650560.rpx
PM651500.rpx TRUE TemplateFormExternal.rpx 3 CommitmentSub; pmwipCODate; pmwipsubdaterange PM651750.rpx; PM651550.rpx; PM651070.rpx
PM652500.rpx TRUE TemplateFormExternal.rpx 4 COLineSub; CommitmentSub; pmwipdetailCODate; pmwipdetailsubdaterange PM652950.rpx; PM652750.rpx; PM652550.rpx; PM652050.rpx
PM706300.rpx TRUE TemplateReport.rpx 1 subReport1 PM706301.rpx
PO641010.CA.rpx TRUE TemplateForm.rpx 1 subReport2 PO641020.rpx
PO641010.rpx TRUE TemplateForm.rpx 1 subReport2 PO641020.rpx
PR641000.rpx TRUE TemplateForm.rpx 6 subReport1; subReport2; subReport3; subReport4; subReport5; subReport6 PR641001.rpx; PR641002.rpx; PR641004.rpx; PR641003.rpx; PR641005.rpx; PR641006.rpx
PR641010.rpx TRUE TemplateForm.rpx 5 subReport1; subReport2; subReport3; subReport4; subReport5 PR641001.rpx; PR641002.rpx; PR641004.rpx; PR641003.rpx; PR641005.rpx
PR641012.rpx TRUE TemplateForm.rpx 4 subReport4; subReport3; subReport2; subReport1 PR641021.rpx; PR641033.rpx; PR641032.rpx; PR641074.rpx
PR641015.rpx TRUE TemplateForm.rpx 6 subReport1; subReport2; subReport3; subReport4; subReport5; subReport6 PR641001.rpx; PR641002.rpx; PR641004.rpx; PR641003.rpx; PR641005.rpx; PR641006.rpx
PR641030.rpx TRUE TemplateForm.rpx 1 subReport1 PR641031.rpx
PR641040.rpx TRUE TemplateForm.rpx 2 subReport2; subReport1 PR641042.rpx; PR641041.rpx
PR641060.rpx TRUE TemplateForm.rpx 4 subReport1; subReport2; subReport3; subReport4 PR641061.rpx; PR641062.rpx; PR641063.rpx; PR641064.rpx
PR641070.rpx TRUE TemplateForm.rpx 3 subReport2; subReport1; subReport3 PR641071.rpx; PR641072.rpx; PR641073.rpx
PR641080.rpx TRUE TemplateForm.rpx 1 subReport1 PR641081.rpx
PR641085.rpx TRUE TemplateForm.rpx 1 subReport1 PR641086.rpx
PR641090.rpx TRUE TemplateForm.rpx 2 subReport1; subReport2 PR641091.rpx; PR641092.rpx
pr642000.rpx TRUE TemplateForm.rpx 5 subReport1; subReport2; subReport3; subReport4; subReport5 PR642001.rpx; PR641002.rpx; PR641004.rpx; PR641003.rpx; PR641005.rpx
pr642010.rpx TRUE TemplateForm.rpx 6 subReport1; subReport2; subReport3; subReport4; subReport5; subReport6 PR642001.rpx; PR641002.rpx; PR641004.rpx; PR641003.rpx; PR641005.rpx; PR641006.rpx
pr642015.rpx TRUE TemplateForm.rpx 6 subReport1; subReport2; subReport3; subReport4; subReport5; subReport6 PR642001.rpx; PR641002.rpx; PR641004.rpx; PR641003.rpx; PR641005.rpx; PR641006.rpx
PR645012.rpx TRUE TemplateForm.rpx 4 subReport4; subReport3; subReport2; subReport1 PR641021.rpx; PR641033.rpx; PR641032.rpx; PR641074.rpx
PR645070.rpx TRUE TemplateForm.rpx 3 subReport2; subReport1; subReport3 PR641071.rpx; PR641072.rpx; PR641073.rpx
SC644000.rpx TRUE TemplateFormExternal.rpx 5 subChangeOrders; subBills; subPayments; subPrepayments; subCompliance SC646001.rpx; SC646002.rpx; SC644004.rpx; SC644008.rpx; SC646003.rpx
SC645000.rpx TRUE TemplateFormExternal.rpx 2 subReport2; subReport1 SC645002.rpx; SC645001.rpx
SC647000.rpx TRUE TemplateFormExternal.rpx 3 subcontractpaymentchangeorders; subReport2; subReport1 SC647001.rpx; SC647002.rpx; SC647003.rpx
SC647002.rpx TRUE TemplateFormExternal.rpx 1 subReport1 SC647003.rpx
SO641000.CA.rpx TRUE TemplateFormExternal.rpx 1 srTaxDetails SO641001.CA.rpx
SO641000.rpx TRUE TemplateFormExternal.rpx 1 AMEstimate SO6411AM.rpx
SO641010.CA.rpx TRUE TemplateFormExternal.rpx 1 srTaxDetails SO641001.CA.rpx
SO641020.CA.rpx TRUE TemplateForm.rpx 2 srTaxDetails; subReport1 SO641021.CA.rpx; SO641030.rpx
SO641020.rpx TRUE TemplateForm.rpx 1 subReport1 SO641030.rpx
SO641040.rpx TRUE TemplateFormExternal.rpx 1 subReport1 SO641050.rpx
SO6410AM.rpx TRUE TemplateFormExternal.rpx 1 EstimateSubReport SO6411AM.rpx
SO643000.CA.rpx TRUE TemplateFormExternal.rpx 1 srTaxDetails SO643001.CA.rpx
SO643010.CA.rpx TRUE TemplateForm.rpx 2 srTaxDetails; subReport1 SO643011.CA.rpx; SO643020.rpx
SO643010.rpx TRUE TemplateForm.rpx 1 subReport1 SO643020.rpx
SV642000.rpx TRUE TemplateFormExternal.rpx 4 laborSub; materialSub; expensesSub; photoSub SV642001.rpx; SV642002.rpx; SV642003.rpx; SV642004.rpx
SV651000.rpx TRUE TemplateFormExternal.rpx 2 laborSubreport; materialSubreport SV651001.rpx; SV651002.rpx
           

 

 

Translate