Hi,
Love the new graphs and reports in PHPRunner 4.0. My users have been very impressed with the ability to review data in attractive graphical form. And I have been impressed with how easy it is to set those graphs up. A bit of SQL work and there it is. <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=5126&image=1&table=forumtopics' class='bbc_emoticon' alt='B)' />
Now, a quick question...I'm probably missing the obvious way to do this....
I want to let users select the records to view based on criteria that they select. For example let's say they want to see a list (or graph) of sales that occur in the month of November 2006. Or May 2005. Or whatever month they had in mind.
I have edited the SQL Query (of a graph or table) at the appropriate step to select the current month. And had a seperate graph (or table) to look at the previous month. That works fine for these 2 months but it's not a practical solution for every month.
Any hints or tips would be greatly appreciated.
Giles.
