Tough question. Keep em comin.

SSRS subscriptions are agent jobs in SSMS. You can fire them off manually like any scheduled job. Just right click the job and start.

The hard part is determining...

I don't understand your question...misspelling or something.

Do you have a calendar table you are using, or are you trying to do this directly with date fields?

Make your ten reports, then make each one a subreport in your master report.

I worked for a company where the owners were very active in PETA. They offered to pay for spay/neuter of any pets.

I work for a cable company now, free...

Holiday weekend (at least here in the US)

Tough question. Also some good discussion. Thanks.

Please explain in more detail what value you need to count and the problem you are having.

Hazy, Hot & Humid. Glad I work in AC today.

Great follow on explanation. Thanks.

Thanks for the answers.

The SP does not have a Try Catch block, good idea. Would I do something like a Return 1 for a failure?

I am not sure what...

I would probably add to the existing dimension.

First....I had a Vic20 also. It is probably still in the basement somewhere.

Straight to titles...lets get some that express how we really feel, and stroke our ego.

Master of all...

SSRS textboxes are not really typed. However your formula indicates fields!value.value for both values, but you are trying to cast them differently. Are you saying you are getting...

Usually I will design a report to say something like "no data available." This way the recipient knows the report worked, but there was nothing to report. Frequently...