ssrs interview questions
2 TopicsSSRS 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 User3771Views0likes3CommentsTechnical Preview of Power BI Reports in SQL Server Reporting Services
Just had a chance to play with the Technical Preview of Power BI Reports in SQL Server Reporting Services. You can set up the VM yourself or download the updated Virtual Machine from Azure Marketplace. I set up my own Virtual Machine and what you need is an instance of SQL Server 2016 or SQL Server vNext CTP v1.1. Also install Analysis Services Tabular or Multi-dimensional mode and sample database for the same. Note: The preview version supports only Power BI Dashboards connected to Analysis Services on-premises otherwise you will get the following error. It comprises of 3 files PBIDesktopRS.msi PBIDesktopRS_x64.msi SQLServerReportingServices.msi Install the SQL Server Report Services and use the SSRS Preview Configuration Manager to create the Report Server Database. Note: You will be seeing Create Database button in the screenshot similar to the above instead of Change Database. The above screenshot was taken once the Database was created. Install the Power BI Desktop for Reporting Services 64-bit version and create a Power BI Report connected to your Analysis Services Database. Upload your new Power BI Report created using the Preview version of Power BI Desktop to the SSRS Portal and try navigating to the report. As you can see from the above screenshot, Power BI report opens within the SSRS Portal Browser window.Solved4.3KViews1like1Comment