Uable to create Query based Input Control using Jasper Studio

Jaspersoft Community 'Read-Only' as of July 8, 2022

Transition to New TIBCO Community Just Weeks Away

You can still search, review wiki content, and review discussions in read-only mode. Please email community@tibco.com with questions or issues requiring TIBCO review or response.

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.

reenaacharya35's picture
Joined: Mar 17 2016 - 1:32am
Last seen: 6 years 3 months ago

6 Answers:

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

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

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.

 

reenaacharya35's picture
Joined: Mar 17 2016 - 1:32am
Last seen: 6 years 3 months ago

 

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

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

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

reenaacharya35's picture
Joined: Mar 17 2016 - 1:32am
Last seen: 6 years 3 months ago

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

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

Thank You KKriplani

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

reenaacharya35's picture
Joined: Mar 17 2016 - 1:32am
Last seen: 6 years 3 months ago
Feedback
randomness