I would still expect to get this error with empty data, because LEN(0)-6 will still result in the RIGHT function being passed a negative number. Both examples below will...

I don't know about the second error, but when I've encountered "Invalid length parameter passed to the RIGHT function" it usually means I've got some anomalous data that's smaller than...

Here are a couple of articles to peruse:

http://social.technet.microsoft.com/wiki/contents/articles/18748.ssrs-multi-font-color-multi-font-size-within-a-single-field-textbox.aspx

http://www.sqlchick.com/entries/2010/10/31/using-different-formats-within-a-single-textbox-in-ssrs.html

Linked server double-hops (from 3 to 2 to 1) are more complicated to set up than single hops. This [/url]link has more detail. Also, make sure you're setting...

For question 1, we use Active Directory permissions groups to assign access to folders in SSRS (in Folder Settings -> Security). For instance, the Accounting AD group has access...

You can usually optionally ignore parameters by adding in something like "OR @param IS NULL" which returns all results. If you have multiple parameters that can be NULL, though,...

Make sure the parameter is set up in the subreport properties. In the main report, there will be a cell for the subreport. Right-click on that and check...

It basically says if there are no rows, hide the tablix. In general, visibility expressions are formatted "IF X, Do this, Otherwise do that." True means hide, False...

To spell it fully out, here is what I would do (based largely what you have suggested):

1. Have two tablixes, which we'll call 999 and Not999

2. Set the header to...

It would be formatted differently than your desired example, but if you just add total rows for your Quarter group, you should get something like:

Quarter Month Passed Failed

------- ----- ------...

A few quick hypotheses off the top of my head:

1. A filter in the report tablix might be removing the results

2. A visibility expression in the group/tablix might be hiding...

The only suggestion I can offer at this point is trying to stagger the SSRS subscriptions to minimize the concurrency. Maybe if just five of them fire off each...

I'm not sure about stored procs, but this should get you started in determining which tables are replicated:

SELECT NAME, is_replicated, is_published

FROM SYS.TABLES

WHERE

TYPE = 'U'

AND (IS_REPLICATED =...

Yes, you should be able to control headers for each tablix. Then in the Visibility properties for each tablix you could have an expression like "=milestone_code =999" or "=milestone_code...

Your solution is the way I'd do it, Wendy. I'm not aware of an expression for repeating headers (just a true/false), but I'd be interested if someone knows otherwise.