I'm not going to pretend my C# is great (it's not, I use VB.net myself), but I notice there there do appear to be calls to Open the workbook. I...

Click on your Matrix, and you'll see a Grey border area around it. In the top left there'll be a small box. Right click that and click "Tablix Properties". Then...

You can have multiple matrices on a single report, yes. How are you filtering your results, at the dataset level? Perhaps a better idea would be to do your filters...

Duplicate of https://www.sqlservercentral.com/Forums/1892498/Multiple-matrix-on-one-sheet-and-presenting-to-user-via-hyperlink

Welcome to SSC.

It's always important to make sure that when asking questions, you give as much details as possible, but also provide the information with it in a...

Not related to the question, but to the SQL provided.

Why is the first IF statement IF (@TotalDays = 30 OR @TotalDays <= 31) and the ELSE...

Table Value Parameter certainly sounds the way, but looping isn't really what you want to do. The parameter, as it suggests, is a table, so you can insert the whole...