Link to home
Start Free TrialLog in
Avatar of itcouple
itcoupleFlag for United Kingdom of Great Britain and Northern Ireland

asked on

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
ASKER CERTIFIED SOLUTION
Avatar of Megan Brooks
Megan Brooks
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of itcouple

ASKER

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

It worked :)
I'm sorry I overlooked the other question. I am traveling this week but I will reply when I have a chance.
No worries, Enjoy your week.
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?
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!
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.