Is crystal capable of running a report in multiuser environment

[Guest_imported]

I have got a report running in Crystal Report (ver 7.0) which extracts data from some 16 tables (informix 7.0 database) into one temporary table and prints it out.
There are multiple users using this report to print out andthe final temporary table from which the report gets printed is same, if at a time there are more than one user
printing the same report the final temporary table is dropped and except one all others get a error. Is there a way can this table be a variable name in crystak report so that each user has his own temporary table. Is there any other work around ?

Thanks

 

[kenhamady]

Are you running the reports from an application? Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)

 

[Guest_imported]

Well Thanks for your response,
Yeah I am using Visual basic to call crystal reports,

 

[MalcolmW]

This is probably happening because when the temporary table is created, you are checking to see if the temp table already exists, and if so, simply dropping it before creating it again. This is good database practice, as it prevents the global temporary table from growing too large.
It does create the problem you describe if there are multiple people using the global table.
You can change it to a local temporary table so that it becomes user specific (the solution you suggested). This is the simplest solution, but your DBA may have reasons that preclude using local temp tables. In this case, your DBA will have to develop some procedures to ensure there are no other users impacted before dropping the table. Malcolm

 

[Guest_imported]

Thanks Malcolm for a prompt response and all this help .
Good day Sir.