COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: actcognosuser on 04 May 2010 01:14:25 PM

Title: Conditionally Render crosstab row
Post by: actcognosuser on 04 May 2010 01:14:25 PM
Hi All,
         Is it possible to render a summary row in a crosstab?I have a nested crosstab with country and sport eligible regions.IF there are more than 2 eligible regions then i need to display a summary for player scores for that country by region.
Title: Re: Conditionally Render crosstab row
Post by: actcognosuser on 04 May 2010 01:38:03 PM
This is how the summary row should be rendered.Display Summary only when there s more tha none region associated with a country

COUNTRY        REGION         Player 1       Player 2          Player3
United States   East                5                 4                   12
UK                  Zone1               3                 6                     8
                  Zone 2            2                 1                     3
                  Zone 3            5                 2                     1
                SUMMARY         10                 9                     12
Belgium           wing1   5       0                2                    9
Argentina           Region1       0                3                      7

Title: Re: Conditionally Render crosstab row
Post by: MFGF on 05 May 2010 02:51:34 AM
You would need to add summaries for all countries, then conditionally hide the summaries for countries with one region.

MF.
Title: Re: Conditionally Render crosstab row
Post by: actcognosuser on 05 May 2010 07:36:35 AM
Hi MFGF,

I did add the summary row for the region.But my render variable does not seem to work.

I created a render variable with count>2.But only the summary label  disappears.But not the data itself.I see one blank summary row for every region.even for the ones with count less than 2.
Title: Re: Conditionally Render crosstab row
Post by: MFGF on 05 May 2010 07:47:57 AM
When defining your conditional rendering, did you select just the summary row header node, or have you selected the associated fact cells too?

MF.
Title: Re: Conditionally Render crosstab row
Post by: actcognosuser on 05 May 2010 07:59:50 AM
Hi MFGF,

My crosstab is nested.

it has

     Country   region                    day1  day 2    day 3    day 4
    US           east    lap1 score     
                            lap2 score
                            lap3 score
                 Summary

If i try to apply it to a particular fact cell.it is selecting all the fact cells in the crossatab.I applied conditional rendering to summary row.

Is there any way to paste an image?Do i need to specify image location between the html tags?It will give
a better picture