do you know of a way to create a list of all reports that contain a subreport ?
sub reports
- Nov 16, 2026 5:37 PM UTC
- 7 replies
- 36 views
- Translate All
7 replies
- Author
- Pro I
- Nov 16, 2026 5:38 PM UTC
- Varsity I
- Nov 16, 2026 5:44 PM UTC
- Acumatica Support Team
- Nov 16, 2026 5:51 PM UTC
- 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.
- Pro II
- Nov 16, 2026 8:19 PM UTC
Hi
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!
- 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 |
- 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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.