If you are unable to create a new account, please email support@bspsoftware.com

 

How to display 2 section variables in every page of a report ---- solved!

Started by Jennyw, 25 Jun 2014 09:23:12 AM

Previous topic - Next topic

Jennyw

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

Jennyw

I solved the problem minutes ago :)

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