MSPbots has prebuilt widgets to help organize your reports on one page. If these widgets do not exactly fit your requirements, you can always create your own and use the table below as a guide to configuring datasets for your widgets.
Conditions | Description |
Is Empty | Pulls data with a null value |
Is Not Empty | Pulls data with a value |
Is Blank | Pulls data with an empty string |
Is Not Blank | Pulls data with a non-empty string |
Equals | Pulls data that is equal to only one specific value |
Not Equals | Pulls data that is not equal to one specific value |
Contains | Pulls data where the field's value matches the input; functions like " ilike '%input%' " |
Not contains | Does not pull data where the field's value matches the input; functions like " not ilike '%input%' " |
Start With | Pulls data where the first part of the field's value matches the input; functions like " ilike 'input%' " |
End With | Pulls data where the last part of the field's value matches the input; functions like " ilike '%input' " |
IN | Pulls data that is equal to any value in the list; allows choosing a list of values |
Not IN | Pulls data that is not equal to any value in the list; allows choosing a list of values |
Match | Uses regular expression; functions similarly to "Contains" |
Not Match | Uses regular expression; functions similarly to "Not contains" |