![ms report builder 2012 ms report builder 2012](https://markswinkels.nl/wp-content/uploads/2012/03/SRS_02.jpg)
SUM(CASE WHEN UCS.Status = 3 THEN 1 ELSE 0 END) AS 'Total Installed',
![ms report builder 2012 ms report builder 2012](http://4.bp.blogspot.com/-3Hgncl1auks/UNyNkAo6xMI/AAAAAAAAARM/hOsrelmGITU/s1600/SCOM-2012-Disk-Report-Image1.1.jpg)
SUM(CASE WHEN UCS.Status = 2 THEN 1 ELSE 0 END) AS 'Total Missing', Next step, add another new data set that says this (look familiar? it just removes grouping from the original report):Ĭount(DISTINCT CS.Name0) AS 'Total Systems', You could export all this data to Excel and add everything together and get a number, but I don't like by boss's boss to talk to me so I just want to include it on the report. So what else can we add? Well the first thing someone always asks me for is an overall compliance status. Run it! Still needs some clean up but we'll get to that when we add some more to the report. So click add for each of the following and specify: I could to a query and find all the types, but I also what to be able to specify All, and if you get from a query you can't add to it. In Default Values, select Specify Values and enter the CollectionID that you want to use as a default.įor I'm going to use the Specify Values option for Available Values. Value field is what you want returned, the CollectionID, and the Lable Field is what you'll see in the selection, use NameSort. Select your new Data Set, should be Data Set 2. In Available Values, select 'Get values from query'. Now in the properties, change the Prompt to 'Select Collection: '. Select 'Use a dataset embedded.', choose your data source, and paste something like the following in the query box. So right click datasets and select add dataset. You saw the 'Get Values from a query' option in there didn't you? You want to try it don't you? Uh, how you ask? Well first you need another dataset just for your drop down. But I have several thousand workstations so I work on a subset at a time. If you want to look at all first, Default it to %.
#Ms report builder 2012 code
On Default Value enter the filter you use most often followed by a % for the wildcard, ie I use the 3 digit code that specifies machines near me. Any way, edit (r-click, properties). In General change the prompt to "Enter Name Filter (% for all)".
![ms report builder 2012 ms report builder 2012](http://4.bp.blogspot.com/-1MSEo420Zfo/VY2OWNqojwI/AAAAAAAAAO8/8Qb-WDcHKCY/s1600/pic1.jpg)
But next I'm going to make it easier.Įxpand Parameters and you'll see the three you built earlier. Ok now you can run it if you want, I know you will anyway. This is a summary and I want it really squished. On the next screen, I uncheck Show Subtitles and Expad/collapse groups. System is your Row Group, the rest are values. So that's your first dataset, now to make it cool. Hmm, I can already see one machine I have to look at. (edit: I didn't originally change to LIKE, I did it after the screenshot.)