One of your five a day
An interesting point came to my attention today with regards to rounding in SQL Server and its features, in this case Reporting Services.Let’s take 62.5 as our magic number, as 3 doesn’t illustrate the issue!In SQL Server Management Studio, we
Sometimes we’ll want to hide lots items from the tile view in Reporting Services. There’s no quick way to, for example, hide all your sub reports view the user interface. As long as you’ve got a standardised naming convention, such as prefixing
To find out which SQL Agent job is running your SSRS schedule simply use the query below substituting your ReportServer name and your ReportName. Many reports can run using the same shared schedule so use caution if running the job
When looking at a monthly report showing all the days of the month it can help to split up the days by highlighting the weekends. We do this by applying a change in background colour (in each column) with the method
Let’s imagine we’re producing some simple reports and we only can track the number of pies returned across a whole despatch and not for each despatch type. We have a single query whose results breakdown each DespatchID into the various