hi Issac,
actually that's exactly what i'm doing, using a temp table to drive the data
out. However now, i need to delete the data from the table after its been loaded by
the report as the data contains confidential data. What would u recommend?
-----Original Message-----
From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]
Sent: Monday, March 31, 2003 10:40 AM
To: CF-Talk
Subject: Re: How To Delete Recs After loading of crystal report (URGENT)
It's probably a complex query... I've heard that crystal reports has a big
problem with complex queries as a result of it doing something like
(pseudocode):
WHILE EXISTS (SELECT blah blah
FROM blah blah WHERE blah blah
AND primarykey NOT IN (somelist))
SELECT TOP 1 blah blah
FROM blah blah WHERE blah blah
AND primarykey NOT IN (somelist)
somelist = somelist + newkey
)
That's what I've heard anyway. I've actually seen it tank a reasonably
powerful server with what looked like a reasonably simple query just because
of some basic join statements... It's entirely possible that could have been
a result of a poor understanding of Crystal, I don't know, I'm not a Crystal
expert myself. Their solution was to create a temporary table to hold the
data drawn from the "complex" query and use that temp table to drive the
report. I prefer using HTML for reports and if necessary publishing them to
PDF myself.
> If you're using SQL Server, you can put your results into
> a temporary table.
> But why are you putting the report data into a table in
> the first place?
> Why not just do a select statement?
> ----- Original Message -----
> From: "JAIME HOI" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Sunday, March 30, 2003 6:30 PM
> Subject: How To Delete Recs After loading of crystal
> report (URGENT)
>> Hi
>> Does anyone knows how to delete records from a table
>> after crystal
> report completed loading its report? i tried using
> CFX_WAIT however , it
> deleted the records before the report was able to retrieve
> it and display
> it.
>>
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> ~~~~~~~~~~~|
> Archives:
> http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
> Subscription: http://www.houseoffusion.com/cf_lists/index.
> cfm?method=subscribe&forumid=4
> FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
> Signup for the Fusion Authority news alert and keep up
> with the latest news in ColdFusion and related topics.
> http://www.fusionauthority.com/signup.cfm
> Unsubscribe: http://www.houseoffusion.com/cf_lists/uns
> ubscribe.cfm?user=633.558.4
s. isaac dealey 954-776-0046
new epoch http://www.turnkey.to
lead architect, tapestry cms http://products.turnkey.to
tapestry api is opensource http://www.turnkey.to/tapi
certified advanced coldfusion 5 developer
http://www.macromedia.com/v1/handlers/index.cfm?ID=21816
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
