Hidden Columns in Visual Studio


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.

more ▼

asked Mar 22, 2011 at 02:09 AM in Default

KazHeath gravatar image

51 4 4 5

(comments are locked)
10|1200 characters needed characters left

4 answers: sort voted first

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.
more ▼

answered Mar 22, 2011 at 02:24 AM

ThomasRushton gravatar image

ThomasRushton ♦
34.1k 18 20 44

(comments are locked)
10|1200 characters needed characters left
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?
more ▼

answered Mar 22, 2011 at 02:42 AM

Fatherjack gravatar image

Fatherjack ♦♦
42.8k 75 79 108

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Mar 22, 2011 at 02:09 AM

Seen: 1415 times

Last Updated: Mar 22, 2011 at 02:09 AM