Sol Web Solutions Blog

I had a customer request to hide a row conditionally, but when the report rendered in the browser the hidden row still took up spacing on the report.

I found this post thanks to Frank v.d. Laar:

http://www.sqldev.org/sql-server-reporting-services/hidden-rows-still-displayed-9660.shtml

Try to set the Hidden property of the Static Row Group under the Details Group, in this case the whole row will disappear instead of the content of the textboxes.

If you are using Report Builder, you need to switch to Advanced Mode (make sure that the Properties and the Grouping windows are displayed, go to the upper right side of the Grouping window and press the black triangle), click on the second "Static" item under the "(Details)" group and you can set the Hidden property on the Properties window.

A report is developed, but then the customer makes a request to have the headers visible as they vertically scroll.

What do you do?

On a recent sub-report, there were 2 rectangles to control rendering, and the page size was left @ 11 x 8.5.
The report looks fine in the Visual Studio IDE while developing the report, but if the user tried to print the report or export the report, there was a huge blank space on the page.  What fixed the issue?

We have a bug/enhancement list we use to show what items have been completed, if they are bugs or enhancement, assignees, etc.
The description field is a rich text and multiple lines of text.  When the report is run, the HTML tags show up.

How did it get resolved?

Getting SQL Server 2008 Reporting Services series chart line to start @ 0 (trying to mimic another chart in another application that does the same thing) was a bit of a challenge.  The line chart series is being used for accounting and starts at the January amount, say $10,000 for the first month data value.

After much searching to try to get around the division by zero issue, I had to create a custom code function for both the report rendering and interactive column sorting to work.