SSRS formatting / hidden column not so easy ;)

Hi

I'm doing a report based on existing format and come across rather odd issues:

Overview:
 I have matrix reports with extra columns/rows, inside/outside group to create lines which make it look like the client want and my issues are:
1) The last column should be very 'thin' but it expands itself for some reason although there are is no text in, padding is set up to 0 and can grow is set to false on all cells in the column.
2) For some very odd reason when I click column the 'column visibility' is dimmed out and I don't know what I did that it disappered and how to get it back as I need to hide this column.... I tried resizing which works in preview but not in report viewer.

Many thanks in advance
Emil
LVL 10
itcoupleAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Megan BrooksSQL Server ConsultantCommented:
Column Visibility will be disabled if the column contains the first cell of a range of cells that have been merged. If that is what is doing it, split the cells, set the Column Visibility, and then merge the cells again.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
itcoupleAuthor Commented:
Hi Many thanks. I know I played with marging before but now I couldn't find cells which sould still be merged. Fortunatelly when I click 'matrix' cell and insert new column outside/right it added column where I could use column visibility so that works now.

Any ideas why the last column 'grows'? This is not so much of a problem as my colleague will probably use javascript to fix it but would be nice to know?

Many thans in advance
Emil

0
itcoupleAuthor Commented:
It worked :)
0
Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

Megan BrooksSQL Server ConsultantCommented:
I'm sorry I overlooked the other question. I am traveling this week but I will reply when I have a chance.
0
itcoupleAuthor Commented:
No worries, Enjoy your week.
0
Megan BrooksSQL Server ConsultantCommented:
In SSRS 2008 I tried adding a column to a matrix report to the right and outside of the final column group and it seemed to have a mind of its own as far as width was concerned--it seemed to be tied to the width of the final column group, sort of. So I added another column to the right of that and hid the first one, and the 2nd column seemed to behave itself.
Is your last column a column group or is it outside?
0
itcoupleAuthor Commented:
Hi

Thanks for folliwing up on this one. My report is actually used by another person (everyone is doing hard work, apart from me :p) and my JavaScript person removed my reportviewer control and I think embeded it (not sure) to get full table control and he will make my report look nicer :) The Javascript in this case is used to do 'time related project bars' so my reports is just structure and contains XML formatted data in a cell so Javascriot can draw it. Which I think is pretty cool :)

Many thanks for all your help and time. This really makes my SSRS life much much easier!
0
Megan BrooksSQL Server ConsultantCommented:
The new Visual Studio 2010 ReportViewer control may also resolve some of these kinds of issues, in a similar way. It looks good, uses AJAX, and removes the async rendering limitations. I migrated to it yesterday and so far, so good.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
SSRS

From novice to tech pro — start learning today.