Dynamic tablix creation on SSRS?

Question

Scenario: I have a table of open orders by vendor, I need to be able to generate an excel file with a list of every vendor's open orders separated on each tab. I need then need to set up a subscription that would send this excel file to someone who would distribute the sheets to the respective vendors. The problems: - The list of vendors changes frequently therefore I will need to dynamically create and remove vendor tablixs as these changes occur. - I need to also have each excel sheet labeled dynamically to the correct vendor. Thank you in advance for you much appreciated help. please let me know if you need any additional details.

Answer 1

I'm filling out my Wyzant profile and this was the latest unanswered question. I see that its almost 7 years old.

This is well into the realm of VBA. Excel doesn't have a native way to dynamically change spreadsheet names. When you say subscription I'm assuming you mean send the relevant person just that vendor's worksheet in a new workbook, which is again something that can't be done with just excel options, but it is something I've done with many projects with VBA. Depending on what your exporting with, you might be able to generate a workbook with vendor tabs, but they'll be static.

It doesn't make sense to go into much more detail in a very old post. What you're asking for is doable, but only with VBA programming knowledge. I'm a VBA expert with many years of experience. If anybody sees this I'm available as a tutor or consultant.