I have a crystal report that uses several tables and views from the same data source. I added a stored procedure to the mix and I get the following error: "More than one data source or a stored procedure has been used in this report. Please make sure that no SQL Expression is added and no server-side group-by is performed". The report runs fine if I don't use any of the fields from the stored procedure, but when I use a field the report fails and I get a "not supported" message. Please help.
This had a very similar problem myself with a report and using a stored procedure. Didn't exactly find out what was happening but got around it by creating a new SQL table and then amending the stored procedure with TRUNCATE and INSERT commands to populate my new table from the stored prcoedure.