Uable to create Query based Input Control using Jasper Studio

Posted on March 21, 2016 at 3:20am

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.

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

6 Answers:

Posted on March 21, 2016 at 4:30am

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
kkriplani
3192
Joined: Sep 4 2015 - 2:18am
Last seen: 2 months 1 week ago
Posted on March 21, 2016 at 8:48pm

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
reenaacharya35
314
Joined: Mar 17 2016 - 1:32am
Last seen: 6 years 3 months ago
Posted on March 21, 2016 at 10:32pm

 

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
kkriplani
3192
Joined: Sep 4 2015 - 2:18am
Last seen: 2 months 1 week ago
Posted on March 21, 2016 at 11:15pm

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
reenaacharya35
314
Joined: Mar 17 2016 - 1:32am
Last seen: 6 years 3 months ago
Posted on March 22, 2016 at 12:23am

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
kkriplani
3192
Joined: Sep 4 2015 - 2:18am
Last seen: 2 months 1 week ago
Posted on March 22, 2016 at 1:52am

Thank You KKriplani

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

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