COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: srinu_anu2007 on 30 Aug 2012 05:21:51 AM

Title: Need to display 2 query items in single column
Post by: srinu_anu2007 on 30 Aug 2012 05:21:51 AM
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.
Title: Re: Need to display 2 query items in single column
Post by: HalfBloodPrince on 30 Aug 2012 05:24:44 AM
try this out
<Claim ID> +'-' +<Line>
Title: Re: Need to display 2 query items in single column
Post by: srinu_anu2007 on 30 Aug 2012 05:34:45 AM
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
Title: Re: Need to display 2 query items in single column
Post by: blom0344 on 30 Aug 2012 07:29:24 AM
Cast dataitem to a string (where needed)  and then use the || operator to concatenate strings to 1 new dataitem
Title: Re: Need to display 2 query items in single column
Post by: MFGF on 30 Aug 2012 11:23:59 AM
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.