Crystal Reports access denied error

Hello,
I've been stumped trying to resolve the following error when running Crystal Reports on a new server I'm setting up:

HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services

------------------------

Technical Information (for support personnel)

Error Type:
Seagate Crystal Reports ActiveX Designer (0x80043AC6)
Access denied.
/OrbitRpt/Crystal/AlwaysRequiredSteps.asp, line 57

I'm running a Win2K server (service pack 4) with Crystal Reports 8. I've tried setting the security to "Everyone - Full Control" on all folders but I'm still getting the "Access denied" error. Has anyone seen this before? Any info would be greatly appreciated. Thanks!The following changes fixed my problem:
To properly set up your System Environment Variables:

1. Create the directory "C:\Temp" if it is not already created.
2. Right-click on "My Computer" on the server machine, and choose "Properties".
3. Go to the "Environment" tab.
4. Under "User Variables", select "TEMP", and then click "Remove". Repeat for the variable "TMP".
5. Select any variable under "System Variables".
6. Change the value for "Variable" to "TEMP" (no quotes).
7. Change the value for "Value" to "C:\Temp" (no quotes).
8. Click "Set".
9. Change the value for "Variable" to "TMP" (no quotes).
10. Change the value for "Value" to "C:\Temp" (no quotes).
11. Click "Set".
12. Click "OK".

Be sure to give "Read" and "Delete" access to this TEMP folder so that the Crystal Reports web components can read and write to this directory.

Crystal Report locks up

ok, i am stumped, i don't know what to do with this problem. here is what's going on. i have the following tables in my report:

INCOMINGORDER: {IncomingOrderID, StudentID,....}
ORDERITEM: {OrderItemID, IncomingOrderID, CourseRecordID..}
COURSERECORD: {CourseRecordID, StudentID,...}
STUDENT: {StudentID, FName, LName, Address,..}

The fields with the same names in different tables are foreign keys, ex: ORDERITEM.IncomingOrderID is a foreign key pointing to INCOMINGORDER.IncomingOrderID, and so on.

So in my report i have the following sections:

............
Group Header ORDERITEM.IncomingOrderID
Group Header ORDERITEM.CourseRecordID
Details
Group Footer ORDERITEM.CourseRecordID
Group Footer ORDERITEM.IncomingOrderID
.................

In other words, first i group by the field ORDERITEM.IncomingOrderID and then by the field ORDERITEM.CourseRecordID.

In my record selection formula i have this:

{COURSERECORD.COURSERECORDID} = {ORDERITEM.COURSERECORDID} and
{INCOMINGORDER.BILLINGTYPEID} = 7.00

which works fine, but the problem is that when i try to add the line
{STUDENT.STUDENTID} = {INCOMINGORDER.STUDENTID} to link the tables STUDENT and INCOMINGORDER, my report just locks up. And if i try to add the above link in the visual link expert in Crystal Reports.NET i get error: "Query Engine Error", which is odd since INCOMINGORDER.STUDENTID is a foreign key pointing to STUDENT.STUDENTID.

Anybody has explanation for this?
Thanks.ok, a quick update on my post: i was apparently wrong about the report locking up. It did not lock up, it just took a really long time to load, 6 minutes to be exact. Clearly, that's unacceptable. Anyway, what i noticed was that the more conditions i added to my record selection formula, the longer it took for it to load. Initially my record selection was something like this:

{INCOMINGORDER.INCOMINGORDERID} = 202

In this case it loaded fairly quickly, almost no load time. Then i added one more condition:

{INCOMINGORDER.INCOMINGORDERID} = 202 and
{SHIPPABLEITEM.SHIPPABLEITEMID} = {ORDERITEM.SHIPPABLEITEMID}

Still, decent execution time. Then one more condition:

{INCOMINGORDER.INCOMINGORDERID} = 202 and
{SHIPPABLEITEM.SHIPPABLEITEMID} = {ORDERITEM.SHIPPABLEITEMID} and
{STUDENT.STUDENTID} = {INCOMINGORDER.STUDENTID}

A little slower this time, but still acceptable. And then i added the last condition:

{INCOMINGORDER.INCOMINGORDERID} = 202 and
{SHIPPABLEITEM.SHIPPABLEITEMID} = {ORDERITEM.SHIPPABLEITEMID} and
{STUDENT.STUDENTID} = {INCOMINGORDER.STUDENTID} and
{COURSERECORD.COURSERECORDID} = {ORDERITEM.COURSERECORDID}

So that took a really long time to load. As i inserted some of the fields i wanted displayed in the report, it got as long as 6 minutes.
Anybody know what the cause of this could be? I wonder if it's because i am using a DataSet, i don't seem to recall having similar problems with direct database access.

Thanks.|||Hi,

I think there is no need to give

{SHIPPABLEITEM.SHIPPABLEITEMID} = {ORDERITEM.SHIPPABLEITEMID} and
{STUDENT.STUDENTID} = {INCOMINGORDER.STUDENTID} and
{COURSERECORD.COURSERECORDID} = {ORDERITEM.COURSERECORDID}

these lines. They are automatically linked. Right?|||actually no, they are not linked since when i tried to do so in the Visual Linking Expert i got the following error: "Query Engine Error". i didn't know how to fix it so instead i set up the links in the record selection formula.