Solved

Dynamic column width using Can Grow/Can Shrink

Posted on 2008-06-24
5
5,543 Views
Last Modified: 2010-04-21
Hello Experts,

I have a table in Reporting Services 2005 that contains potentially 30 columns ... however, they are all set to not show if they contain no data.  In reality, the table generally will show no more than 12 or so columns and can fit easily on a landscaped page.  The report is working fine and the export to Excel is also working fine - but if printing or exporting to PDF, all the blank pages caused by the original width of the table are included.  That is, the table with its full 30 columns is a lot wider than the actual result the user sees, and that width is taken up with blank pages.    At design time, I cannot alter the width of the table because even if I make all the fields small enough and then set them to "Can Grow" - they don't grow and I end up with a squished-looking mess.  Which is frustrating because I would have thought that's the whole point of "Can Grow" and "Can Shrink".

Has anyone got any idea how we can get around this issue?

Thanks in advance,
GHL
0
Comment
Question by:gailhl
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 18

Accepted Solution

by:
chrismc earned 500 total points
ID: 21858688
Can grow/shrink refers to cell/row height, not width.

In your scenario I would limit the number of columns but make the contents conditional.
So if showing FieldA and FieldB are mutually exclusive but based on a parameter setting you could have;
  =IIf(Parameters!myFormatChoice.Value = "A", Fields!myFieldA.Value, Fields!myFieldB.Value)

You'd have to do similar conditional checks in group totals as well but it will work and you then can layout the screen more realistically.
0
 

Author Comment

by:gailhl
ID: 21872674
Thanks ... unfortunately that won't work for me because it is possible depending on the parameters chosen, that all the columns will be visible.  There are 24 month columns, plus other data - and I just hide the months that have no data.

I'm giving you the points anyway - because I suspect that what I want to do is simply not possible - and you taught me something I didn't know about Can Grow/Shrink!  Thanks!  :-)

0
 

Author Closing Comment

by:gailhl
ID: 31470096
Although my data doesn't lend itself to this solution, it's a really useful idea for future.  Thanks.
0
 
LVL 18

Expert Comment

by:chrismc
ID: 21885857
Thanks for the points.
And I think in your scenario you are stuck.

I had a first look at Reporting Services 2008 last night and apparently Microsoft have paid a lot of attention to pagination issues like this.
It's scheduled for full release in Q3 2008
0
 

Author Comment

by:gailhl
ID: 21897520
I look forward to the release! :-)
0

Featured Post

Webinar: Aligning, Automating, Winning

Join Dan Russo, Senior Manager of Operations Intelligence, for an in-depth discussion on how Dealertrack, leading provider of integrated digital solutions for the automotive industry, transformed their DevOps processes to increase collaboration and move with greater velocity.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Query Builder end user tool for SQL Server 1 105
Selection from table2 where criteria for table1 10 59
sql query help 2 62
kill process lock Sql server 9 75
by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

733 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