SSRS - Filtering data in a report

  • dduensing

    SSC-Addicted

    Points: 422

    I have a dataset (Name, Product A Installed, Product B Installed, Product 3 Installed, NoProducts Installed). I would like to click either a pie chart piece, or a parameter, and only display the records for those names with the requested Product. The columns have either a 1, or a 0 for values. This is a learning effort for me, there may be a way to construct my query better as well, any ideas are appreciated!

    My Data looks like this:

    ServerName	Site	OS	ProdA	ProdB	ProdC	ProdMulti	ProdNone
    DC1 Headquarters Windows Server 2012 R2 Standard 1 0 0 0 0
    DC2 Headquarters Windows Server 2016 Datacenter 1 0 0 0 0
    FS1 Headquarters Windows Server 2012 R2 Standard 1 0 0 0 0
    SP1 Headquarters Windows Server 2012 R2 Standard 0 0 1 0 0
    TST1 Headquarters Windows Server 2016 Datacenter 0 1 1 1 0
    TS2 Headquarters Windows Server 2016 Datacenter 0 0 1 0 0

     

  • Site Owners

    SSC Guru

    Points: 80372

    Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply