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

[Jasperiousity]

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.

 

 

[kkriplani]

Hi,
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.

Regards,
KKriplani

[Sonamchawla0506]

Hi,

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