How to add Drop-Down list as Input Parameter in Jaspersoft Studio

0

I've created a reports where i want to input a Drop-Down parameter, it selected all records from a column as list,user can be click the Drop-Down to choose as you wanted, but I don’t how to add the parameter, some document said: some define should be made in JasperServer, but without the "Input Controls" in my JasperServer.  

 

anyone can tell me a way to create a drop down menu behavior inside the TIBCO Jaspersoft Studio-6.1.0.final

Please help.

Thank you in advance

Kelly

panlj2004's picture
Joined: Jul 20 2015 - 12:17am
Last seen: 4 years 3 months ago

5 Answers:

-2

Input Control is supported in JasperReports Server. It's possible to create Input Control with drop down list from Jaspersoft Studio.

Just go to "Repository" view and right click on  the report folder and "New" -> "Input Control". In the 2nd page, select "Select from List" in the type drop down list.

hozawa's picture
52392
Joined: Apr 24 2010 - 4:31pm
Last seen: 5 months 6 days ago
0

Hello hozawa,

I found the "input control" in JasperReports Server, and the simple drop-down is working.

now, I'm research the situation:

when choice 1st drop-down, the 2nd drop-down will seleced related recorde.

can you help me for this?

thanks a lot

Kelly

panlj2004's picture
Joined: Jul 20 2015 - 12:17am
Last seen: 4 years 3 months ago
0

If you want to create a tree looking input control that's not possible without modifiyng jasperserver source codes I guess. But if a sql query flling your filter,It's simple to create cascading input controls.

For example let's assume that we have two input control. First one is for "Product Class ID", and the second one is "product ID".

  -create two input control(Single Select Query) and two parameter. param1 (product_class_ID), param2 (product_ID)

  - First input control sql query is "select product_class_ID from product_table"

  - Second should be like " select product_ID from product_table where product_class_ID=$P{param1} "

By doing that we achive to get product ID based on product_class_ID selection.

That's what you want I guess :)

zh3ntil's picture
531
Joined: Nov 19 2014 - 11:02pm
Last seen: 3 years 4 months ago
0
H Mendoza's picture
351
Joined: Feb 20 2013 - 11:39am
Last seen: 5 months 5 days ago
0

The page Hugo mentioned or the JasperReports Server User Guide:

http://community.jaspersoft.com/documentation/jasperreports-server-user-...

hozawa's picture
52392
Joined: Apr 24 2010 - 4:31pm
Last seen: 5 months 6 days ago
Feedback