topic Re: SSRS Cilckable Images based on logged in user in Report Server

SSRS Cilckable Images based on logged in user

Vandithak — Wed, 02 Apr 2025 06:39:58 GMT

Hi Community Support Team,
Need help on below requirement / suggest a video. This should be Implemented in SSRS

I have 6 images, these should be arranged in 2 rows and 3 columns,

Image1 Image2 Image3

Image 4 Image 5 Image6

and have a below daatest with below details
SELECT ImageID, ImageName, ImagePath, PageURL, UserID
FROM ImageLinks
WHERE UserID = @UserID

The requirement is to display six images for all logged-in users, with only the images relevant to the user being clickable, while the rest remain non-clickable.

Note: Userid parameter should display on top

1. Display all images
2. Add Page URL to 6 Images
3. let say, if User 1 is logged in he/she can only click relevant image, rest all non clickable. It should be dynamic

ImageID	ImageName	ImagePath	PageURL	UserID
1	Realtime	file:C:\Users\\Downloads	https://Reports/powerbi//REALTIME%20ANALYTICS	analytic1
2	Incident	file:C:\Users\\Downloads	https://Reports//INCIDENT%20ANALYTICS	user5
3	Maintenance	file:C:\Users\\Downloads	https://Reports//MAINTENANCE%20ANALYTICS	analytics2
4	Safety	file:C:\Users\\Downloads	https://Reports/SAFETY%20AND%20SECURITY%20ANALYTICS	NULL
5	Operations	file:C:\Users\\Downloads	https:/Reports//OPERATIONS%20ANALYTICS	User2
6	Landing Analytics	file:C:\Users\\Downloads	https://Reports/Landing%20Dashboard	User3

Re: SSRS Cilckable Images based on logged in user

v-saisrao-msft — Wed, 02 Apr 2025 10:36:43 GMT

Hi Vandithak,

Thank you for reaching out to Microsoft Fabric Community.

Are you looking to implement this in SSRS (SQL Server Reporting Services) or Power BI?

Thank You.

Re: SSRS Cilckable Images based on logged in user

Vandithak — Wed, 02 Apr 2025 14:09:28 GMT

Hi Sai,

Needs to be Implemented in SSRS

Thanks

Re: SSRS Cilckable Images based on logged in user

v-sathmakuri — Fri, 04 Apr 2025 07:32:34 GMT

Hi Vandithak ,

Thank you for reaching out to Microsoft Fabric Community.

As this is microsoft fabrics forum, i would suggest raising a ticket is SSRS forum https://techcommunity.microsoft.com/category/SQL-Server/discussions/SQL-Server-Reporting-Services .

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!