It's all about the answers!

Ask a question

What is the difference between Simple, Advanced and Parameter data sets?


0
1
ankur sharma (66212228) | asked Jul 18 '12, 2:40 p.m.
JAZZ DEVELOPER
The Jazz Data Source for custom BIRT reports offers Simple, Advanced and Parameter data sets. What is the difference between them? when to use which?

One answer



permanent link
ankur sharma (66212228) | answered Jul 18 '12, 2:41 p.m.
JAZZ DEVELOPER
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.

Your answer


Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.