by Mandy Doward - 5/3/2018

Specifying a No Rows Message for an SSRS/Report Builder Report

I’m sure we have all come across a scenario where a parameter report has allowed a user to specify a combination of conditions that results in no matching records for a dataset behind a region in an SSRS report.

If the report has headers, footers or textboxes then there may be some output produced when the report is run to make it obvious that there is no valid data for the report, as in the following example:


by Mandy Doward - 5/3/2018

Working with PIVOT Tables In SQL Server Queries

Many data analysts will be familiar with exploring data using Pivot Tables in Excel workbooks. The following example shows the detail sales data for bike related products, and an Excel Pivot Table created from that data:

The Totaldue values are grouped by Quarter and product.


by Mandy Doward - 13/1/2020
How many times have you asked yourself that question?

If you work with SQL Server based applications then probably quite a few!


by Mandy Doward - 5/3/2018

Avoiding Oversized Data & Transaction Log Files

If your SQL Server’s performance is slowing down, the first thing to check is the Physical Storage for any oversized Data and Transaction Log files that could be the cause of the problem.


by Mandy Doward - 14/12/2017

Azure Microsoft Official Curriculum (MOC ) Courses

Following PTR gaining Microsoft Learning Partner Status in November we will be adding a number of new courses to our existing Azure training portfolio over the coming weeks.


by Mandy Doward - 20/6/2024

SQL Server Microsoft Official Curriculum (MOC ) Courses

Following PTR gaining Microsoft Learning Partner Status in November we will be adding a number of new courses to our existing SQL Server training portfolio over the coming weeks.


by Mandy Doward - 20/6/2024

 We are very proud…….

…. to announce that last month PTR achieved the Microsoft Learning Partner Status!

Yes, we have added Microsoft Learning Partner Status to our long standing Silver Data Partner Status.

Ian and I formalised our many years of providing consultancy and training services in Microsoft Technologies by attaining Microsoft Certified Solutions Associate (MCSA) certification and Microsoft Certified Trainer (MCT) status.

 


by Mandy Doward - 14/11/2017

 

PTR was 28 years old yesterday and that got me thinking about all the things that have changed over those 28 years!

 

So what does it mean to be 28 years old?

 


by Mandy Doward - 11/10/2017

Working with PIVOT Tables In SQL Server Queries

Many data analysts will be familiar with exploring data using Pivot Tables in Excel workbooks. The following example shows the detail sales data for bike related products, and an Excel Pivot Table created from that data:

The Totaldue values are grouped by Quarter and product.


by Mandy Doward - 13/1/2020

Specifying a No Rows Message for an SSRS/Report Builder Report

 

I’m sure we have all come across a scenario where a parameter report has allowed a user to specify a combination of conditions that results in no matching records for a dataset behind a region in an SSRS report.

If the report has headers, footers or textboxes then there may be some output produced when the report is run to make it obvious that there is no valid data for the report, as in the following example:


Pages