After playing around this evening by following this Channel 9 tutorial – I got the following up and running. If you’re interested, you should say hello, or ask about the weather in a place, or ask about “jonnus” I intend to progress this further following information at this link
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, […]
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
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.
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 […]