Categories
SSRS Uncategorised

Set Default values but don’t Run the Report

You’ve set up your report and it looks exactly as required, but due to your pre-defined parameters your report returns every record in the table when it first runs (just in case), and your users will probably want to filter the options.

This means there is an unnecessary wait for the report to first render, only for it to change.

Categories
SSRS Uncategorised

How to use Lookup in SSRS

You may be faced with a problem similar to this, where the user wants to display a particular currency symbol that is different for each locality.  It could be possible to alter the underlying dataset to return this information as well as the actual value, but it is entirely possible from within SSRS, as follows

Categories
SSRS Uncategorised

How can I work out Row numbers when Row_Number doesn’t work?

For a variety of reasons (such as this one, where the alteration of the underlying dataset is not allowed) it is sometimes not possible to just calculate the row number for a table using Row_Number.

In these instances you can instead use a combination of CountDistinct and RunningValue, as I mentioned in my original answer.

Categories
SSRS Uncategorised

Use Rectangles to layout your data

Can’t using SSRS be limiting at times?  There you are trying to draw a simple rectangle in a table and the cell just keeps setting the rectangle to be the size of the cell – but you want it another size!  As originally posted.

The trick here is to remember there is nothing stopping you adding another rectangle inside this first rectangle