How to link input control with report parameter?

0

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
Joined: Mar 17 2016 - 1:32am
Last seen: 3 years 7 months ago

4 Answers:

1

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
858
Joined: Sep 4 2015 - 2:18am
Last seen: 3 weeks 3 days ago
0

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
Joined: Mar 17 2016 - 1:32am
Last seen: 3 years 7 months ago
0

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
531
Joined: Nov 19 2014 - 11:02pm
Last seen: 3 years 4 months ago
0

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
Joined: Mar 17 2016 - 1:32am
Last seen: 3 years 7 months ago
Feedback