SSRS - Filtering data in a report

  • 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:

    ServerNameSiteOSProdAProdBProdCProdMultiProdNone
    DC1HeadquartersWindows Server 2012 R2 Standard10000
    DC2HeadquartersWindows Server 2016 Datacenter10000
    FS1HeadquartersWindows Server 2012 R2 Standard10000
    SP1HeadquartersWindows Server 2012 R2 Standard00100
    TST1HeadquartersWindows Server 2016 Datacenter01110
    TS2HeadquartersWindows Server 2016 Datacenter00100

     

  • 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 1 (of 1 total)

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