Print Page - Cross tab report with Week end date as columns

Title: Cross tab report with Week end date as columns
Post by: sharu_bs on 05 Sep 2006 08:02:11 AM

Hi all,

I am new to report net. I am trying to write following report and Donno the solution. So need help on same.

Report details
===========
Prompt page:
2 prompts shd be displayed.
End Date : need to default to nearest saturday for today. --> How to do it????
no of weeks: 1-5

Report page:
Week 1 week 2 week 3 week 4 week 5
(saturday date)
============================================================
Alerts count, Avg calc

How will I get week as columns??? and How will I count Alerts for whole week???

Please help !

sharu

Title: Re: Cross tab report with Week end date as columns
Post by: Blue on 05 Sep 2006 01:12:13 PM

I think you will need to do this in the database, perhaps with a view. Create a new fact data source in FM once you get the data sorted out (aggregated) in a view or stored procedure.

Title: Re: Cross tab report with Week end date as columns
Post by: sharu_bs on 05 Sep 2006 11:33:10 PM

Hi,

I am new to this technology so can u give me in steps what all I need to do?

COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => Report Studio => Topic started by: sharu_bs on 05 Sep 2006 08:02:11 AM