Cross tab report with Week end date as columns

[sharu_bs]

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

[Blue]

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.

[sharu_bs]

Hi,

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