Input controls

[jkalten]

Hi!

When defining an input control as a single select query and forcing the user to 
select values from the drop-down list, I also want him to know, what the content 
of these columns are. f.eg. in the drop down list there are data like:

Bühler 1400          ID12345
Idra 3412               BUI1390
...

For a user, who has no experience in the content of the table, it would be quite
helpful to have the column header displayed, so that the drop down list would 
for example appear as the following:

decription              name // <-- bold, can't be selected by the user
Bühler 1400          ID12345
Idra 3412               BUI1390
...

Is this somehow possible? (except to write this in the Label of the input control)
Thanks in advance!
Julia

 

 

[jkalten]

And is it also possible (regarding to the question above) not only to display the value column in the report, but also to display the visible query columns being set?

f.eg.:

 1)create input control "Machines" --> single select query, value column: "id", 
 + visible query columns: "name", "description"
 2) name + description are also Input Controls in the report
 3) If the user is asked to select a value for the Input-control  "Machines" (see also step 1), can this selection automatically affect the Input-controls of step 2). Moreover, these Inputcontrols shouldn't be changed by the user. 

The aim is, also to be able to use id and description in the report. Is this somehow possible?

 

Thanks! Julia
 

Post Edited by jkalten at 07/30/2009 10:39

[leeyuiwah]

I think you can only return one value column, but this column can be a concatenation of multiple columns, and it does not have to be the same as the "visible" column. 

 

So, you may do something like

 

select

  concat(id, "|", name, "|" , description) value_column,

  name,

  description

from ...

 

In your input control, define "value_column" to be the "value" column, and "name" and "description" to be your "visible" column

 

When you get the return value in your prompt, you can use scriptlet to parse the string (delimited by "|") using something like java.util.StringTokenizer and get back id, name, description.

 

 

[yashdeep]

hi!

u can concate the multiple colum in Query and give some name ,then use this as Visible Column.....

 

Thanks & Regards,

Yash