x
login about faq Site discussion (meta-askssc)

Hidden Columns in Visual Studio

Hi

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

more ▼

asked Mar 22 '11 at 02:09 AM in Default

KazHeath gravatar image

KazHeath
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 '11 at 02:24 AM

ThomasRushton gravatar image

ThomasRushton ♦
29.4k 6 9 36

(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 '11 at 02:42 AM

Fatherjack gravatar image

Fatherjack ♦♦
38.8k 55 69 104

(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.

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments



Facebook logo Follow Ask SSC on Facebook
Find Ask SSC on Google+
linkedin logo Find us on LinkedIn

Topics:

x17
x5

asked: Mar 22 '11 at 02:09 AM

Seen: 785 times

Last Updated: Mar 22 '11 at 02:09 AM

Copyright © 2002-2012 Simple Talk Publishing. All Rights Reserved. If you have any queries, please contact the site administrators.
Ask SQL Server Central is a community service provided by Red Gate.