body

Good one, thanks.

You might want to take a look at this:

http://blogs.msdn.com/b/chrishays/archive/2004/07/15/dynamicgrouping.aspx

overslept

Check this out.

http://msdn.microsoft.com/en-us/library/dd239378.aspx

In a stored procedure, you should just set a default value of '' on your input parameters and that will probably do. Hope this helps.

What is the error you are getting?

upside down.:hehe:

So you have one Sp, one table, on one report. How are you executing it 6 times concurrently with different parameters? Subscription?

If I understand you have a single SP that you use to create 6 different results within a single report, perhaps with 6 different tables, or matrix, or charts.

If the...

There are 3 columns in the execution log

[TimeDataRetrieval]

[TimeProcessing]

[TimeRendering]

That should tell you where the hold up is. If it is in your data retrieval then you might want to look...

OK, then I have to assume there is a relationship between the employee and the department. Why not create one dataset and then do a report that shows employee...

You should just be able to select Stored Procedure as your query option, then select the appropriate stored procedure. The parameters the sproc needs will automatically be created in...

what a crazy pair

First time through I read data sets, but my brain thought data sources. I am glad I reread it. 😉