Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Dynamics 365 general forum

Dyanamically Setting up Report Link to a Sub Action in SSRS

(1) ShareShare
ReportReport
Posted on by 5

I have 2 DataSet in an SSRS  , one Shows the summary one Shows the Details. 

Since the report is very heavy and there is rendering issues showing up on the Screen . 

I like to Show the Summary Page on the screen , but i have a Image which i made it Hyperlink to the same report which export out to Excel.

Where i am stuck is when i click the link it runs the same DataSet again i want the report to run the second dataset (For that i have a Parameter called Mode = 1 (Detail ) and Mode =2 (Summary) 

Below is the expression i am using , but it is taking the default values of the report to run . Can someone help me fix it how can i write the hyperlink so it takes Mode = 1 as default.?

=Globals!ReportServerUrl + "?"+Globals!ReportFolder + "/" +Globals!ReportName+ "&Parameters!Mode.Value=1&rs%3ACommand=Render&rs%3AFormat=EXCEL"

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,403 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans