Hello,
On my options tab I have a date filter option (ex. 010111..123111). I would like to have two tables on my report, one displays data using the date filter in options and the other displays the same period but from last year. What I want to do is just use the existing date filter and add a function that used last years "year" to the second tables query string? If this makes any sense to anyone but me, is this possible? If so, can you point me in the right direction?
thanks in advance for any assistance!
K
Date
Votes
1 comment
-
Jet Reports Historic Posts Hi Kofseattle,
When I need to create a report that compares years I always have the user put in a start date and an end date rather than the date range. It makes things a little easier for you. By having the dates in individual cells you can easily use Excel to manipulate the dates using the Date(), Year(), Month(), Day() functions. Here is a link to another posting in the Excel Tips and Tricks section that I found that might be useful to you….
http://community.jetreports.com/viewtopic.php?f=23&t=453
I hope this helps!
Please sign in to leave a comment.