Many thanks.

Technically its possible, but in 8 years it never has. However, there is a counter that increments in that situation so I should be able to use the...

I just knew it was blindingly obvious. :crazy:

Thanks for that Gail.

"I should have gone to Specsavers".:-)

I'm just grateful this forum and all its helpful contributors exist. Thanks again Jack.

Robin

I've found the answer.

Looking at those properties again, it occurred to me I really wanted to publish to the the database, not to the site. I changed the target...

Hi Jack.

Here it is when:

Debug = StartItem

OverwriteDataSources = False (makes no difference I still get the UID and password request if set true)

TargetDataSourceFolder = Data Sources

TargetReportFolder =...

Thanks Jack.

I can get into Site settings.

First screen.

Name: SQL Server Reporting Services

Enable My reports is ticked.

Unlimited snapshots.

Exec time max 1800

Exec logging ticked.

Log entris over 60 days removed.

Site...

Hi Jack and thanks for responding.

All the icons are green except:

- 'Sharepoint Integration' and 'Encryption Keys' which are both blue exclamation marks.

- 'Initialisation' which is a tick but greyed out...

I've found it. Table footer was what I required! Simple when you know how! :blush:

Thanks again guys.

Robin

Thanks guys.

Using Excel is not ideal as the load time for the application is so long. Having a browser already open is a better option.

I've got a long...

Sounds good to me.

Thanks ...... Robin