If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Need to display 2 query items in single column

Started by srinu_anu2007, 30 Aug 2012 05:21:51 AM

Previous topic - Next topic

srinu_anu2007

Hi

I have to display 2 query items in  a single query item see the below example.

Claim Line ID- these are 2 query item need to display in single query item and line id is row count i think
<Claim ID>-<Line>-this is list column body
100270000100-003- this is sample date.

HalfBloodPrince


srinu_anu2007

Quote from: HalfBloodPrince on 30 Aug 2012 05:24:44 AM
try this out
<Claim ID> +'-' +<Line>

it was showing error- <Claim ID> +'-' +<Line> has loop

blom0344

Cast dataitem to a string (where needed)  and then use the || operator to concatenate strings to 1 new dataitem

MFGF

Is this in a list report? If so, try unlocking the structure of the report and dragging your second item into the list column body of the first. You can then add a text item to give you the '-' separator.

Regards,

MF.
Meep!