What do you mean by "multiple select query results"? Yes, you can use more than one SP in a report. However, this is generally not recommended unless the resulting datasets are fairly small. Any joins between the two result sets have to be processed by Crystal in memory as they can't be pushed down to the database. A better option would be to create a third SP that will combine the results of the first two in order to provide the data for your report.
-Dell