sql-servervisual-studioreporting-servicesvisual-studio-2017ssrs-tablix
How to hide a column in SSRS Matrix report in SQL Server
I've got a SSRS matrix report in VS2017. I need to hide a column based on no.of days in a month.
Eg: Need to hide 29,30 & 30th Column in case of Feb Month in pic provided below.
My report's Dataset consists of 38 columns, I found this article with settings as =IIF(CountRows()>12,true,false) but this still fails. My report still shows the 29,30 & 32 columns.
Any help would be much appreciated.
Solution
Select the column to hide, right-click --> Column Visibility --> Show or hide based on an expression --> Click f(x) to provide expression as provided below
=IIF(Count(Fields!.Value) = Cint(0), True, False)
- Summation of a column using certain conditions
- Add a value on their SESSION_CONTEXT for all sys.dm_exec_sessions
- Natural join in SQL Server
- How to concatenate text from multiple rows into a single text string in SQL Server
- SQL Server Cursor vs WHILE loop
- SSIS: Insert multiple Excel files with same format but different file name to multiple database table destinations based on the Excel filename
- Seeking Advice on Efficient Data Unpivoting in SQL Server with SSIS or Alternative Tools
- SQL-How to Insert Row Without Auto incrementing a ID Column?
- Why can't I use an alias in a DELETE statement?
- Can ransomware encrypt a mounted SQL database? Hypothetical
- Grant user DDL permissions on specific schema
- How do I perform a GROUP BY on an aliased column in SQL Server?
- Collecting data from a joined table based on condition(s) in the joined table
- Stored procedure for auto generating roll no?
- Is there any way to get lcid of current session in a function with schemabinding option?
- How to find databases which accessible to me in Sql server?
- Default encoding in SQL Server Management Studio
- Database stuck in "Restoring" state
- Unable to open BCP host data-file
- How to join parent object with nested array using OpenJson SQL
- Efficient paging with Repeater, SQL Server and custom Pager
- Queries using LIKE wildcards in sql server
- Conditional aggregation in SQL: display condition-dependent count in percentage?
- What would be the ideal way to do paging using a Infragistics WebDataGrid and SQL Server 2008
- output sql data to html with hyperlink
- Update all column names to be lowercase
- Connect python-polars to SQL server (no support currently)
- SQL Server pivoting on data without an aggregate
- replace or remove characters and then cast to decimal
- Query to get only numbers from a string