1) Crystal Reports provides extensive parameter support. The types of parameters supported are: single value, multi-value, and range value (e.g. Start date to End date), or a combination of all three. 2) SSRS parameters only support entry of a single value. It doesn't support multi-value parameters or range parameters. For example, the user can't be presented with a list of Employees and select more than one for reporting on. Doing so requires writing custom code and writing more complex SQL queries

raghuramaiah wrote: 2) SSRS parameters only support entry of a single value. It doesn't support multi-value parameters or range parameters. For example, the user can't be presented with a list of Employees and select more than one for reporting on. Doing so requires writing custom code and writing more complex SQL queries That is not true. You can have parameters with entered value, radio-buttoned or checkmarked . You can have several parameters in SSRS. Also, very easy to do OLAP reporting, drill-down dimensions and drill-through reports.

You can also get a range to work in SRS by just adding in two parameters and then modifying SQL use parameters properly. Parameters is definitely not a sticking point for me in working in SRS vs. Crystal. For me the functions are much more difficult to use in SRS than they are in Crystal... so far. But then I have a lot more experience in Crystal than I do in SRS.

Sorry I think you are wrong, are you talking about SSRS 2000? In 2005 you have multivalue parameters. An strong point of SSRS is that it works fine, easy to install easy to access (via query string, post or webservice). By Using Crystal reports some guys have issues installing it and making it works. An strong point for Crystal reports is the ability to pass a dataset fromyour custom .net appand build a report using that as datasource (you can do this using SSRS but is not straightforward). Braulio

“Despite my past affair with Crystal Reports, I have to report that I’ve thrown over my loyalty to Stonefield Query. The simplicity and depth of the program make it easy for me to recommend. “ Doug Wolf, Author - Crystal Reports for Dummies