Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » how to get value for parameter
how to get value for parameter [message #1062287] Fri, 07 June 2013 04:26 Go to next message
4040 4040 is currently offline 4040 4040Friend
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 33 times)
  • Attachment: lastmonth.rptdesign
    (Size: 49.17KB, Downloaded 46 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 Go to previous messageGo to next message
Michael Williams is currently offline Michael WilliamsFriend
Messages: 1684
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

Add interactivity, scheduling, sharing, live Excel export, and JS integration to your BIRT app with the new, free BIRT server, BIRT iHub F-Type.
Re: how to get value for parameter [message #1062613 is a reply to message #1062556] Mon, 10 June 2013 04:57 Go to previous messageGo to next message
4040 4040 is currently offline 4040 4040Friend
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...
Re: how to get value for parameter [message #1062837 is a reply to message #1062613] Tue, 11 June 2013 04:19 Go to previous messageGo to next message
Michael Williams is currently offline Michael WilliamsFriend
Messages: 1684
Registered: July 2009
Senior Member

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

BIRT Exchange Forum - Comparison in Parameter


Michael

Add interactivity, scheduling, sharing, live Excel export, and JS integration to your BIRT app with the new, free BIRT server, BIRT iHub F-Type.
Re: how to get value for parameter [message #1063611 is a reply to message #1062837] Thu, 13 June 2013 13:55 Go to previous messageGo to next message
4040 4040 is currently offline 4040 4040Friend
Messages: 78
Registered: February 2013
Member
thank u for wonderful post....................
Re: how to get value for parameter [message #1064388 is a reply to message #1063611] Wed, 19 June 2013 04:56 Go to previous message
Michael Williams is currently offline Michael WilliamsFriend
Messages: 1684
Registered: July 2009
Senior Member

You're very welcome!

Michael

Add interactivity, scheduling, sharing, live Excel export, and JS integration to your BIRT app with the new, free BIRT server, BIRT iHub F-Type.
Previous Topic:empty space between border top and text
Next Topic:Parameterized Query - Problem
Goto Forum:
  


Current Time: Thu Dec 18 14:41:21 GMT 2014

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

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