report runs too long

[hp22015]

Hello all

I am testing the Web report with Window 2000 server, Crystal report 8.5, SQL Server 2000.

This is my first report using NorthWind instance. It works fine.
<H1>This is the first report</H1
<CFREPORT REPORT=&quot;C:\Inetpub\

http://wwwroot\report\Report1.rpt&quot;>

</CFREPORT>

Here is my second report also using Northwind instance
<H1>Customer Report</H1>
<CFREPORT REPORT=&quot;C:\Inetpub\

http://wwwroot\report\Report1-1.rpt&quot;>

{CustomerID}=&quot;ANTON&quot;
</CFREPORT>
This second report runs forever and never return anything.

Please help me if you see any wrong with my code or if you have any suggestion. Thanks in advance.

HP

 

[hp22015]

All

I found out what is wrong with my report. The reason is I have created a same name parameter for the report. That causes the problem. I believe for this kind of operation (Coldfusion/Crystal Report), we have to apply a different rule such as: do not create any parameter for the report.

At the same time, I found out some thing very interesting. When I write
{customers.CustomerID}=&quot;#FORM.custID#&quot;, Crystal Report takes it as a string, not a value from Coldfusion. I have to write {customers.Customerid} = '<CFOUTPUT>#FORM.custID#*</cfoutput>' and it is ok.

I hope that can help someone if you have ever been in this situation. Thanks.

HP