Crystal Reports Weirdness

[steen.bray]

Hello,

I'm having an extremely weird problem with Crystal Reports and .NET
2005.

The process:
I have created a report launching aspx page that allows a user to
select one of 8 reports, fill out the specific parameter(s) to that
report, and launch another page that has a reportsource and
reportviewer control. This all works fine for 1 person, and works fine
90% up to 3 users acessing the system. However, on the 4th user access
the same report with different parameters at the same time as the
other 3, it is pretty much guaranteed that one of the 4 users will get
incorrect results back. The incorrect results being the parameter
another user selected. The other users will get back the expected
results.

I'm stumped here. We are using ODBC to connect to an RDB database. I
have verified the Session ID (originally that's how we were passing
the parameters from one page to the other. Now we use Caching defined
by the Session ID so it remains unique for each user) is correct for
every user. The user that gets the incorrect data, it seems like his/
her parameter value is overwritten.

Has anyone else had a problem like this with Crystal Reports .NET? I'm
stumped.

 

[sloan]

If you move to the "PUSH" method, you will greatly increase scalability and
slim down CR headaches.

http://www.codeguru.com/csharp/.net/net_general/toolsand3rdparty/article.php/c13253/

Basically.
Create a strong dataset.
Use it as the "contract" for building the report.
Populate an instance of the strong dataset ... using data from your odbc
source.
Push the data, instead of pulling it.

But look at the article.

Pulling Data Through ODBC Using Crystal Reports...is a very unstable/shakey
setup in my opinion.