I have Visual Studio 2005 and the.net 2.0 version. I'm using Rdlc, which has a matrix, to create data for an excel report. Based on the Date column, I need to group the records. Why are there more vacant spaces in the output excel report, I wonder.
This is the Rdlc
Blank gaps in the Excel output are noted below:
Am I forgetting to configure some rdlc properties?
I also attempted to change the column's visibility using the formula
1.=IIF(IsNothing(Fields!Title.Value),False,True)
2.=IIF(Len(Fields!Title.Value) = 0,False,True)
They both failed
In the Group Property , set the expression in Visibility tab to =IIF(Fields!Title.Value="",True,False)