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
Best Option for Model Reuse in PBRS - SSAS? SSRS Datasets?
Hello, We have a customer that is planning on an extsensive PBRS solution with many "modules" (reports). There will be a lot of common content in the models serving the different reports and we are looking for options to build "Model Infrastructure". I know that one option is SSAS, but the customer is not very happy with this option because: a. They don't have this skill and don't want to develop it, b. The DWH is on Oracle and they don't want an SSAS instance I saw that there is option to connect to SSRS datasets (which they have the skill and the place to build). What's your opinion about using SSRS datasets as shared model infrastructure? Is there an advantage for an SSRS dataset over a view or a table in the DWH that is updated by a Stored Procedure? Is there any other option? Thanks, Barak
Multiple Databases in a dataset
Hi, We have a requirement of fetching data from two databases for most of our SSRS related paginated reports. Creating a data source in the Report designer (Visual Studio) allows connection to be made to a single data source only (1 database). Is there a best practice approach/solution to this requirement other than the one we got? (Detail below) We did some research and figured out a way to deal with it, but it only works if the 2 databases reside on the same server. When writing the report queries, we can append the database name with the schema to reference the table we require. For example: Select D.DeptDescription, S.Amount from TESTDB1.dbo.Dept D join TESTDB2.dbo.Sales S on D.DeptCode = S.DeptCode Using the above approach we face a different problem; related to migration. We have different DB names on Development and Production servers, meaning we can’t use the same query on Prod to get the same data (Database in Prod might be LIVEDB1 and LIVEDB2). So every time a report is deployed on Production the query will need to be modified. Is there a work around or a better/clean solution for this? -Thanks Yaseen