Fixed rows displaying in a Crosstab when row total is zero

[rolphdog]

Hi everyone,
Is it possible to add static row members to a crosstab in Cognos 8 Report Studio so that when filters are changed the layout stays the same, displaying an empty row where there is no data returned?

cheers
r

 

[Beerhog]

There is no way to show a row that does not exist. I do have a suggestion. Instead of changing the filter, add the criteria to the data definition of the fact items.

If you want all rows for xyz with fact 'Amount', but are filtering for x then add the criteria in the data definition-

if(row = x) then ('Amount') else (0). y&z will now be 0

 

[misscognos]

only thing with that approach is that if you try to blank out the cell using a whitespace, it may not work. i have not been able to get that to wrok in the past.. so you might have to use a '-' or something.

 

[mfgf]

What kind of package are you reporting off?

If it's a Dimensional package (cube or DMR data source), then context-based filtering should leave the row and column headings intact and just change the numbers in the cells (leaving empty rows or columns where no measure values exist).

If you have a relational package (Query Subjects and Query Items), try using the 'Override Dimension Info' property within your query - you may be able to achieve something similar.

Regards,

MF.