You can check execution log for report and compare timerendering vs timedataretrieval. It could be poorly designed report that takes a lot of time to render.

In row groups sector, click on the top one static and in properties window change value for RepeatOnNewPage property to True

You have to be:

1. Site settings security - "system user"

2. Security on folder - "publisher"

That's for 2008.

FOr 2005 as far as a remember, you have to be local...

add your windows account to Administrator group on machine which hosts SSRS (if it's NLB than on all machines). That should help.

As a start piont:

SELECT c.name

,[UserName]

,[RequestType]

,[Format]

...

Good, prefix sp is used for system stored procedures

Sometimes you have to give user access to limited number of the reports visible for other group. And if it is only one or two users, I don't see a...

You can aslo set up individual permissions on folders or reports

You can change business logic in Sp without modifying and re-deploying report and as long as number of fields and their names are the same.

You have to go through all folders and manually remove user rights on them (Properties tab -Security)

You can ask your network team to create group in AD and assign users to it. Than all you have to do is grant permissions to particular folders...

When you navigate to default (home) page http://server/reports, you will see Properties tab (next to content tab). You can assign roles there.

Just in case URL:

http://servername/Reports/Pages/Folder.aspx?ViewMode=Detail&SelectedTabId=PropertiesTab

Do you have Reporting Services in place already? If you do, than all you have to do is to deploy your reports to http://servername/reports and give them...

You can also write stored procedure to combine data from both DBs (using openrowset for example)

It is not the case for SQL 2008