Simultaneous Crystal Report Generation - how to distribute and generate dynamic crystal reports while multiple users are logged on.
Posted on 2004-10-29
Hi all, I'm a co-op student working in Toronto and I've taken over the old co-op student's web app project.
The app gathers a bunch of data through layers of pages and what not, then, once data entry is complete the user can print a report summarizing and charting the info. The current system works fine - when only ONE user is trying to print a report - but when a user tries to print the same report while another report is being generated it will error or the report will be mixed data.
I'm trying to figure out the best way to isolate the users sessions so this doesn't happen. Additionally, the user will need to be provided raw Access files (the database is oledb) of their data as well....this part I need to write from scratch.
What's the best method to solve this dilemma?
I was thinking of creating a folder per user whlie they are logged in and keeping all their session files in that, kinda like a shopping cart...but I have never tried something like this, and there must be a tried and tested method that you guys can enlighten me with. The site traffic will not be very large so the memory is not a huge issue, but a robust scalable solution is preferable.