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
Dataset in Report Builder returns NULL for values in certain fields
Hello. I have built a query for a dataset in Power BI Report Builder that is pointing at a semantic model in my organization's workspace. I built the query using the desktop program's query editor. It is returning NULL values for a few fields (not all fields) in a table, even though the fields do contain text. I made a paginated report on the online service (clicky-clicky-draggy-draggy method, as Guys in a Cube would say) that is based on the same semantic model, and no such NULL values appear. I have tried to download the .rdl of the report that is working, then import the dataset query into my other report, but it still returns NULL values once it is evaluated in my report. My main questions: 1. Is there another way to move dataset definitions between .rdl files, other than the "Import" button? For example, can I directly copy the .xml code somehow? I found an old forum post that suggested this method, but it seems like it is no longer possible in the latest Report Builder. Should I just do this in Notepad or similar? My other idea was "report parts" but it seems those have been phased out too. 2. Any ideas why my query built on desktop is failing to return values, while the one built in the service is fine? My main clue is that these fields include special characters (the values are text written in Spanish). Or maybe that the field titles include bracket symbols (this is how we distinguish between fields containing English vs. Spanish versions of the same information... e.g. one troublesome field is called "Definition [ESP]" in the semantic model. ). If I can't solve this, I guess I can create every .rdl on the online service first, then modify it on the desktop, but I can imagine many scenarios down the road where this will be problematic. Seems silly that I can't get the query to work when it is built in the desktop app! Thanks!
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