Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Answered

Customize SSRS Reports with Aggregation (SUM/AVG) lines (total Row)

Posted on by 529

Hello all,

this is my first report be pacient with me :)  [Visual Studio 2013 Tools

I have an SSRS with simple query from ProdRouteTrans group by CategoryId, I wanted a total line row below each group of records but instead a just managed to make the SUM/AVG on the top of each grouping. I want more like an excel table type.

thanks before hand for your help

pastedimage1594212212738v2.png

  • Suggested answer
    CBNestor Profile Picture
    CBNestor 529 on at
    RE: Customize SSRS Reports with Aggregation (SUM/AVG) lines (total Row)

    I was Reading this blog here about fixing page breaks on SSRS reports and the basic approach it recomends is just adjusting the body width - header and footer also - to the Page setup. In my case I use the US Letter page dimensions - even though I am in Europe and we use A4, letter can be printed on the same tray as well - . So I had to adjust the Body and header to 7.5 Inch and now the page breaks are gone. Everything looks smooth now.

    I dont know why the predefault Width when making the precision was longer (8.674in) and I don't know if this has to be done on each single custom report o there is a way to change the default settings.

    pastedimage1594366486601v1.png

  • Martin Dráb Profile Picture
    Martin Dráb 230,149 Most Valuable Professional on at
    RE: Customize SSRS Reports with Aggregation (SUM/AVG) lines (total Row)

    We seem to be off-topic here - it's not about group totals anymore. Please create a new thread (with an appropriate title) for your new question.

    If your original question has been answered, please mark the reply (replies) forming the answer (by using Did this answer your question? > Yes).

  • CBNestor Profile Picture
    CBNestor 529 on at
    RE: Customize SSRS Reports with Aggregation (SUM/AVG) lines (total Row)

    Ok I will try to fix the width . I would like you to help me how to automatic filter the report by the selected production record on ProdPageListForm I have created the controller Class  but I have never worked with that before.

    pastedimage1594303899248v1.png

  • Martin Dráb Profile Picture
    Martin Dráb 230,149 Most Valuable Professional on at
    RE: Customize SSRS Reports with Aggregation (SUM/AVG) lines (total Row)

    It's typically caused by an element exceeding the page width.

  • CBNestor Profile Picture
    CBNestor 529 on at
    RE: Customize SSRS Reports with Aggregation (SUM/AVG) lines (total Row)

    On the Report preview Tab I can the normal report of 8 (1 of 8) pages, if I click the Print Layout 12 more pages are added now  shows 20 pages (1 of 20). black pages are in between every even number: 2,4,6,8,10...20

    pastedimage1594299847221v1.png

  • Martin Dráb Profile Picture
    Martin Dráb 230,149 Most Valuable Professional on at
    RE: Customize SSRS Reports with Aggregation (SUM/AVG) lines (total Row)

    Where exactly is the blank page?

  • CBNestor Profile Picture
    CBNestor 529 on at
    RE: Customize SSRS Reports with Aggregation (SUM/AVG) lines (total Row)

    I am more or less satistied with the result now that you suggest using the precision design - waaayy better with this -. There is one thing bothering me a lot. the report is leaving one page in blank in between (with header) when I want to print really is annoying. You know how I can fix that?

    pastedimage1594290290820v1.png

  • Martin Dráb Profile Picture
    Martin Dráb 230,149 Most Valuable Professional on at
    RE: Customize SSRS Reports with Aggregation (SUM/AVG) lines (total Row)

    The link are about SSRS report designer. It's nothing specific to AX, just pure SSRS, but since AX 2012 uses SSRS, you can use this SSRS feature as well.

    To be able to use the designer, you must use a precision design, as I mentioned in the last reply. You can find a bit more details in AX 2012 documentation: How to: Create a Precision Design for a Report.

  • CBNestor Profile Picture
    CBNestor 529 on at
    RE: Customize SSRS Reports with Aggregation (SUM/AVG) lines (total Row)

    Please be pacient with me. The tutorial is based on Visual studio at template\Business intelligence\Reporting Services And i was following different tutorials where I says Template\Microsoft Dynamics\Report Model AX here I cannot see the any grid. the reports are previewed as a normal page report. That means I am working on the wrong side? because honestly I dont see this options from the documentations you guys are sending me

  • Verified answer
    Martin Dráb Profile Picture
    Martin Dráb 230,149 Most Valuable Professional on at
    RE: Customize SSRS Reports with Aggregation (SUM/AVG) lines (total Row)

    Auto designs give you little control, which is what you're complaining about, therefore it doesn't seem to be the right tool for your requirements.

    I suggest you generate a precision design (right-click your auto design and choose Create Precision Design), open it in the designer and then follow the links mentioned before.

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!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans