Based on Date prompt we need total values...its urgent..

[udaykamble]

Hi,

I m facing with one issue, Please help on this.

we have January, Feb,mar..Upto December. these are the columns.

our requirement is..we have Resource column and Jan, feb, ...upto December columns.

Now we have to calculate total hours worked per resource. here we have to create one query calculation column,and we have to calculate based on From Date and To Date.

here we need one date prompt.

Please help on this. Its urgent issue.

Advance Thanks for you
... I am waiting for your reply...

 

[blom0344]

Why not use 2 date prompts and feed the dataquery with a filter based on the date prompt parameters?

A from and a to date seems a bit difficult with just one prompt..

Ties Blom