How to hide column in table in report.

[terpster73]

We'd like to be able to hide a column in a report when the total value of the column is zero.

We have 85 schools that report various information to us, # of teachers, if they are certified, classes they teach etc. If a school didn't report to us in any given year we'd like to be able to just exclude that information from displaying. (so we don't just see a column of zeros all the way down the page)

I realize you may need more information to help me, so please ask away. I'm very new to reporting services(started working in it last week) so please bear with me as I try to figure this all out. Any assistance would be greatly appreciated.

 

[xlbo]

You have alittle problem here. Within the report, if you hide a column (which you can do based on an expression), the column will be hidden but the columns to the right of it will not collapse back so the column is literally hidden but rather than the next column following on, you get a nice fat white column instead

Your best bet is to exclude these schools from the Dataset that is feeding the report itself - how you do that will be dependant on your table structure and current query but normally, an inner join between 2 tables will prevent this kind of thing from happening..

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[terpster73]

Thanks for the reply. A big fat column of white is not what we were hoping for!

The problem is, with so many schools, one school may not have reported in 2000, and another in 2004 and so on. So it's not as easy as just removing them from the report.

 

[xlbo]

Guess it depends how your tables in the report need to be structured - can you give me an idea of the report layout and the basic table structure that you are querying?

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question