COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: tarunkrdas2013 on 18 Sep 2015 01:31:35 PM

Title: Want to section my Crosstab report based on Fiscal week
Post by: tarunkrdas2013 on 18 Sep 2015 01:31:35 PM
Hi,

My requiremnt is i want to section my Crosstab report based on Fiscal week ,i dragged Fiscal week num as Crosstab Node member and tried to section Fiscal week Num but problem is when i try to create section on Fiscal week report studio says below message .Please note i don't wish to use Fiscal week in a List report and then Master - details with Cross tab as its slowing down overall performance of report

"Sectioning can be done only onList column ,crosstab node member,chartnode member or Visualization mode"


i have attached the report output currently i am getting and also expected output in screenshot please suggest me how i can section my report based on Fiscal week Num using Crosstab report
Title: Re: Want to section my Crosstab report based on Fiscal week
Post by: tarunkrdas2013 on 18 Sep 2015 01:41:38 PM
Just to update on this the message changed and it says Unable to create sections because no query item is associated with this object

But Fiscal week num is a data item itself
Title: Re: Want to section my Crosstab report based on Fiscal week
Post by: tarunkrdas2013 on 18 Sep 2015 01:58:11 PM
Please reply this needs to be solved
Title: Re: Want to section my Crosstab report based on Fiscal week
Post by: bdbits on 18 Sep 2015 05:35:59 PM
You posted and expected an answer within the space of half an hour?

This is not a support site. People come here when they have time. No one is paid (including moderators, which is just fine) to wait for questions to pop up so they can answer them ASAP. It is just a place for like-minded people to help each other, if they so desire.

It looks like you had a text item selected (custom content in the cell?) when you tried to create the section. As the message indicates, you need to select a crosstab node member (assuming this is a crosstab).
Title: Re: Want to section my Crosstab report based on Fiscal week
Post by: tarunkrdas2013 on 24 Sep 2015 01:41:52 PM
Sincere Apologies i usually have patience but don't know why i got impatient this time,i truly agree