Solved SSRS Report Viewer column display

Posted on 2012-09-19
Last Modified: 2012-09-21
I have a program that passes parameters to SSRS and then opens a win form with a Report Viewer on it.  It works properly except for one thing:

if a cell has a drill down to a subreport, so there is a + sign before the numbers, and if the number is more than 4 digits, it get cut off.  In other words, the value in the cell, with the + sign for drilling down to the subreport should look like this:


However, it displays like this:


If I run the report from the report manager, it displays properly, but when I run it in the Report Viewer from the program, I get the problem.

I have maximized the window, but that doesn't solve it.  Any idea why this is happening?

Question by:thoecherl
    LVL 21

    Assisted Solution

    by:Alpesh Patel
    Please increase the width of that field and numeric so align to right. It will create space between + sing and numbers
    LVL 27

    Accepted Solution

    Also check the column field to see if it is checked true to grow.

    Author Closing Comment

    The report has 26 columns on it, so I spent a lot of time getting the sizes just right.  I can't make them larger or the report won't print.  As I mentioned earlier, when I run the report out of Report Manager on the report server, there is no problem.  Everything fits in the columns.  That's why I didn't discover the problem during development.  It was only when I tried displaying the report in a Report Viewer launched from a program that the problem arose.

    I ultimately solved the problem, by removing all of the padding on the right and left of the cells.  The left and right padding defaults to 4.  I changed it to 0 and that solved the problem.  However, if the numbers get to be 6 digits in length, the problem will occur again.  I can remove the commas and that will give me one more digit, which will probably take care of all contingencies.

    Thanks for your help.


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    How to use Variables  and Custom code in SSRS report and Assembly reference to use compile shared code in SSRS. Its big question for all who are working with SSRS. It is easy to create assembly and refer in SSRS report, still there are some steps…
    A recent questions about how to add SSRS named instances, couldn't find any that talks about SQL server 2008, anyway I decided to help by creating some screen shots. The installation is straightforward, you just pop the SQL server 2008 installati…
    It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
    This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor ( If you're looking for how to monitor bandwidth using netflow or packet s…

    737 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

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now