reporting service client and column selection

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.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.|||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.
>|||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
<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.
>>