Skip to Content
0
Former Member
Mar 25, 2007 at 08:54 PM

To Display weeks in a selected period

17 Views

Guru's

Could some one tell me how to go about this requirement in step by step process and give me the code if possible.

Requirement is:

I need to generate a report where the client will enter the fiscal year/period in the prompt and the corresponding weeks for that period should be shown in the columns of the report.

Example: If the user enters 200702 (year/period) then the report columns should be filled with week1 week2 week3 week4 . If he enters 200703 then week1 week2 week3 week4 week5 should be populated in the column heading and the dollar amounts to the corresponding rows should be populated.

Sample Design:

Columns <b>SalesOrg, Division, <u>week1</u> ,<u>week2</u> ,<u>week3</u> ,<u>week4</u>, Revenue</b>

Rows

<b>char1</b>

<b>char2</b>

<b>char3</b>

The time characteristics available are Fiscal year variant, Fiscal year/period,calender year/month, calender year/week,fiscal year.

Their is a user defined week which has 01...52 weeks which are already loaded.The weeks should be displayed according to the period entered.