Utilization Report

[Former Member]

Hi all,

I need to prepare a utilization report(in WebDynpro) which accepts two dates(start date and end date) as input and gives the output as follows:

ex: St.date : 10/04/2006 End Date: 30/05/2006

April May

10 11 12 13.....30 1 2 3 4 5......31

name 1 progress bar(with color red to indicate free name 2 days and green to indicate busy days)

name 3

.

.

.

It would be of great help if someone can throw some light as to how to proceed

[Former Member]

Hi,

So basically you will input the date range and the partner. This will take data from the database and display it in a table with busy dates as bar with red colour and free days as bar with green colour. If this is correct then it is easy.

1. First create your own node with the attributes like date, barColour and details etc..

2. Create a table for the following attributes. For the busy or free dates you can keep progressive bar as the item and then bind it to the attribute barColour.

Keep the <b>barColour</b> attribute of type -->

<b>com.sap.ide.webdynpro.uielementdefinitions.ProgressIndicatorBarColor</b>

3. For each record from the database see if the partner is free or not and accordingly set the colour of the bar.

<b>Positive</b> gives <b>green</b> colour

<b>Critical</b> gives <b>red</b> colour.

Keep <b>percentValue</b> as <b>100%</b> and <b>showValue</b> as <b>false</b>

I think this will do. Feel free to ask if there is any other doubt.

Regards,

Mahesh K.

[Former Member]

Hi,

Thanks for the reply.

Can this be done using Interative forms instead of a table? If NO, please let me know how i can get the individual days of the specified period in the table as column header.

Regards,

Naveen

[Former Member]

Hi,

Can you explain your requirement in detail. From where is the data in the report taken etc...

regards,

Mahesh K.

[Former Member]

Hi Mahesh,

The data is being retrieved from the master table in the database. It would be helpful if you could let me know how to go about it. The actual requirement is : upon specifying the date range and selecting a partner, the report should display the asssociated resources and their schedule for the specified period. This schedule should be represented as a <u>bar</u> wherein "green" colour specifies the busy dates and "red" indicates the free dates.

Thanks in advance.

Regards,

Naveen