[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

SSRS formatting / hidden column not so easy ;)

Posted on 2010-04-09
8
Medium Priority
?
861 Views
Last Modified: 2012-05-09
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
0
Comment
Question by:itcouple
  • 4
  • 4
8 Comments
 
LVL 16

Accepted Solution

by:
Megan Brooks earned 2000 total points
ID: 30217636
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
 
LVL 10

Author Comment

by:itcouple
ID: 30399606
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
 
LVL 10

Author Closing Comment

by:itcouple
ID: 31712702
It worked :)
0
[Webinar] Kill tickets & tabs using PowerShell

Are you tired of cycling through the same browser tabs everyday to close the same repetitive tickets? In this webinar JumpCloud will show how you can leverage RESTful APIs to build your own PowerShell modules to kill tickets & tabs using the PowerShell command Invoke-RestMethod.

 
LVL 16

Expert Comment

by:Megan Brooks
ID: 30521350
I'm sorry I overlooked the other question. I am traveling this week but I will reply when I have a chance.
0
 
LVL 10

Author Comment

by:itcouple
ID: 30524165
No worries, Enjoy your week.
0
 
LVL 16

Expert Comment

by:Megan Brooks
ID: 31060213
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
 
LVL 10

Author Comment

by:itcouple
ID: 31718580
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
 
LVL 16

Expert Comment

by:Megan Brooks
ID: 31769538
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

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this short article I will be talking about two functions in the SQL Server Reporting Services (SSRS) function stack.  Those functions are IIF() and Switch().  And I'll be showing you how easy it is to add an Else part to the Switch function. T…
Time Corrections for Reports Working with a report, we made some interesting discoveries about the time corrections/updates We are using the following Parameters: Starting Entered Date (Date) formatted as Data type: "Date/Time" Ending Entered …
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…
Suggested Courses

640 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question