SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Salvo(z) SQL

Adam and Jennifer Salvo are IT professionals with over 10 years of diverse experience. Jennifer is a Business Intelligence developer focusing on the Microsoft BI stack (SSIS, SSAS and SSRS). Her prior work experience includes software development, systems analysis, end-user support, training, and SharePoint administration. Adam is a .NET technical lead with a current emphasis on Dev Ops and Windows Azure. His prior work experience includes .NET development, SQL Server administration, and BizTalk development. They also maintain a personal blog at salvoz.com.

Archives: August 2013

SSRS: Ignore Series Grouping in Chart

In SSRS, when you add a Series Group to a chart the data for each series is aggregated based on the series grouping specified. In some situations, you may have a series that you want aggregated differently than the series grouping. 

For example, you may want to display a series… Read more

1 comments, 11,075 reads

Posted in Salvo(z) SQL on 31 August 2013

SSRS: Report Actions, URL Actions and SharePoint

I recently encountered a scenario involving a SSRS report that contains a report action to launch a sub-report.  The child / sub-report originally had two mandatory parameters and the values for these parameters were passed from the parent report to the child.  I wanted to add a third parameter to… Read more

0 comments, 4,595 reads

Posted in Salvo(z) SQL on 7 August 2013

SSRS: Display Series on SSRS Chart Based on Parameter Value

I recently modified an SSRS report to display average run times for various SQL Agent jobs over the past 30, 14 and 7 days.  Displaying all the averages simultaneously would make the chart cluttered and confusing; instead, I opted to control the displayed average via a parameter that the user… Read more

1 comments, 3,247 reads

Posted in Salvo(z) SQL on 5 August 2013