Formatting subtotal rows

Picture says it all, but i'll type it incase blogger decides to lose my screen shot. RIGHT CLICK THE TINY GREEN TRIANGLE!

Reporting Services Custom Code gotchas

1) When using functions make sure to remember to use/know to use case...as in:

string.toupper() - does not work
string.ToUpper() - DOES work...

Filter results based on Nulls

In many of my Reporting Services reports I use a SINGLE stored procedure for all matrices that returns one table with data in various forms to include cumulative totals of certain fields. When I want to extract and use just this summary information alone, I need to usually extract that data from the result set. The totals records/rows (created by using a SQL ROLLUP or GROUPING SET function) report NULL for the columns its not totaling.
Here is how you would write the filter to get those rows:

Clearing parameters so that a report runs automatically

You need to remove the parameters from two areas:

1) from the 'right click' parameter area on the report layout
2) from the dataset itself. Click the '...' button and clear parameters.

'Print View' of a report seems to add blank pages

In this case, my sub report was the problem.

After I adjusted the width of the actual sub report, I was able to print preview fine (blank pages gone).

Now i'm having issues with the page header causing my reports to bleed onto two pages. Merely adding a page header seems to cause margins to change...

SOLUTION:

Width of report items is usually the culprit here.