Forum Discussion
SSRS Cilckable Images based on logged in user
Hi Community Support Team,
Need help on below requirement / suggest a video. This should be Implemented in SSRS
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 |
3 Replies
v-saisrao-msftCommunity Support
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.
Hi Sai,
Needs to be Implemented in SSRSThanks
- 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!
