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

Posted on April 26, 2016 at 5:23am
1

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
Jasperiousity
17
Joined: Nov 10 2015 - 6:32am
Last seen: 2 years 3 days ago

2 Answers:

0
Posted on April 26, 2016 at 5:58am

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

kkriplani's picture
kkriplani
858
Joined: Sep 4 2015 - 2:18am
Last seen: 3 weeks 5 days ago
0
Posted on April 27, 2016 at 6:47am

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

Sonamchawla0506's picture
Sonamchawla0506
13
Joined: Dec 4 2015 - 11:38pm
Last seen: 3 years 6 months ago
Feedback
randomness