two columns in value prompt

[curious]

Is it possible to display two columns in a value prompt. For example Company name and revenue. Second column is just extra information.

[MFGF]

Hi,

Yes, this is fairly straightforward to do. Your Value Prompt is populated by a query in your report. Go to the query explorer and find this query. Add the Revenue value into the query as a new data item. Then add a new Data Item from the toolbox and set it's expression as [Company] + ' ' + cast([Revenue],char)
Finally, set this data item as the Display Value in the properties of your prompt.

Regards,

MF.

[curious]

@MFGF.
Thank you for your answer. I allready thought this would be a possible solution. You get a very bad layout however when Company name and revenue don't have an equal length. A struggle with the length of a  string etc is possible, but I hope for something easier.