I have a report RDL that I want to hide one of the columns on. I can set the visibility property to be Hidden = True, but when the report renders, instead of hiding the column, it seems to hide the data. So when the report renders it displays a blank white column in the middle of the report.
Has anyone else come across this? Has anyone any ideas as to how I can get round this? I have put a condition in the expression of the column and whilst this does the job, when I output it to a PDF document, it puts a big black rectangle where the data should be!
Any ideas greatly appreciated.Thanks
asked Mar 22 '11 at 02:09 AM in Default
If you select the table column, and set the width to zero, that seems to do the job, at least in Report Builder 2005. (You may find that the column is actually resized down to 0.08cm width, which is as near to invisible as makes no difference...)
edit -Oh, bother. Doesn't work when the report goes into the website. Sorry.
Did you set the Visibility on the cell in the table or the column? If you dont want to see the column why not delete it from the table?
answered Mar 22 '11 at 02:42 AM