Facing problems creating Input-Control Parameters

[sabyasachi.mallik1]

Hi Folks,

I am facing problem creating parameters. I need to create one date Input-control which will be in relation like (from date - to date. )

I dont know how to create it's parameter from Jaspersoft studio. I mean for single select query or multi select quey we use $X(IN,Field,Parameter).

So for this kind of input control(from date - to date) what kind of parameters we should use. I am in a big problem please help me out.

 

Thanks in advance......

 

[mbmorgan]

Hi, a few suggestions:

"I need to create one date Input-control which will be in relation like (from date - to date. )" - This sounds like you actually need two date-based input controls, Start_Date and End_Date for example.

In Jaspersoft Studio, make sure the date parameter is of class java.sql.Date.

In JR Server, when you set up and edit the input control, on the "Create Input Control" page, select "Single Value" as the type (make it also Mandatory and Visible if it's necessary to run the report). Then, on the "Set the Datatype Kind and Properties Page", select "Date" as the type. You can enter optional max and min values there.

Your report query should look something like:

"select * from table

where date_column >= $P{Start_Date} and date_column <= $P{End_Date}..."

I am a new Jasper developer and I had this same problem recently. This solution is what worked for me.

Good Luck,

M.B.Morgan

[sabyasachi.mallik1]

Hi Morgan,

 

Thanks for the response and the input-controls are working perfectly.

I have done it with your help, but just one problem when the chart executes in the server it comes as an empty report.

After chossing the data from the control the chart poopulates, is there any way to give the controls a default value.

Please help me with this and it will be perfect.

 

[mbmorgan]

Hi Mallik, I'm not sure I understand your question.

 

"...but just one problem when the chart executes in the server it comes as an empty report. After chossing the data from the control the chart poopulates"

 

- This is by design from when you made the input controls mandatory - the report will not populate in the JR Server until the user actually selects something in the controls for it to work with.

 

Please elaborate on what exactly you want to accomplish.

[sabyasachi.mallik1]

I dont want to make the date control as mandatary.I want to have a chart with default dates and we can change our chart by different selection in the date filters. Now I need to know how to set default values for parametrs. So that when the chart gets executed the filters would have default dates in them.

 

Thanks for the help and support Morgan.