I don't know precisely what BI in Office 12 will consist of but I
would expect to see more off-the-shelf functionality/integration of
SQL Server (2005?) BI apps with Office apps, including Excel then.
I believe you can use Excel (not sure which versions) to connect to a
Web Service. Since RS has a Web Service it should be possible to
produce a custom Excel app if you have the relevant VBA etc skills.
It's not something I have explored in detail.
Andrew Watt
MVP - InfoPath
On Sat, 15 Oct 2005 17:20:23 -0700, NewSPUser
[quoted text, click to view] <NewSPUser@discussions.microsoft.com> wrote:
>I don't mean export, I mean using excel directly connect to a reporting
>server. basically, excel acting as a fat client.
>
>column selection: if the report dispaly a table which consists of 10
>columns, however, some user may not be interested in seeing all 10 columns.
>Can the end user have the ability to hide/collapse that column? i.e. make the
>report to display 5 columns instead of ten.
>
>"Andrew Watt [MVP - InfoPath]" wrote:
>
>> Reporting Services 2000 can export to Excel format.
>>
>> Reporting Services 2005 can too.
>>
>> Office 12 (due in about a year?) has some additional Business
>> Intelligence functionality. There isn't much public yet about what
>> that will consist of, but it looks likely that Excel will do some
>> interesting things with Analysis Services information.
>>
>> Can you elaborate on your column-related question? I am not sure
>> precisely what you are asking.
>>
>> Thanks
>>
>> Andrew Watt
>> MVP - InfoPath
>>
>> On Fri, 14 Oct 2005 11:55:02 -0700, NewSPUser
>> <NewSPUser@discussions.microsoft.com> wrote:
>>
>> >can I use excel as a client for my reporting service? I see some docs on it,
>> >but can't find the actual product. I want the user to be able to select what
>> >column to be displayed. Is that possible now? how about sql 2005.
>>
>>
