Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics 365 | Integration, Dataverse...
Unanswered

SSRS Reports' subreport is not shown

(2) ShareShare
ReportReport
Posted on by 8
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:
  • LR-23071749-0 Profile Picture
    LR-23071749-0 8 on at
    SSRS Reports' subreport is not shown
    André Arnaud de Calavon : I have edited my question. Please see if you could add any insights. TIA.
  • JamesForman Profile Picture
    JamesForman 20 on at
    SSRS Reports' subreport is not shown

    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.

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,904 Super User 2024 Season 2 on at
    SSRS Reports' subreport is not shown
    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.

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Share Your Event with the Community

Jump start your event engagement! 📢

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,904 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,605 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans