Eclipse Community Forums: BIRT » how to get value for parameter

Home » Archived » BIRT » how to get value for parameter

how to get value for parameter [message #1062287]

Fri, 07 June 2013 00:26

Eclipse User

BIRT my question is when i select parameter in list box it have to compare a value in chart it have to produce a result...

for example if i am having a one list box i.e select month: jan 2013,feb 2013,mar 2013 and then another list box Period:Last month,Last year

when i select a Jan 2013 from one list box and then i wil select Last Month or Last year in another list box so result will be Jan 2013 total value and DEC 2012 total value for Last Month likewise then i will select Last Year Jan 2013 total value and Jan 2012 total value have to display....

i have attached a sample report and image for u r reference..

thank's in advance

Attachment: re.png
(Size: 14.10KB, Downloaded 198 times)
Attachment: lastmonth.rptdesign
(Size: 49.17KB, Downloaded 335 times)

[Updated on: Fri, 07 June 2013 00:31] by Moderator

Re: how to get value for parameter [message #1062556 is a reply to message #1062287]

Sat, 08 June 2013 20:37

Eclipse User

There are BirtDateTime functions available in the expression builder and script methods that will allow you to find the proper month based on the two parameter values. Then, you'd just need to adjust your query to limit your data.

Re: how to get value for parameter [message #1062613 is a reply to message #1062556]

Mon, 10 June 2013 00:57

Eclipse User

thank u very much for reply i have tried this way ...but i cant able to get appropriate value of parameter

so can u able to produce a sample db example for this...its helpful for me ...

thank in advance...

Re: how to get value for parameter [message #1062837 is a reply to message #1062613]

Tue, 11 June 2013 00:19

Eclipse User

I posted a sample in your thread over on BIRT Exchange:

BIRT Exchange Forum - Comparison in Parameter

Re: how to get value for parameter [message #1063611 is a reply to message #1062837]

Thu, 13 June 2013 09:55

Eclipse User

thank u for wonderful post....................

Re: how to get value for parameter [message #1064388 is a reply to message #1063611]

Wed, 19 June 2013 00:56

Eclipse User

You're very welcome!