Eclipse Community Forums: BIRT » How to Use Named Parameters in Dataset Query ?

Help

Home

Home » Archived » BIRT » How to Use Named Parameters in Dataset Query ?

Show: Today's Messages :: Show Polls :: Message Navigator

How to Use Named Parameters in Dataset Query ? [message #1746756]

Fri, 04 November 2016 09:39

Devpriyo Bhattacharya

Messages: 12
Registered: October 2016

Junior Member

Hi,

I want to create a dataset query OR any other query item, qryPeriod like the following:

If param='Year' Then (database.schema.table.YEAR)
Else if param='Quarter' Then (database.schema.table.QUARTER)
Else if param='Month' Then (database.schema.table.MONTH)
End

Note:
1) My database is SQLSERVER and the fields YEAR, QUARTER and MONTH have different values.
2) Where param is a report parameter having its static values - Year, Quarter and Month.

I want to now place qryPeriod in crosstab row/columns field. When I run the report, when I enter param = Year, the crosstab measures should get sliced on Year. If I select param = Quarter, then my crosstab measures should get sliced on Quarter.

Any suggestions for this?

Best Regards

Report message to a moderator