What is the difference between Simple, Advanced and Parameter data sets?
One answer
SIMPLE Data Set lets you fetch data from a particular table. You can select which columns you want selected and which columns you want to filter on. The columns you filter on will be exposed as data set parameters. So with the simple data set, you can only express filters of the form: COL1 = val1 and COL2 = val2....
val1 and val2 can be hardcoded in the data set parameter page or can be bound to a report parameter.
ADVANCED Data Set lets you fetch data from a particular table. You can select which columns you want selected. You can also type in a filter that can be something like (e.g.)
(COL1 = 'bla') or (COL2 < 2) and (COL3 like param_1)....
The syntax is SQL like. param_1 is a data set parameter.
PARAMETER Data Set lets you fetch data from a particular table. You can select which columns you want selected but the filtering is limited to the columns you select. This data set also returns distinct rows. This data set type is usually used to feed values to the report parameters that get listed in the UI so users can pick the values from the list.
val1 and val2 can be hardcoded in the data set parameter page or can be bound to a report parameter.
ADVANCED Data Set lets you fetch data from a particular table. You can select which columns you want selected. You can also type in a filter that can be something like (e.g.)
(COL1 = 'bla') or (COL2 < 2) and (COL3 like param_1)....
The syntax is SQL like. param_1 is a data set parameter.
PARAMETER Data Set lets you fetch data from a particular table. You can select which columns you want selected but the filtering is limited to the columns you select. This data set also returns distinct rows. This data set type is usually used to feed values to the report parameters that get listed in the UI so users can pick the values from the list.