COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: kgcognos on 30 Jan 2014 10:59:45 AM

Title: Changin Cross tab column headings using Data Item
Post by: kgcognos on 30 Jan 2014 10:59:45 AM
I want my crosstab column heading to show either 2014 or 2013. However, I get  -- as heading when I run it.
Just to make it simple right now my data item is set to '2014'. No formula involve. It still give me --
How can I resolve this?
Thank you in advance. 
Title: Re: Changin Cross tab column headings using Data Item
Post by: udaychow99 on 31 Jan 2014 12:28:37 AM
Hi,

Does your data item contains 2013,2014 as values?.

for ex: I have a query subject sales which contains sale_id,cust_id,prod_id,sale_date,amount_sold
as query items.When we use any query item in the report,it will be called data item.
i drag sale_date query itrem into the columns part of crosstbareport.
when i run the report, it will display all the dates present in sale_date data item.

So what is your data item and what are values presnt in it.Could you brief about it so that we can have clear undersatnding of the problem and possibly we will get solution.:)