Adobe Community : All Content - All Communities

Coldfusion Reports .cfr file too slow

forums_noreply@adobe.com — Wed, 16 Jun 2010 20:57:34 GMT

Hello

I created a .cfr file which is outputting the 12k records, I ran the query in SQL Mnager, runs good. but when I Create a report with the same query it takes more than 3 minutes to run, sometimes timesout.

I am working on the CF 9 on x64 bit Win2008 Server , SQL 2005 is the DB. Accessing the Report from a URL.

Code Snippet from the Report

    <cfquery name="MyQuery" datasource="LargeMeters">
            SELECT "Account"."AcctStatus", "Account"."Account", "Meter"."Use", "Account"."TotalMeters", "Meter"."PMDueDate", "Meter"."PMFreq", "Meter"."DAC", "Account"."County", "Account"."Zone", "Meter"."IOR", "Meter"."MeterId", "Meter"."Mfr", "Account"."GridLetter", "Account"."Gridnum", "Meter"."StatusCode", "Meter"."Size", "Meter"."MeterType", "Meter"."BPMtrId", "Meter"."BPMfr", "Meter"."BPMtrSize", "Account"."PG", "Meter"."BPFlag", "Account"."Grid", "Account"."BillingCycle"
             FROM   "LargeMtrs"."dbo"."Account" "Account" LEFT OUTER JOIN "LargeMtrs"."dbo"."Meter" "Meter" ON "Account"."Account"="Meter"."Account"
             WHERE "Meter"."StatusCode"=N'A' AND "Account"."AcctStatus"=N'01' AND "Meter"."BPFlag" IS NULL
              ORDER BY "Account"."County", "Account"."PG", "Account"."GridLetter", "Account"."Gridnum", "Account"."Account", "Meter"."Use"
        </cfquery>

Thanks

Dan

Display the Crystal Reports 2008 .rpt file in the Browser

forums_noreply@adobe.com — Tue, 11 May 2010 17:27:00 GMT

Hello !!

I am using CF 9 Standard Edition, and need to Display the Crystal Reports 2008 .rpt file in the Browser. This is not Possible using Unrefernced URL's as per the SAP experts https://forums.sdn.sap.com/message.jspa?messageID=6270917.

the Reports are in the root folder...

I Hope that it can be done some how using CF 9. Could some one please Point me in the Right Direction. I am unable to Find much documentation, Cfreport Tag doesn't work with this Version of CR2008, I am running on the WIN X64 bit.

Thanks

CF 9 Standard Edition, and need to Display the Crystal Reports 2008 .rpt

forums_noreply@adobe.com — Tue, 11 May 2010 13:38:46 GMT

Hello !!

I Hope that it can be done some how using CF 9. Could some one Point me in the Right Direction. I am unable to Find much documentation, Cfreport Tag doesn't work with this Version of CR2008, I am running on the WIN X64 bit.

Thanks