Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » How to Use Named Parameters in Dataset Query ?
How to Use Named Parameters in Dataset Query ? [message #1746756] Fri, 04 November 2016 09:39 Go to next message
Devpriyo Bhattacharya is currently offline Devpriyo BhattacharyaFriend
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
Re: How to Use Named Parameters in Dataset Query ? [message #1746891 is a reply to message #1746756] Mon, 07 November 2016 11:38 Go to previous message
Devpriyo Bhattacharya is currently offline Devpriyo BhattacharyaFriend
Messages: 12
Registered: October 2016
Junior Member
*** Thread Closed - This question has been answered ***

Readers: Please refer to the below link for the solution.
http://developer.actuate.com/community/forum/index.php?/topic/39747-how-to-use-named-parameters-in-dataset-query/

Best Regards
Previous Topic:Change ODA datasource parameter on runtime
Next Topic:Show Last Month Of Quarter!
Goto Forum:
  


Current Time: Tue Aug 20 01:34:44 GMT 2019

Powered by FUDForum. Page generated in 0.02714 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top