This is the basics of the code that I use. I would have built from other code that I found on the internet. I will post the original...

You could also use a data driven subscription to select the list of States and use this as input into the subscription. This way if a new state is...

Option 1 :

You could create a data driven subscription that selects the Branch IDs and passes them as parameters to the report.

The benefit of this approach is that your...

If you are running the SSIS package from within VB code you can setup variables within the SSIS package, use those variables to build the connection string in the SSIS...

I add the '*' option to the list of available values in teh query that populates the drop down list, then in the default value I specify -1 so that...

There is a langauage associated with each report.

View the report in layout mode, click in the blank area beneath the report details and hover over the properties tab to reveal...