web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Microsoft Dynamics 365 | Integration, Dataverse...
Unanswered

SSRS Reports' subreport is not shown

(3) ShareShare
ReportReport
Posted on by 10
The InvoiceBatch and Invoice has 1:N relationship. 
The report is run from Microsoft Dynamics 365 - V9 ONLINE DEVELOPMENT ENVT  from the Run report on the InvoiceBatch. The parent report has only a  Tablix that has a subreport inserted with 'Invoice number' sent as the parameter. The grouping is done on the Invoice number and the page break is between each instance of the group. 
 
The dataset is created using the Microsoft Dynamics 365 Fetch. The fetchXML renders the dataset.
 
The sub-report runs a full page invoice formatted as below. The sub-report is rendering correctly when ran separately but when the invoice batch report is run- the invoices are not printed and displays the error: "Error: Subreport could not be shown." on each page of the invoice. Say, if there are 5 invoices for an invoice batch- it prints this error message on each page. 
 
For each of the invoices from the Invoice Batch- the below format is printed. 
Categories:
I have the same question (0)
  • André Arnaud de Calavon Profile Picture
    302,663 Super User 2026 Season 1 on at
    Hi LR,
     
    You didn't mention what Dynamics 365 solution you are using. Can you provide more details about what you have done as e.g.  some customizations? If it is related to SSRS only, you can also consider asking your question on the SQL Server forum.
  • JamesForman Profile Picture
    20 on at

    The issue may be with mismatched parameter names or values between the main and subreport. Ensure they align exactly. Also, check if the subreport dataset runs correctly with the passed parameters.

  • LR-23071749-0 Profile Picture
    10 on at
    André Arnaud de Calavon : I have edited my question. Please see if you could add any insights. TIA.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > Microsoft Dynamics 365 | Integration, Dataverse, and general topics

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 72 Super User 2026 Season 1

#2
BillurSamdancioglu Profile Picture

BillurSamdancioglu 64 Most Valuable Professional

#3
Abhilash Warrier Profile Picture

Abhilash Warrier 55 Super User 2026 Season 1

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans