Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Multiple SSRS report i...
Finance | Project Operations, Human Resources, ...
Suggested answer

Multiple SSRS report in one report viewer

(0) ShareShare
ReportReport
Posted on by M.Nauman Rashid 303

Hi experts,

I have the payment journal line report which executes according to each line of the payment. E.g when I select one line and print the report it gets the data of the payment line on the report on one single page. And when I select other line and print the report it opens another report viewer related to that line which is fine yet. Now I have the requirements in which user want to see all payment line reports in one report viewer. E.g if there are 10 lines in the payment journal then there should be one SSRS report viewer open with 10 pages; 1 page for each payment line.

So how we can achieve this and what is the best way to perform these type of requirements?

Thanks

  • AhmedRazaAttari786 Profile Picture
    AhmedRazaAttari786 51 on at
    RE: Multiple SSRS report in one report viewer

    Hi Nauman

    Add report footer and check Tablix add page break property.

    I am not sure but I think it will work..

    Thanks

  • M.Nauman Rashid Profile Picture
    M.Nauman Rashid 303 on at
    RE: Multiple SSRS report in one report viewer

    Hi Ahmed Raza,

    Thanks for reaching out on this. I also did the same using Tablix and row group functionality but I have a little design issue which need your suggestion. Basically I also have the row group footer line on the same Tablix which needs to be at bottom of the page like footer usually is. So right now if there is only 1 line in Tablix detail section then last row which is footer is coming next to detail section and below section of page remain blank. where as I want that last footer row to be at bottom of the page even it is a part of the Tablix.
    So how can I achieve that using same Tablix functionality. Any suggestions?

    Thanks

  • Suggested answer
    AhmedRazaAttari786 Profile Picture
    AhmedRazaAttari786 51 on at
    RE: Multiple SSRS report in one report viewer

    Hi Muhammad Nauman,

    I recently achieved this requirement by using Tablix..

    your complete design which you want to repeat should be Tablix based.. and add row group  "Voucher No" on Tablix.. Uusing this approach you can repeat your design for every Voucher..

    Thanks,

    Ahmed Raza

  • M.Nauman Rashid Profile Picture
    M.Nauman Rashid 303 on at
    RE: Multiple SSRS report in one report viewer

    Hi Girish and Martin,

    I used the subreport to achieve this functionality but the problem is I am getting the error "Subreport could not be shown" whenever I execute the parent report through AX.

    1- I have created the another DP and contract class for the subreport with one parameter i.e. payment id

    2- Then i have added that parameter to the Subreport -> Properties -> Add with the parent report value

    but still getting same error ("Subreport could not be shown" ). Can you please advise that I am missing here?

  • M.Nauman Rashid Profile Picture
    M.Nauman Rashid 303 on at
    RE: Multiple SSRS report in one report viewer

    Please see the below green highlighted design and comments and let me know your thoughts? May be this can give the clear understanding what I need to do.

    3051.report.png

    Thanks

  • Martin Dráb Profile Picture
    Martin Dráb 230,198 Most Valuable Professional on at
    RE: Multiple SSRS report in one report viewer

    Why exactly do you think that a tablix wouldn't work? Is it because you aren't aware of the support for grouping at all, or do you have a problem with it that you don't know how to resolve?

    I would avoid the subreport completely, but if you decide to insist on using it, we'll need more information about what you did.

  • M.Nauman Rashid Profile Picture
    M.Nauman Rashid 303 on at
    RE: Multiple SSRS report in one report viewer

    okay so here is the scenario, I have one datasource 'xyz' having ledgerjournaltrans records and invoice records. Consider it like one ledgerjournaltrans record having multiple invoices (1:m relation). Now i am able to used the ledgerjournaltrans records (vendor id, method of payment, payment id etc.) as group by which actually did the page break part but I also have to show the invoice details in same report in body which can be multiple because the invoices can be multiple of each ledgerjournaltrans line. So i think tablix will not work here due to grouping so i add subreport and use the same datasource 'xyz' which actually have invoice detail also.

    Now i want to add and filter subreport through main report by giving payment id as a parameter. When i use payment id parameter in the report it gives me error "Subreport could not be shown" whereas if I removes the parameter then it shows me all the records of the datasource without the filteration of payment id which is incorrect because it need to be filtered according to the payment id. Please advice what we need to do to achieve this.

  • GirishS Profile Picture
    GirishS 27,832 Super User 2024 Season 1 on at
    RE: Multiple SSRS report in one report viewer

    Yes, As per Martin suggestion - It must be in the report body.

    Thanks,

    Girish S.

  • Martin Dráb Profile Picture
    Martin Dráb 230,198 Most Valuable Professional on at
    RE: Multiple SSRS report in one report viewer

    Then the information about vendor etc. needs to be in the report body, not in the page header (or foooter).

  • M.Nauman Rashid Profile Picture
    M.Nauman Rashid 303 on at
    RE: Multiple SSRS report in one report viewer

    Thanks Girish i think it will work but want to know if there are header and footer involved those also have LedgerJournalTrans records and the tablix is just involved in the body section not in header and footer then how we can print it on multiple pages?

    For example we have 10 lines in LedgerJournalTrans table having different vendor id's and these vendor id need to populate on the header section. So we want to have separate vendor id on each page having related LedgerJournalTrans records in body section.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans