I would set up your dataset query to not return zero or null results, that way you won't even get those months returned.

Try setting it up like mailing labels. That should probably work for you.

http://www.tek-tips.com/faqs.cfm?fid=5989

Make sure that when you preview it in VS that you are in Print Preview or you...

It's snowing again. I guess that means I have to fix the snowblower.:(

Good question. I had to do some reading to answer the question. Thanks.

The first thing I notice is your IIF statements. It may be a style issue, but I have always nested them. (I think I tried it with AND...

What is the hidden expression for table4 and what is the data being fed to that expression?

I found a script online - I can't take credit I don't understand querying XML data in SQL server well enough - that gets you what you want.

SELECT SubscriptionID, extensionSettings,

CAST(extensionSettings...

Look in the report server database, dbo.Subscriptions table, ExtensionSettings column.

The report server database has pretty much everything you need to know about about a report and its subscriptions.

An rdl file is just an XML file. You can open it with virtually any text or HTML editor. It will probably contain everything you need to see.

Come...

OMG! Only 353 shopping days till Christmas. 😛

Ray K (1/5/2011)

Which is why I've been holding off on washing mine (as much as it needs...

I think this is possible, but I have not done it: Create a linked report for additional schedules and maintain history on each linked report.

Bad timing....washed my car yesterday, flurries overnight made the roads a mess.

ForceExecutionResult is a great little debugging tool/task property. Great question.

Generally speaking I would consider it a best practice to use a UNC path when possible for exactly these reasons.