My first thought is to look at the configuration of the Linked Server, although I can't say I can recall any particular setting that would affect this.   However, as you...

Just getting the drill-down isn't actually all that difficult.
1.) Be sure to have a group in your tablix for each level
2.) Add a separate column to your tablix...

If there's going to be a reason to not pass data via a TVP, it's likely because they don't have statistics like an actual table would.   Any such table with...

You may want to consider a "normalized" table structure.   Something along the lines of:CREATE TABLE dbo.Addresses (
    AddressID int IDENTITY(1,1) NOT NULL PRIMARY KEY CLUSTERED,
    AddressType char(1) NOT NULL,        -- 'C'...

Like any other tool, cascade delete is at least as dangerous as it is powerful.   If you're going to make use of that kind of power, then you have to...