You need to add some temporal awareness to your database and queries, and fractionalize monthly salaries into daily salaries.

If Employee 1 is in Dept A from 20110401 through 20110412 and...

Holiday weekend. 😎

(At least here in the US)

As a matter of coincidence Pragmatic Works is running a webinar on SSRS this morning. Go here for more info:

http://pragmaticworks.com/Resources/webinars/Default.aspx

I have long missed the paintbrush in BIDS. What I do now, is highlight all the cells I want formatted the same and then set the formatting properties in...

Suspend disbelief

Put a web cam in your cube and make it a reality TV site. The world needs more reality TV. 😀

I would also put a buffer in to your calculation so you are not notified every time a query takes a second more than average.

Generally speaking, the skill you don't have is the one that pays the most in your area. 😀

For all other questions try:

http://www.salary.com

Debate

Then try passing your run time parameters to a database table, and make your subscription a data driven subscription that can read that table for the current parameters

Make your multi value parameter sensitive to the number of charts that can be displayed so you can only select an appropriate number.

Busy

If you don't want to put your 5, 6, & 7 fields out horizontally (landscape on legal paper) for some reason, then right click on the detail row header on...

All SSRS subscriptions are SQL Server Agent Jobs. Use the following script to figure out which Agent job corresponds to which subscription. Run this against your reporting services...

Conjeck