Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested answer

Drilldown/toggle reports in business central

(0) ShareShare
ReportReport
Posted on by 10

Hi all,

I am looking into reports on Business Central. I have created an RDL report. It has groups and subgroups in it. I want to make it collapsible/expandable, but in Business Central i can see pdf output. Which i cannot make collapsible. Is there any other way to achieve this functionality. I know we can do this in PowerBI but is there anyother way to do so.

Please let me know.

Regards,

  • Suggested answer
    THE Italian Profile Picture
    on at
    RE: Drilldown/toggle reports in business central

    Drill through links are not available as interactive in PDF. This is described here

    https://docs.microsoft.com/en-us/previous-versions/sql/sql-server-2008/dd255288(v=sql.100)

    PDF

    Drillthrough links are not available in PDF. Consider using hyperlinks for PDF reports that link to other pages.

    The drill through functionality was only supported by the Report Viewer Preview layout (with windows client).

    You have to use a PowerBI report then.

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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Jonas ”Jones” Melgaard – Community Spotlight

We are honored to recognize Jonas "Jones" Melgaard as our April 2025…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 294,161 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 232,942 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans