> ## Content Index
> Fetch the complete content index at: https://www.philsimon.com/llms.txt
> Use this file to discover other available public pages before exploring further.

# Creating Commands in Crystal Reports via MS Excel
- URL: https://www.philsimon.com/creating-commands-in-crystal-reports-via-ms-excel/
- Published: 2008-01-19T15:43:02.000Z
- Updated: 2025-06-20T22:30:43.000Z
- Description: A tip on shrinking large tables with commands.
- Author: Phil Simon
- Tags: Data Issues, Reporting

Many transactional tables in databases are big. I mean, huge. I have seen tables with 35,000,000 records. Imagine writing a report with four or more tables when the data resides in monstrous tables.

Let's be clear here. There's only so much that you can do when you have really big data sets. By the same token, however, often you can reduce the run time for large reports by using commands in Crystal Reports.

In the following PDF, see how I use Microsoft Excel to create a command in Crystal. This ultimately saves a great deal of time when the report runs.

[Creating SQL Commands in Crystal Reports via Microsoft Excel](https://www.scribd.com/doc/145977045?ref=philsimon.com "View Creating SQL Commands in Crystal Reports via Microsoft Excel on Scribd")