How to link input control with report parameter?

Posted on March 22, 2016 at 2:00am

Hi,

I have created report with following query:

select * from instance where (CUSTNAME = $P{customer})

I have create query based input control of type "Single Select Query (Radio)" with name "customer". But still I am not able to link input control with parameter.

Any suggestion on this issue will be very helpful.

Thank You!

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

4 Answers:

Posted on March 22, 2016 at 3:43am

Hi,
The name of the IC doesnt matter but the make sure the id of the IC is the same as the name of the parameter.

Regards,
KKriplani

kkriplani's picture
kkriplani
5042
Joined: Sep 4 2015 - 2:18am
Last seen: 11 months 1 week ago
Posted on March 22, 2016 at 10:06pm

Hi,

I have kept IC id and report query parameter name same.

Report query : select * from instance where (CUSTNAME = $P{customer})

Input Control details as follows:

 

Can anyone suggest where I am missing?

Thank You

reenaacharya35's picture
reenaacharya35
426
Joined: Mar 17 2016 - 1:32am
Last seen: 6 years 11 months ago
Posted on March 23, 2016 at 10:26am

If you use different dataset from main dataset to load data to your report, you have to pass the parameter to the sub dataset also. Probably that's the problem.

zh3ntil's picture
zh3ntil
3207
Joined: Nov 19 2014 - 11:02pm
Last seen: 6 years 8 months ago
Posted on March 27, 2016 at 11:44pm

Hi,

Is it required to use sub dataset, as this is a simple report with single select query based input control.

All I want to acheive is, display report based on the value that is selected by user.

 

Any suggestion on this will be very helpful.

Thank You!

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