You can access any database schema from within SSRS.

My first thoughts for your problem:

1. Make sure that the person who develops the report in SSRS is connecting with the correct...

First of all, why are you adding an 'all' parameter yourself?

Can't you just set in your parameter options that the parameter allows multiple values?

If you really want to do it...

First of all, make sure that you only deploy your report, and not the whole project.

Second of all, to be sure, and if it isn't the expected behavior, you should...

Add page breaks before each table which you want to display on another sheet.

Via the 'PageName' property of the tablix/matrix/chart, you can give each Excel-sheet a nicer name also...

Hope this...

Additionally, you can give a nice name to the tabs, like 'Summary' and 'Details'.

This can be done using the 'PageName' property of the tablix/matrix/chart

I have been struggling with this format-issue just like you.

I haven't found any solution (yet), but when I do, I will certainly post it here.

One thing I have noticed though,...

We prefer SSRS, because we use some versioning system.

When someone changes an existing report with Report Builder, you aren't able to retrieve the previous version (unless they will save their...

Never mind, my SSIS was referencing the wrong table, and my query to check was referencing the table it should be loading.

So in fact, there never was a problem, it...

First update: I've tested the same package on my local machine, and there all records were correctly inserted.

Can it be something with the server which is running the package?

It is...