How to access database in jasperreports server without manually keying in parameter data


I published my reports from Jasper Studio to Jasper Server. They are working perfectly but I need to input all the parameters manually. How can I access the database in such a way that I can select data possibly through a dropdown list or something instead of manually keying in the data? I am using Windows SQL Server for my database.



Jasperiousity's picture
Joined: Nov 10 2015 - 6:32am
Last seen: 4 years 2 months ago

2 Answers:


What you need is to implement input controls (ICs). ICs pick the value from the jasperserver user and pass it into the parameters in the query. ICs give you the option to select values from a drop down etc.


kkriplani's picture
Joined: Sep 4 2015 - 2:18am
Last seen: 1 year 11 months ago


I worked with most flexible, cost-effective and widely-deployed business intelligence Software for better decision making and reporting Jaspersoft. One of my friend suggested me a good resource in which includes JasperServer Architecture, Introduction to Report Creation using JasperSoft iReport, JsperSoft Sudio, Deploying reports on JasperServer, Multi tenancy Architecture &Olap-Mdx, Cube. This resource further covers OLap basics including Creating and Deploying Cubes, MDX, Report and Dashboard Generation using Cube and Performance tuning of reports and JasperServer.

I learnt a lot from there and I am sure it will definitely helps you --  Jaspersoft Video Tutorial

Sonamchawla0506's picture
Joined: Dec 4 2015 - 11:38pm
Last seen: 5 years 8 months ago