Want to show dropdown using jrxml

[JasperNewTester]

Hi Friends,

I am new to jasper . My project used jasper to create  an excel template that has only column names (eg : Name , Age , Department , Location) which uses jrxml for fontings and alignment. [basically we used the <StaticText > for showing the column names]

User can downlaod that template ( that is generated by japser using my jrxml) by clicking on the link and they can enter the values they want.

Now inorder to avoid user enter the details manually by entering values , I would like to give dropdowns in the template with some hardcoded values .

For example for the field 'Location' , I can set values like 'Texas' , 'California', 'FortWorth' etc . I am not querying from DB for these values , I just want to hard code these in .jrxml and

in the downloaded excel , I want a dropdown with the above values so that user can select instead of typing themselves.

 

Is there any way to put this in .jrxml . If that is not possible then give the code that can render these in a dropdown in excel.

Plese let me know if more details are required

 

 

[JasperNewTester]

Please help me on this