Skip to main content
Question

sub reports

  • Nov 16, 2026 5:37 PM UTC
  • 7 replies
  • 36 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 ?

7 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 II
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

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

Steve Milner
Varsity III
Forum|alt.badge.img+7
  • Varsity III
  • Nov 17, 2026 7:06 PM UTC

My replies are created in part with the help of proprietary AI, built with my AI skills, curated and maintained myself. Most replies are tested on local instances before they go up, and all are reviewed before posted.

@dalesimmerly58 Will’s script covers the stock .rpx files and Krunal’s query covers reports saved to the database. I’d add one filter to the query. UserReport keeps a row for every version saved from Report Designer, and only the active version runs. Without a filter, a report can show up once per version, and an old inactive version that had a subreport still matches.

Adding the IsActive flag returns only the versions in use:

SELECT CompanyID, ReportFileName, Version FROM UserReport WHERE IsActive = 1 AND Xml LIKE '%subreport%'

We ran both on a 26.101 demo database. Krunal’s query returned three rows and this one returned two. The extra row was an inactive version of AP641000.

Translate