COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: Jennyw on 25 Jun 2014 09:23:12 AM

Title: How to display 2 section variables in every page of a report ---- solved!
Post by: Jennyw on 25 Jun 2014 09:23:12 AM
Hi all,
i have a report with 2 section variables: Gender(male female) and  groups(black & white), the main report body is a crosstab.
There are 4 pages, pages break down by
page1: male/black,
page2: male/white
page3: female/black,
page4: female/white.

I would like on the top of each page, display both Gender and group. Because Cognos uses Cascading style, page2 and page4 won't show Gender selection on the top of page, leaves just "groups:white" on the top :(.

this is how page1 looks like:

Gender: male
Groups: black

                  All Departments
                  All Divisions
                  All Subs
  YR     N     G1  G2 G3  G4   G5    G6   G7   G8    G9   G10
1998 6,038 0.0 0.0 0.4 33.1 63.7 69.5 71.0 71.7 72.0 72.3
1999 5,760 0.0 0.0 0.6 38.0 67.0 72.1 73.7 74.4 74.7 75.0
2000 6,000 0.0 0.0 0.7 40.9 67.6 72.6 74.0 74.5 74.8 75.0
2001 5,883 0.0 0.0 0.8 40.1 67.7 72.3 73.8 74.4 74.8 75.1
2002 6,015 0.0 0.0 1.0 43.5 69.5 73.5 74.7 75.3 75.7 76.1
2003 5,919 0.0 0.0 0.9 45.6 71.4 75.3 76.8 77.3 77.7 77.9
2004 6,391 0.0 0.0 1.0 44.9 70.0 75.2 76.5 77.0 77.4
2005 6,268 0.0 0.0 1.0 45.2 70.4 74.8 76.1 76.8
2006 6,031 0.0 0.0 0.9 49.2 73.1 77.2 78.5
2007 6,103 0.0 0.0 0.9 47.4 72.2 76.0
2008 5,895 0.0 0.0 1.1 50.0 73.4
2009 5,750 0.0 0.0 0.9 47.6
2010 5,691 0.0 0.0 1.2
2011 5,880 0.0 0.0
2012 5,985 0.0


I tried to change Gender variable's "Global classes", none of them works (the default class is "Section header cell").

am i on the wrong direction?

is there any way to achieve my goal?

Thanks in advance!

Jenny
Title: Re: How to display 2 section variables in every page of a report
Post by: Jennyw on 25 Jun 2014 09:51:31 AM
I solved the problem minutes ago :)

highlight the Gender
select List Header
then change the pagination
done!