SSRS Cilckable Images based on logged in user

[Vandithak]

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

[v-saisrao-msft]

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.

[Vandithak]

Hi Sai,

Needs to be Implemented in SSRS

Thanks

[v-sathmakuri]

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!