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

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Conditionally Render crosstab row

Started by actcognosuser, 04 May 2010 01:14:25 PM

Previous topic - Next topic

actcognosuser

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.

actcognosuser

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


MFGF

You would need to add summaries for all countries, then conditionally hide the summaries for countries with one region.

MF.
Meep!

actcognosuser

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.

MFGF

When defining your conditional rendering, did you select just the summary row header node, or have you selected the associated fact cells too?

MF.
Meep!

actcognosuser

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