Crystal Reports Command / Stored proc as datasource

Message

     I have a query like th following.  After going thro' the doc  I feel the best way is to go with either COMMAND or stored proc as datasource where the query can be entered as it is and parameters can be set.  I would like to get Brian's opinion on this.  thanks

SELECT  COUNT(TABLE_NAME1.COLNAME6), 

          TABLE_NAME1.COLUMN_NAME1, 

          TABLE_NAME1.COLUMN_NAME2,

          TABLE_NAME1.COLUMN_NAME4,

          TABLE_NAME1.COLUMN_NAME5, 

          TABLE_NAME1.COLUMN_NAME3 

FROM TABLE_NAME1 

LEFT OUTER JOIN TABLE_NAME2 

ON TABLE_NAME1.PAGE=TABLE_NAME2.ID

WHERE (TABLE_NAME1.COLUMN_NAME4='EN' 

     AND TABLE_NAME1.COLUMN_NAME5='ES' 

     AND TABLE_NAME1.COLUMN_NAME1=1 

     AND TABLE_NAME1.TIMESTAMP  >='3/1/2008'

     AND TABLE_NAME1.TIMESTAMP  <='3/28/2008' 

     AND TABLE_NAME1.TYPE in ( 2 ,4,8,9,10 )

     AND TABLE_NAME2.COLUMN1  LIKE '%URLSTR%'

     or( TABLE_NAME1.COLUMN3 IS NULL 

          AND FFID = ( SELECT FILEID FROM TABLE_NAME4 FT, TABLE_NAME2 APG

                         WHERE FT.ID = FFID

                         AND FT.COLUMN3= APG.ID

                         and APG.URL LIKE '%URLSTR%'

                         )

          )

)

GROUP BY TABLE_NAME1.COLUMN_NAME1,

     TABLE_NAME1.COLUMN_NAME2, 

     TABLE_NAME1.COLUMN_NAME4,

     TABLE_NAME1.COLUMN_NAME5,

     TABLE_NAME1.COLUMN_NAME3