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

Help

Home

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

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

how to get value for parameter [message #1062287]

Fri, 07 June 2013 04:26

4040 4040

Messages: 78
Registered: February 2013

Member

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 167 times)
Attachment: lastmonth.rptdesign
(Size: 49.17KB, Downloaded 311 times)

[Updated on: Fri, 07 June 2013 04:31]

Report message to a moderator

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

Sun, 09 June 2013 00:37

Michael Williams

Messages: 1925
Registered: July 2009

Senior Member

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.

Michael

Developer Evangelist, Silanis

Report message to a moderator

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

Mon, 10 June 2013 04:57

4040 4040

Messages: 78
Registered: February 2013

Member

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...

Report message to a moderator