OK, so I have set up a test package that calls master1 4 times in a row while resetting things like target database tables to their original state in...

The packages all perform the same type of tasks - reading from database tables, performing transformations and loading data into tables. There are no significant differences.

I don't think you can do both - it's either expand/collapse all at once, or per group.

No command buttons. You use the Text Box item for that purpose. First create the text box and when you select that textbox to be the toggle item, RS...

Have you tried increasing the report's InteractiveSize and/or PageSize properties?

Set the visibility toggle item to some report item outside the scope of the table/matrix, for example another text box (hope I understood your question correctly)

I once had the same problem with Years and a measure, say Count.

I ended up creating a new data set (with a new data source with the OLE DB Provider...

If you really need to filter on the table and cannot handle it in a dataset, you could use a filter expression, for example

=IIF(Fields!Field1.Value="A" OR Fields!Field2.Value="B","show","filter")

set the Operator to ...

Use format code

0.####################

You could combine the EMPLOYEE and TITLE tables in the Data Source View with a Named Query and handle the null values there with something like

SELECT EMPLOYEE.emp_id,

...

Have you

1. Specified the Dimension Usage?

2. Checked that it is selected for your Perspectives (if you use any)?

3. Processed the dimension and cube?

Don't know about hiding values in the legend. I'll try using the (minor) gridlines on the Y axis for this purpose - set the interval to 40, change the color...

Use the CountRows() function in the scope of the group you want to count rows for, for example, in a table group footer row add the expression =CountRows()

If you want...

try creating an index on the fields you want to filter on

I've also tried a table region nested inside a matrix. In that case the report exports to excel but the table area displays the same message as above. The rest...