I am looking to develop a button that when clicked runs a script that creates a report.
I have data that was inputted monthly (e.g. Jan 2009, Feb 2009...., Jan 2010, Feb 2010...etc) into the database that shows the number of a certain part that was used in that month at a certain site.
I want to be able to click a button to generate a report, i will then be prompted to enter the criteria that i want to be used to create my graph (e.g. the month January 2009) which will be used to create my graph using a graph design i have earlier created (this graph will show part usage quantlty on the y axis and then date used along the x axis possibly.
Can anyone help me on how to do this??
Any help would be greatly appreciated.