In this post, we will see how to resolve Hid or show parameter based on selected parameter/filter Question: I have two datasets which shows to drop downs for parameter selection. one is called ResoursesFilter The other one is PlantFilter select ...
In this post, we will see how to resolve SQL Server Reporting Services – Negating the minimum value of a twos complement number is invalid (reproduced) Question: I have a legacy report (.rdl), which breaks when a certain data is ...
In this post, we will see how to resolve Why I get a syntax error in my SSRS Report Question: Does someone know why I get this error? I have no idea what happened. Table Dataset: Multi-Parameter Dataset Everything looks ...
In this post, we will see how to resolve Hide a column on a row group ssrs report Question: I need to hide only one column with a parameter (Y/N) on a row group. the column visibility is gray out. ...
In this post, we will see how to resolve case statement not working as expected in power BI Question: I have a table in ssms and on using the case statement, it is working as expected as shown: ssms_case_statement But ...
In this post, we will see how to resolve How to filter (WHERE) only some report parameters in SQL Server Reporting Services (SSRS) Question: I need to filter a view in SQL Server Reporting Services (SSRS) with user supplied report ...
In this post, we will see how to resolve SSRS: Cannot Change Tab Name when Exporting to Excel Question: Recently I got a problem and wondering if anyone could help. I have a SSRS report named as ‘Processing Quality Report ...
In this post, we will see how to resolve SSRS – fonts are not emedded into pdf files Question: I am using SSRS 2017 to generate reports, I’ve installed a new font to use with the reports but the font ...
In this post, we will see how to resolve How can I have the grouped variables in an SSRS report show up on each page, either on the footer or header of the page? Question: I have a main report ...
In this post, we will see how to resolve SSRS Drill through Parent report to Child report with 2 parameters Question: I want to drill through from Parent Report to Child Report, Where 2 columns from Parent acts as Parameter ...