Crystal Report v7 data refreshing problem

[martinmac]

I have a report that retrieves data from an SQL Server database and runs calculations to work out running totals and percentages.

This report works correctly on my local PC when connecting to the remote SQL Server but doesnt work correctly when being called via the asp page that sits on a remote server (the same physical server as the sql server).

Any ideas what I can check for? I've deleted the file and recreated it and I get the same problem.

 

[martinmac]

To give a bit more detail, the report is called by a call to an asp with the name of the report being passed.

The asp then calls an asp called rptserver.asp. I think this might be a standard asp taken from somewhere as there are more comments in this asp than the rest of the website put together.

Have any of you had experience with this asp page? Is it a standard page you can download and amend slightly?