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
Adding an optional for Parameter setting in report builder/paginated report
Hi guys, I am currently working on a paginated report that focuses on financial data. The report comprises three main columns: Level 4, representing account details; YTD actual, showing year-to-date actual values; and YTD PY actual, displaying year-to-date prior year actual values. One of the parameters in the report is called "Company." I am attempting to enhance the functionality of this parameter by adding a new option to the dropdown list, labeled as "All." The purpose is to allow users to select this option, indicating that they want to include data from all companies when generating and printing the reports. (the default setting will be the first parameter option) However, I have got errors in implementing this feature. Could you assist me in finding a solution to this issue? The original query designer looks like: EVALUATE SUMMARIZECOLUMNS ( 'DimGroupAccountStructure'[Level4], RSCUSTOMDAXFILTER ( @DimDateFinYear, EqualToCondition, [DimDate].[FinYear], Int64 ), RSCUSTOMDAXFILTER ( @DimEntityCompanyName, EqualToCondition, [DimEntity].[CompanyName], String ), "YTD Actual", [YTD Actual], "YTD PY Actual", [YTD PY Actual] ) What I have done: motified the Data set query in Query designer: EVALUATE SELECTCOLUMNS ( ADDCOLUMNS ( SUMMARIZECOLUMNS ( ROLLUPADDISSUBTOTAL ( 'DimEntity'[CompanyName], "h0" )), "ParameterLevel", IF ( [h0], 0, 1 ) ), "ParameterCaption", SWITCH ( [ParameterLevel], 1, 'DimEntity'[CompanyName], "All"), "ParameterValue", SWITCH([ParameterLevel],1,'DimEntity'[CompanyName], "All Companies"), "ParameterLevel", [ParameterLevel], "'DimEntity'[CompanyName]", SWITCH ( [ParameterLevel], 1, 'DimEntity'[CompanyName], "All" ) ) ORDER BY [ParameterLevel],'DimEntity'[CompanyName] 2. Added a new line in CompanyName parameter Query Designer: EVALUATE SELECTCOLUMNS ( ADDCOLUMNS ( SUMMARIZECOLUMNS ( ROLLUPADDISSUBTOTAL ( 'DimEntity'[CompanyName], "h0" )), "ParameterLevel", IF ( [h0], 0, 1 ) ), "ParameterCaption", SWITCH ( [ParameterLevel], 1, 'DimEntity'[CompanyName], "All"), "ParameterValue", SWITCH([ParameterLevel],1,'DimEntity'[CompanyName], "All Companies"), "ParameterLevel", [ParameterLevel], "'DimEntity'[CompanyName]", SWITCH ( [ParameterLevel], 1, 'DimEntity'[CompanyName], "All" ) ) ORDER BY [ParameterLevel],'DimEntity'[CompanyName] Changed the Parameter filter expression: 'DimEntity'[CompanyName]= "All" || 'DimEntity'[CompanyName]= @DimEntityCompanyName Finnaly, I got error message: the parameter CompanyName is not declear. I am suffring from this query designer, every Dax is working on Dax studio, but when I apply in Query designer is not working. Thanks for your help!!
Report section (reportsection0) is out of range, it must be between 0mm and 11557mm
Hi, Can I please get assistance. I am building a paginated report with many pages, however I have since came across an error as I add more pages, The actual error is "The value of the Height property for the report section 'ReportSection0' is '12053.5527mm', which is out of range, it must be between 0mm and 11557mm". Is this the max, is there a way I can resolve this issue. I need to add many pages to my paginated report. Thanks
