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 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
SSRS Subscription Problem
I am using SSRS 2019, latest version, on Windows 2019 server. When I attempt to create a subscription, I get this error message in the SSRS log: System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.ReportingServices.Cloud.DataExtensions' or one of its dependencies. I have checked the file system and this assembly is not present. How can I fix this? Where can I get this assembly?
Help with SSRS 2019 X-Frame-Options
Hi guys, not sure if I am asking this correctly, but we are trying to launch URL links to SSRS2019 reports from a web site. we previously had SSRS2014 with links that are working, however upgrading to SQL2019 has caused us to get the following error Refused to display 'http://devxxxxxxx/' in a frame because it set 'X-Frame-Options' to 'sameorigin'. I have reviewed this reference Server Properties Advanced Page - SQL Server Reporting Services (SSRS) | Microsoft Learn which is indicating I need to update the CustomHeaders attribute. I've tried several variants with no success The best I can get is the following (note I have replaced the URL name with xxxx <CustomHeaders> <Header> <Name>X-Frame-Options</Name> <Pattern>(?!(http|https):\/\/([^\/]+)\/*xxxxx.*$)</Pattern> <Value>ALLOW-FROM</Value> </Header> </CustomHeaders> This has then caused the error to Refused to display 'http://devxxxxxx/' in a frame because it set multiple 'X-Frame-Options' headers with conflicting values ('SAMEORIGIN,ALLOW-FROM'). Falling back to 'deny'. Is there something I am missing? Also note I can get the URL working if I add ?rs:embed=true to the end of it, however thats a bit much on all existing URL's Thanks in advance,