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
- 6 replies
- 22 views
- Translate All
6 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 I
- 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 |
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.