I've an inputcontrol with Value Column:Value1. In visible Query Columns I've added Value1 and Value2. In the Report title I've added $P{[inputcontrol]} to the band and obviously Value1 is returned when I run the report. But I need Value2, how can I do this?
Thnx Remco
1 Answer:
$P{[inputcontrol]} shows nothing else than the value, which is passed from the executing environment to your report. For normal, you use this value i.e. as a unique id for a query or sth. else.
so, if you need value2 in your report, just create the input control with value column: value2 and visible columns whatever you like.
if you need both values in your report, either create two input controls, or select value1 and value2 as a concatenated column (seperated by a uniqe character or sth. similar), and strip them in your report (you can do this with 3 parameters, or String-split, or sth similar)
Cheers, Thomas
Thnx, I succesfully used your first solution.
Remco