How does command work

[Former Member]

Hi Dell,

I have concerns related the Command in Crystal

Can I create a report out of commands instead of mapping direct DB tables in the filed explorer to reduce the processing time?

When connecting a command with DB the data will be pulled in crystal RAM. What if I have a report created out of command? where the data will be processed?

I appreciate your feedback

[DellSC · Accepted solution]

Hi Dod,

Yes, you can create a report based off of a command - that's what I usually do for reports that use more than 2 or 3 tables.

If you use a single command and have all of the selection criteria in the Where clause of the command instead of using the Select Expert, all of the data processing will happen on the database server as long as you're using a database that has a server, unlike MS Access, Paradox, etc., which are file-based databases which have no server to do the processing.

-Dell