Export to Excel with Expand/Collapse Feature

Hello,
I've searched the news group postings and have not found an answer. The
question is:
Is it possible to export a report from RS into excel and have the
expand/collapse feature in excel work?
Thanks,
RossIf your report has drill down the resulting Excel spreadsheet will have
expand/collapse
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"ross_co" <ross_co@.discussions.microsoft.com> wrote in message
news:060EB67A-BB2E-47C3-8400-D088AEC095F1@.microsoft.com...
> Hello,
> I've searched the news group postings and have not found an answer. The
> question is:
> Is it possible to export a report from RS into excel and have the
> expand/collapse feature in excel work?
> Thanks,
> Ross|||I have 2 levels of drill down. The first level does expand/collapse. The
second level, the details, do not get exported unless that section was
already open in the report. I am using Excel XP.
Any ideas?
Thanks,
Neil
"Bruce L-C [MVP]" wrote:
> If your report has drill down the resulting Excel spreadsheet will have
> expand/collapse
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "ross_co" <ross_co@.discussions.microsoft.com> wrote in message
> news:060EB67A-BB2E-47C3-8400-D088AEC095F1@.microsoft.com...
> > Hello,
> >
> > I've searched the news group postings and have not found an answer. The
> > question is:
> >
> > Is it possible to export a report from RS into excel and have the
> > expand/collapse feature in excel work?
> >
> > Thanks,
> > Ross
>
>|||I got the same problem but with Excel 2003.
"Neil Gould" wrote:
> I have 2 levels of drill down. The first level does expand/collapse. The
> second level, the details, do not get exported unless that section was
> already open in the report. I am using Excel XP.
> Any ideas?
> Thanks,
> Neil
> "Bruce L-C [MVP]" wrote:
> > If your report has drill down the resulting Excel spreadsheet will have
> > expand/collapse
> >
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "ross_co" <ross_co@.discussions.microsoft.com> wrote in message
> > news:060EB67A-BB2E-47C3-8400-D088AEC095F1@.microsoft.com...
> > > Hello,
> > >
> > > I've searched the news group postings and have not found an answer. The
> > > question is:
> > >
> > > Is it possible to export a report from RS into excel and have the
> > > expand/collapse feature in excel work?
> > >
> > > Thanks,
> > > Ross
> >
> >
> >|||I have the same problem with RS2000 SP2, the drill down works on web, but
export to excel has no expand and collapse.
"Neil Gould" wrote:
> I have 2 levels of drill down. The first level does expand/collapse. The
> second level, the details, do not get exported unless that section was
> already open in the report. I am using Excel XP.
> Any ideas?
> Thanks,
> Neil
> "Bruce L-C [MVP]" wrote:
> > If your report has drill down the resulting Excel spreadsheet will have
> > expand/collapse
> >
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "ross_co" <ross_co@.discussions.microsoft.com> wrote in message
> > news:060EB67A-BB2E-47C3-8400-D088AEC095F1@.microsoft.com...
> > > Hello,
> > >
> > > I've searched the news group postings and have not found an answer. The
> > > question is:
> > >
> > > Is it possible to export a report from RS into excel and have the
> > > expand/collapse feature in excel work?
> > >
> > > Thanks,
> > > Ross
> >
> >
> >|||I'm having a similiar issue - We have a report where with 2 levels where the
top is collapsable. It's fine when you view the report, but when you export
the report to Excel, it no longer has the collapsable operation - it jus
tlists each sub-item with ########.
Any ideas?
"Bruce L-C [MVP]" wrote:
> If your report has drill down the resulting Excel spreadsheet will have
> expand/collapse
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "ross_co" <ross_co@.discussions.microsoft.com> wrote in message
> news:060EB67A-BB2E-47C3-8400-D088AEC095F1@.microsoft.com...
> > Hello,
> >
> > I've searched the news group postings and have not found an answer. The
> > question is:
> >
> > Is it possible to export a report from RS into excel and have the
> > expand/collapse feature in excel work?
> >
> > Thanks,
> > Ross
>
>|||Sorry, forgot to mention, this is for SRS 2005.