COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: g.congnos on 03 Dec 2013 05:36:38 AM

Title: Data Format [SOLVED]
Post by: g.congnos on 03 Dec 2013 05:36:38 AM
Hi,

I need to solve a problem about the crosstab node member format.

I set number format and the following option:
- No. of Decimal Places: 2
- Decimal Separator: ,
- Use Thousands Separator: Yes
- Thousands Separator: .

When I run the report it shows the data wihtout that format settings.

Any suggestions to solve this problem?

Thanks
Title: Re: Data Format
Post by: Satheesh on 09 Dec 2013 03:41:58 AM
Hi,


Is there any measures in Crosstab Member Node ..????





Title: Re: Data Format
Post by: navissar on 09 Dec 2013 04:57:59 AM
Hi g.cognos,
Data formatting applies to values. By default, a crosstab grid will show "member caption" in a member node.
Highlight the relevant member node, in properties, under source type, change the value from Member Caption to Data Item Value, and apply the data formatting.
Good luck!
Title: Re: Data Format
Post by: g.congnos on 10 Dec 2013 09:49:42 AM
Thanks Nimrod. Solved!!!  ;)