Our current application has a reporting tool in it. It can generate upto 30 different reports. The problem is, the reports sometime take FOREVER (I'm talking hours here) to generate. What we want to do is move all the generation code into a thread, pass it the queries and instructions and let it go. This will enable us to queue jobs and still allow people to continue using our app - in theory :)
I've already done the ground work. I've written the functions to do the reports, and I tried putting in a thread, and that's were the problem starts.
When the code is executed, my app stops responding until the report has finished. Why is this? Is there anyway I can make the app work while the report is generating?
I'm still a thread newby, so any help would be appreciated.