Joined: 26 Mar 2012
Online Status: Offline
Posts: 2
Topic: Add Command Function Posted: 26 Mar 2012 at 4:10am
I have used a simple Add Command function in Crystal XI to create a 'table' which I have then used in conjunction with other existing tables within Crystal to create my report.
The report runs fine and does what I need but when it runs it is incredibly slow.
Joined: 20 Dec 2011
Location: England
Online Status: Offline
Posts: 259
Posted: 26 Mar 2012 at 5:24am
I've had this problem too and I've never been able to fix it directly - I get round it by doing everything inside the SQL command... ie create the link to the additional tables inside the command so you dont need to join anything inside crystal.
Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Posted: 26 Mar 2012 at 6:33am
Yes, the issue with using a command and tables is that it loads all the rows into memory before doing the rest of the processing (at least that is what I have been told). It can really bog things down.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
