There is no automatic way to recover a lost subscription. However, they are stored in the table ReportServer.dbo.Subscriptions. So, if you are backing up your ReportServer database, you could restore...

Is there a common item the one record from ds1 and the five from ds2 are linked by? If so, have you tried to create a list and group the...

Remember, matrices are really designed for aggregation. Why it acts funny with a "text" field, even if all rows have data, I'm not 100% sure.

However: 😀

Thanks again for coming...

I haven't seen this before. However, just throwing this out there: have you tried an aggregation, such as =MAX(Field!Salesperson.Value)?

Open BIDS. Create a new Report Server Project. Select Project > Add Existing Item and choose your RDL. This will open the report in Design view.