Skip to Content
0
Former Member
Sep 10, 2007 at 01:22 PM

challenging report requirement

18 Views

Hi all,

I am want a report such that

1. if user does not enter months he has to get last 24 months data(from current month)

eg1.

-


Sales

currentmonth 300

currentmonth-1 400

.............................

currentmonth-20 500

2. if user enter months he has to get required months data(from current month)

eg1.assume that user entered the interval of last two months.

-


Sales

currentmonth 300

currentmonth-1 400.

friends please me in desinging this query.

It's very urgent,waiting for responses.

Thanks,

James.