Uable to create Query based Input Control using Jasper Studio

[reenaacharya35]

Hi,

I am creating Jasper reports using Jasper Studio. I tried creating query based input control but I am not able to proceed further on it.

 

Any help on this issue will be very helpful.

[kkriplani]

Hi,
once at this position, follow the below listed steps;
1) Click on the 3 dots besides the "query" box. Select sql in the drop down and input the query.
2) Once the query is given, come back and mention the value and visible columns.
3) Don't forget to get the datasource.

Regards,
KKriplani

[reenaacharya35]

Hi,

I selected sql and also typed the query. Also selected the appropriate datasource.

But as you can see the screenshot(above), NEXT or Finish button is not highlighted.

Once the query is given it doesn't show the option for mentioning the value and visible columns.

I don't know where I am missing.

 

[kkriplani]

 

Hi,
From the first screenshot you shared, the value and visible columns tab is seen.
Also, i see that the finish tab is highlighted in the second screenshot.

I would like to point out that in your query you have only one column, how do you intend to define two columns in the value and visible tab?!

Regards,
KKriplani

[reenaacharya35]

Hi,

I followed these steps for creating query based  input controls.

After completing these steps,"Next" and "Finish" button are disabled.

Any suggestion for this issue.

Thank You

[kkriplani]

That means some data is incomplete.
probably the data at value and visible columns is incomplete.

example:
SQL>>  select id,name from tb_details where id = $P{c_id}

visible column>> name
value>> id

Build from the example,
regards,
KKriplani

[reenaacharya35]

Thank You KKriplani

The problem resolved. The information specified in "Value and Visible column" was not complete.