Appending to the WHERE clause

[RogaDanar]

Is there a way to append to the WHERE clause that Crystal creates?

Our program is written in Visual C++, and we would like to cut back on the time it takes some of our reports to run.

We have functions from our UFLs in our record selection formula, so Crystal pulls all the data over and then manipulates it, instead of having the server manipulate them. So if we can kill some of the records on the server side using SQL, it would reduce traffic and speed things up a bit.

Thanks for the help,

JD

 

[synapsevampire]

You can pass the whole recordset to Crystal, which is how you might better approach this.

I would move the UFL functionality to the database as then it's available to all processes.

There are lots of sample apps for passing a recordset to a Crystal Report on the BO website.

http://support.businessobjects.com/communityCS/TechnicalPapers/apps_rdc.pdf.asp

Please keep in that most functionality is based on the version of the software and database being used, so posts will net better results by including basic technical information.

As with this posting, you're probably better served to request help resolving a problem (slow running reports) , rather than stating how it must be done (where clause modification).

-k