Finding Alternate Rows in Report Studio 8

[pradev]

Hello,

How to find alternate rows in Summary Report. I cannot use mod(running-count(1),2) as running count can be used only in detail report.

Is there a way to find using RowNumber

Regards,
Prapagar

 

[mfgf]

Which product are you using? ReportNet Report Studio? Cognos 8 Report Studio? Impromptu? Please be a bit more specific about your exact problem, and we may be able to help.

Regards,

MF.

 

[mfgf]

Hmmm - perhaps I should have looked more closely at the subject of the post - sorry!

In Report Studio for Cognos 8, whatever descriptive item you are summarizing by can be used in your running count.

So for example, if your report is showing summaries for each Product Line, your calculation would be:

mod(running-count([Product Line]),2)

Regards,

MF.

 

[pradev]

Thanks MF.

I tried this one already. But this won't work in my case because I have dynamic sorting which is done using Conditional Blocks.

For Example, My report has following Columns,

Product Line, Production Cost, Margin.

Calculated Data Item(Rows) : mod(running-count([Product Line]),2)

Here user can select from Prompt page Production Cost or Margin to sort descending. This feature is done using Conditional blocks. So Calculated(Rows) differs while these columns sorted.

I tried RowNumber() in variables but I was not able to identify whether a number is Odd or Even.

Regards,
Prapagar