Print Page - Hide Crosstab node member

Title: Hide Crosstab node member
Post by: EArumugam on 12 Apr 2011 01:42:35 AM

Hi all,

how to hide the crosstab node member in the report.

for ex.
year
revenue sales
prodline prodtype prodname
total prodname
total prodtype
totalprodline

in the above example i want hide prod type row, but i want to diaply the prodtype total row in the report. i tried to make it as boxtype but no luck, revenue and sales column not aligned properly.

is there any othere way to hide.

thanks
eas

Title: Re: Hide Crosstab node member
Post by: PRIT AMRIT on 12 Apr 2011 02:50:07 AM

Select 'Product Line' Column, Property--> Source Type--> Text ( Default it would be 'Member Caption')

Again you got to do a bit of formatting to hide the borders to look nice.

Hope it helps?

Thanks
Prit

Title: Re: Hide Crosstab node member
Post by: PRIT AMRIT on 12 Apr 2011 02:52:19 AM

QuoteSelect 'Product Line' Column, Property--> Source Type--> Text ( Default it would be 'Member Caption')

Sorry, select 'Product Type'

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: EArumugam on 12 Apr 2011 01:42:35 AM