I think you need to do this with scripts, it is a lot easier to see whats going on.

create the endpoints on both of the server and grant permissions:

Run this...

this error looks like what you get when you are looking at the principle, what does the error on the mirror say?

Ok, so the servers are having trouble connecting to each other. It could be the port is blocked but most likely it is credentials.

do this on the mirror:

Lets check...

your right, the visibility doesn't work with page breaks for some reason. The best I could do was putting a list box on the report in between tables and...

Edit: hold let me try exactly what you are doing.

Right click on the table, go to properties, check "Insert a page break after this table"

are you right clicking and opening tables?

are you looking for something like this:

select orderid, rate,

case

When rate > 1 then rate

When rate > 0.1 then rate * 10

When rate > 0.01 then rate * 100

When...

have you tried taking a look at things with profiler?

i have experienced this, when it happened to me i forgot to close my connections in my code.

Connection1.Close()

It doesnt really help to set the connection pool to unlimited.

use SYSTEM_USER in the where statement of the query, make sure you use NT auth.

can you just make the SP column appear with a 0 when it doesnt have a value?

You can add security to the specific dtsx file by going to the package properties and finding packagepassword and protectionlevel. The only thing is you have to give that...

peterzeke is right, i miss read your question, you cannot control parameter hidden property. You are best off creating an asp.net page to handle this.

or just create two reports...

you would go to Report > Report Parameters... select the parameter you are using, change the default values to non-queried and put in the dateadd function.