Input controls

[shubhamprasad312]

How to configure input controls in jasperserver ?

I created an input control but the data is not changing accordingly when i am running the report .

Can anyone please help me on this ?

[miwagada]

pass input control parameter name in the query you are using 

 like : 

select id, name from customers where id = $P{id_name}  Or 

select id, name from customers where id in $P!{id_name} 

where id_name is the name of input control created in jasper server.

[shubhamprasad312]

Hi,

I passed the input control parameter name in the query

SELECT employee_name FROM demo WHERE employee_name=$P{NAME}

But still its not working.

Its giving me an error: 

                     There was an error on the server.

                     Try again or contact site administrators. (Error UID: f73ad56c-b5c8-472d-943f-ac78bdfd4daa)

 

 

 

 

[mca.amitrami]

- Parameter name should be same on Report and Server and Map that parameter report level on server,

 

Thanks,

Amit

[shubhamprasad312]

Hi

When i am passing the parameter name in query input control its giving me error.    

                     There was an error on the server.

                     Try again or contact site administrators. (Error UID: f73ad56c-b5c8-472d-943f-ac78bdfd4daa)

And the name of the parameter is same in both ,Studio as well as Server.

Can Anyone please help me with this ?

[joseng62]

The error you are sharing, indicates you are not aware of the log file you can use to pin point ussues. 
When you get Error in JasperServer, always go check you jasperserver.log file. 
You will have a more detailed stack trace. 
You can even enable more logging on jasperserver and set to debug level, if needed. 
In server as admin, go to Manage, then server settings then log settings, there you can add more loggers and log level. 

Log file will be located at
Apache_installed_pathwebappsjasperserverWEB-INFlogsjasperserver.log

So go check error there and get back to us.