Skip to Content
0
Former Member
Jun 08, 2009 at 04:59 AM

Issue with prompts..

27 Views

Hello Experts..

I have a report which displays billing backlog and stock information according to the Weeks given in selection criteria of the report i.e if running this report in quarter 2 we have to give week 14 to week 26 in the selection criteria.

What we want now is when ever the report is executed it should determine the current quarter as per the current date and automatically it should display data for the weeks in that given quarter.

So we want that let say if the run this report today, it should find out current quarter i.e. Quarter 2 and instead of supplying calweek in selc. criteria it should automatically assign calweek from 200914 to 200926 similarly if the run the report in Q3 then it should automatically assign calweek from week 27 to week 39.

Please suggest something on this issue. !

Regards

Priyanka