I admit I'm new to the sql world and am still getting up to speed with the language. I still think in terms of fields and files not tables...

profiler shows no activity

Sorry, I forgot to mention, the stored procedures run fine in SSMS. There are not temp tables being used. There are four queries used in the report and...

First, thanks for all the replies so far.

I have closed and reopened, removed and re added the stored procedure many times. I even shut down everything, left it over...

This particular stored procedure takes 13 seconds. But I have had the same problem with one that only took 4 seconds to run.

I also hit the field refresh button under the data tab and nothing happens.

I am relatively new to SQL Server. How do I check from management studio to see...

I am not using any temp tables, but am using a common table. Will that cause similar problems.

Also, to the other response, are you refering to refresh on the...

Thanks, I was actully thinking about that, except the same thing happens when I create a new report. I just created a new report, added the stored procedure as...

Thanks, that works great if you have the ability to see detail. But we do not allow users to see the detail and the sort order goes back to...