Dataset: CategoryQuotas
Dataset properties
| Property | Value |
| Data source name | AdventureWorks |
| Referenced data set | |
| Command type | Query |
Parameters
Fields
| Name | Source column | Data type | Caption | Value | Is calculated field |
| ID | ID | System.Int32 | |||
| Category | Category | System.String | |||
| Quota | Quota | System.Int32 | |||
| PercentDeviation | PercentDeviation | System.Int32 | |||
| QuotaF |
Filters
Query
SELECT 1 as ID, 'Accessories' as Category, 1000 as Quota, 25 as PercentDeviation UNION SELECT 2 as ID, 'Bikes' as Category, 70000 as Quota, 5 as PercentDeviation UNION SELECT 3 as ID, 'Clothing' as Category, 2500 as Quota, 20 as PercentDeviation UNION SELECT 4 as ID, 'Components' as Category, 20000 as Quota, 10 as PercentDeviation |
See also