Group:  Microsoft Excel ยป microsoft.public.excel.datamap
Thread: Connect Excel 2007 to SQL Reporting Services models ?

Geek News

Connect Excel 2007 to SQL Reporting Services models ?
tony <antoine.leblanc[ at ]gmail.com> 5/30/2007 10:18:51 AM
Hello,

I have read that Excel 2007 can now connect to SQL Server Analysis
Cubes, as well as SQL Reporting Services Models.

I have found in Excel's Data Ribbon how to connect to a SQL Analysis
Services cube, no problem here, but I can't seem to find the SRS
Models there. I have created a model in SRS, but I have no idea where
to call it from in Excel 2007.

Thanks a lot for your help.
A

RE: Connect Excel 2007 to SQL Reporting Services models ?
ShaneDevenshire 6/15/2007 4:45:02 PM
Hi,

Neither do I. In fact I've never used SRS, however, you might try this:
press Alt D, P and pick External Data Source, then Get Data.
--
Cheers,
Shane Devenshire


"tony" wrote:

[Quoted Text]
> Hello,
>
> I have read that Excel 2007 can now connect to SQL Server Analysis
> Cubes, as well as SQL Reporting Services Models.
>
> I have found in Excel's Data Ribbon how to connect to a SQL Analysis
> Services cube, no problem here, but I can't seem to find the SRS
> Models there. I have created a model in SRS, but I have no idea where
> to call it from in Excel 2007.
>
> Thanks a lot for your help.
> A
>
>

Home | Search | Terms | Imprint Contact
Newsgroups Reader - provided by WiredBox.Net