I've never done it but it shouldn't be too difficult. Just select the element (textbox, table cell, image, etc) you want to open the doc and go to properties>>navigation. There...

You are correct...it is not needed on the server.

There are a couple ways of accomplishing this that I can think of...first let me ask.

How is this data going to be delivered?

If you are going to be...

I've been reading Brian Larson's "Delivering Business Intelligence ..." (link) and it's pretty good so far (on ch.13 currently) but I would have to say the chapter on SSIS could...

True, with reporting queries however data is typically being read from a data store or warehouse and not the production OLTP system so the chance of a dirty read is...

Not sure about what VB is needed but it sounds like the page is not refreshing when changing reports...

To answer the question of 'why' it appears this was a design flaw IMO...

I always use 'with (nolock)' on my queries. It seems to speed things up a bit...

cheers,

Ben

select convert(varchar(10),getdate(),111) will give you the correct result. As posted by Ninja's RGR'us this may slow things down a bit when being performed on millions of rows.

cheers,

Ben

you'll need a cursor and a temp table (or table variable)

I can foresee hundreds of replies to this thread...so I'll give you the best answer now before anyone beats me to it. 😛

select convert(varchar(10), getdate(), 101)

Cheers!

-Ben

you could use a cursor to get all the DB names and cycle through them running your query out of the sysusers tables...

In the workbook itself I think there shouldn't be a $ in the sheet name but the Excel connection manager will add it. Is this something that you are going...

Hmmm...can you edit that? I wasn't aware that it was setup like that...

I would suggest creating shared data sources in visual studio for your report project. When deployed to a server I keep all my data sources in a folder called 'Data...