• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 951
  • Last Modified:

vb.net SSRS Report Viewer column display

I have a vb.net 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 vb.net program, I get the problem.

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

2 Solutions
Alpesh PatelAssistant ConsultantCommented:
Please increase the width of that field and numeric so align to right. It will create space between + sing and numbers
Also check the column field to see if it is checked true to grow.
thoecherlAuthor Commented:
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 vb.net 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.


Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now