I am creating a report with fields like (year, month revenue, previous month revenue and variance between those 2 months). i have a date prompt in my repot. i need to select the month and previous month from that prompt dynamically.
I know how to get the month from the date prompt, but how can i get the previous month and corresponding revenue value.
any suggestions please send.
Edited by: shahin13 on Jul 15, 2011 12:18 PM