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..
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.
Add interactivity, scheduling, sharing, live Excel export, and JS integration to your BIRT app with the new, free BIRT server, BIRT iHub F-Type.