Depends on your version of Crystal but yes you can set the query via code to any valid SQL syntax for the connection object you are using. I always make my connections ADO in Crystal and at runtime I submit the proper SQL string to process the data (remember thou you have to provide the fields with the proper datatypes to the report for the binding to occurr). But I too suggest use an SP for best efficiendy and try to do soem of the stuff Crystal will be doing with group if you don't need drill downs. You will note a lot of CPU cycles and temps files on the location Crystasl is invoked from if you provide the data and let it do the summations (we do web Crystal). Also, consider anything you can do to limit the data from SQL that is need will speed the report up. I can provide you the ASP file we use as it is based on the Crystal Example anyway.