crystal report.. on network application

[zeeshangodil]

i m using crystal report with vb...

i have designed a report with a table on it..
the table creates when user click on the preview button on the form..
named tmpAccountLedger..

but when 2 or more users click at the same time..with the different account specifie.d...
the report shows the same for all users..

what should i do..
plz suggest..
regards.

[JaganEllis]

What's the underlying database? Can you use a session table? Can you use some sort of id to uniquely name each table creation? I assume you drop it at the end somehow?

[wapper]

For MSSQL, I use global temporary tables for such purposes. When developing a report, I create a normal "dummy" table with prefix "_tmp_" that can be used for building report. At runtime, I create global temporary table like "##SF93DXU2" with same structure, and replace the name of original dummy table with the name of actual temporary table. Works fine. You can even forget to drop the table afterwards and SQL will clean it up for you. In fact, there are situations where you can't drop the table yourself (for example, if temporary table is used in a subreport at the end of the report, then it is not queried immediately but only when the user reaches the page that contains subreport).