Sounds more like a job for SSIS than Reporting Services. Unless it absolutely must be rendered through RS, I'd go with an SSIS package. If they're asking for...

Definitely it can be done. Here's something from MSDN that might help you get started:

MSDN: Adding a Matrix

You'll need an expression in the format property of the field, and some value you can anchor it to. For instance, if you know row "A" will always be...

IIf statements don't simply fail, so it looks like there's one of two things going on. Either the value truly isn't zero, or the statement is not written like...

Ben Moorhouse (10/15/2010)

---

With disk space getting cheaper and cheaper, I'm considering doing some basic disaster recovery for home.

Copying all music/photos etc onto a big disk and taking it to a...

A few thoughts:

1) Have you tried putting the [value = 0, "Black"] part in the front of the IIf statement?

2) Does the text box containing the expression have a default...

Jack isn't saying multiple datasets are bad; he's saying trying to blend multiple datasets in the same table control is bad. RS just wasn't designed to take more than...

Sure, just have it pull the possible values for a parameter from a query. Here's a more in-depth explanation:

http://www.sql-server-performance.com/articles/reporting/report_parameters_p1.aspx

That's what's really important though, right? I'll have to try that sometime.

Does the query return the date range as a column, for example "1/7 to 1/13" or does it simply pass the date and have RS do the grouping? If...

I think the RS pie chart always deals with 100%. One workaround is to have your query append a new row if the sum of a group is <...

My hunch is that from the actual Reporting Service's perspective, the work has been done -- that is, the report has been compiled and handed off to the Report Manager...

7. Most of the replies to my queries on the SSRS forum on issues that I faced suggested not to create such huge reports, restrict the reports...

In the format properties of whatever control is displaying the date, put this: MMMM dd, yyyy

Just curious, have you looked into linked reports? If you have 1000 reports, there's probably a use for linked reports in there somewhere.

Link:

Linked Reports on TechNet