Display hierarchy in the jasper parameters

[usha.vellala]

Hey, 

I created a single select query input control on the jasper server. Currently I can select a date from the drop down which is of the format (yyyy-mm-dd), but I would like to know if there is a way where I can set the date hierarchy yyyy-->mm-->date. To be specific, when I click on the drop down, first I should see the year and drill through the month and then date. Can any one please let me know if we can achieve this in jasper ? 

I am using ireport designer 5.5.0, Apache Tomcat 7.0.42 Server 

Any help is greatly appreciated

Thanks,

[ernestoo]

You could do cascading text dropdowns where you are doing:

IC_YEAR: SELECT DISTINCT(YEAR) FROM TIME

IC_MONTH: SELECT DISTINCT(MONTH) FROM TIME WHERE YEAR = $P{YEAR}

IC_DAY: SELECT DISTINCT(DAY) FROM TIME WHERE MONTH = $P{IC_MONTH}

[usha.vellala]

Hey thanks for your response. The above approach leads to 3 input controls,is there a way I can get the achieve this within one input control. For Eg - First when I click on the drop down, it should show all the years like 2013,2014 etc. When I click on 2013, it should show all the Months under 2013 and when I click on Month, it should show the dates under the month. Is there a way we can get all these in one input control as a hierarchy. Please let me know.

 

Thanks in advance

[ernestoo]

not to my knowledge