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.
Continue reading “Set Default values but don’t Run the Report”
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
Continue reading “How to use Lookup in SSRS”
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.
Continue reading “How can I work out Row numbers when Row_Number doesn’t work?”
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
Continue reading “Use Rectangles to layout your data”