SQL Live Reporting

agibsonsw · Post by **agibsonsw** » 17 Feb 2011, 20:12

Hello. Excel 2003 (possibly 2007).

When linking to a SQL Server I can tell it to update every minute as a minimum.

Is it possible to make this a 'live' connection? I think it might be possible with ADO programming from VBA, but perhaps there is 'another way''?

Andy.

Post by **HansV** » 17 Feb 2011, 20:14

Why would you want to? Think of the load you'll be imposing on the server!

agibsonsw · Post by **agibsonsw** » 17 Feb 2011, 20:24

I quite agree, but I'll need to respond to the question. I don't even think they should update after so many minutes - update on file open should be good enough.

Jezza · Post by **Jezza** » 18 Feb 2011, 00:57

I would create an OLAP cube in SQL and pull down the data on demand via the riboon, the overhead would be horrific otherwise.

agibsonsw · Post by **agibsonsw** » 18 Feb 2011, 09:02

Sounds intriguing - I've often wondered about OLAP cubes.I have SQL Server so what would be a first step?

Andy.

rory · Post by **rory** » 18 Feb 2011, 12:45

The short answer is yes - the table properties allow you to specify both a refresh interval and to refresh on open.

Eileen's Lounge

SQL Live Reporting

SQL Live Reporting

Re: SQL Live Reporting

Re: SQL Live Reporting

Re: SQL Live Reporting

Re: SQL Live Reporting

Re: SQL Live Reporting