exporting multiple rows

I'm trying to set up a row that has 5 rows below it and when you click on the + it'll expand to show the five lines.

They're all set up to toggle based on the one row. It works online, but when I try to export it to anything, it only picks up the first detail row and leaves off the rest. I'm doing this for a bunch of reports, and they're all being emailed using subscriptions.

I've moved the detail rows around but each time it's just the first detail row that is exported.

Any ideas?

thx,

M@.

mattcushing@.gmail.com(noSpam)

Hello,

What formats are you trying to export to? Toggleable visibility is only supported in a few rendering extensions (HTML, Winforms, and in some cases Excel).

When you export to PDF or Image, those renderers honor the toggle state at the time the file is exported. So, if you have all of your toggleable items collapsed and then export to PDF you will only see the collapsed representation.

-Chris

sql

Exporting a Drill-Down to PDF

We're trying to export a report that has drill-down information in it to PDF.
Whenever we do export it, the pdf does not expand the drill-downs for us,
which is useless. Is there a work around or any suggestions, please.
Thank youExporting to PDF should mirror what you see in HTML. Are you saying that
you've expanded sections in HTML and the exported PDF shows these as
collapsed?
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Cooper" <Cooper@.discussions.microsoft.com> wrote in message
news:933ACF35-0292-4CF1-9673-F2CE787FA640@.microsoft.com...
> We're trying to export a report that has drill-down information in it to
> PDF.
> Whenever we do export it, the pdf does not expand the drill-downs for us,
> which is useless. Is there a work around or any suggestions, please.
>
> Thank you|||Exactly, the report expands three times
1.
a.
i.
ii
b.
i.
ii.
2.
a.
etc...
But the export to PDF shows it all collapsed regardless of what is actually
expanded.
"Donovan Smith [MSFT]" wrote:
> Exporting to PDF should mirror what you see in HTML. Are you saying that
> you've expanded sections in HTML and the exported PDF shows these as
> collapsed?
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Cooper" <Cooper@.discussions.microsoft.com> wrote in message
> news:933ACF35-0292-4CF1-9673-F2CE787FA640@.microsoft.com...
> > We're trying to export a report that has drill-down information in it to
> > PDF.
> > Whenever we do export it, the pdf does not expand the drill-downs for us,
> > which is useless. Is there a work around or any suggestions, please.
> >
> >
> > Thank you
>
>|||Hmmm. What does an export to TIFF show?
What version of Reporting Services are you using?
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Cooper" <Cooper@.discussions.microsoft.com> wrote in message
news:D4E4EB36-0911-4907-AC25-04DB1381AEF4@.microsoft.com...
> Exactly, the report expands three times
> 1.
> a.
> i.
> ii
> b.
> i.
> ii.
> 2.
> a.
>
> etc...
> But the export to PDF shows it all collapsed regardless of what is
> actually
> expanded.
> "Donovan Smith [MSFT]" wrote:
>> Exporting to PDF should mirror what you see in HTML. Are you saying that
>> you've expanded sections in HTML and the exported PDF shows these as
>> collapsed?
>> --
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Cooper" <Cooper@.discussions.microsoft.com> wrote in message
>> news:933ACF35-0292-4CF1-9673-F2CE787FA640@.microsoft.com...
>> > We're trying to export a report that has drill-down information in it
>> > to
>> > PDF.
>> > Whenever we do export it, the pdf does not expand the drill-downs for
>> > us,
>> > which is useless. Is there a work around or any suggestions, please.
>> >
>> >
>> > Thank you
>>|||The tiff renders whatever the report is currently displaying. I am using RS
2000 SP 2. I am not actually in front of the system for the actual version
number, but we have been running SP 2 for quite some time. We actually are
having to go back and start making "emergency" no drill-down versions of
these reports.
"Donovan Smith [MSFT]" wrote:
> Hmmm. What does an export to TIFF show?
> What version of Reporting Services are you using?
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Cooper" <Cooper@.discussions.microsoft.com> wrote in message
> news:D4E4EB36-0911-4907-AC25-04DB1381AEF4@.microsoft.com...
> > Exactly, the report expands three times
> >
> > 1.
> > a.
> > i.
> > ii
> > b.
> > i.
> > ii.
> > 2.
> > a.
> >
> >
> > etc...
> >
> > But the export to PDF shows it all collapsed regardless of what is
> > actually
> > expanded.
> >
> > "Donovan Smith [MSFT]" wrote:
> >
> >> Exporting to PDF should mirror what you see in HTML. Are you saying that
> >> you've expanded sections in HTML and the exported PDF shows these as
> >> collapsed?
> >>
> >> --
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >>
> >> "Cooper" <Cooper@.discussions.microsoft.com> wrote in message
> >> news:933ACF35-0292-4CF1-9673-F2CE787FA640@.microsoft.com...
> >> > We're trying to export a report that has drill-down information in it
> >> > to
> >> > PDF.
> >> > Whenever we do export it, the pdf does not expand the drill-downs for
> >> > us,
> >> > which is useless. Is there a work around or any suggestions, please.
> >> >
> >> >
> >> > Thank you
> >>
> >>
> >>
>
>|||Would you please email me a copy of your .rdl and .rdl.data file? I'd like
to take a look. The TIFF and PDF renderings should both reflect what is
shown in IE. Does this repro using another ccomputer as the client?
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Cooper" <Cooper@.discussions.microsoft.com> wrote in message
news:3565C48E-00C3-4EED-83BB-3F1F43D05681@.microsoft.com...
> The tiff renders whatever the report is currently displaying. I am using
> RS
> 2000 SP 2. I am not actually in front of the system for the actual version
> number, but we have been running SP 2 for quite some time. We actually are
> having to go back and start making "emergency" no drill-down versions of
> these reports.
> "Donovan Smith [MSFT]" wrote:
>> Hmmm. What does an export to TIFF show?
>> What version of Reporting Services are you using?
>> --
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Cooper" <Cooper@.discussions.microsoft.com> wrote in message
>> news:D4E4EB36-0911-4907-AC25-04DB1381AEF4@.microsoft.com...
>> > Exactly, the report expands three times
>> >
>> > 1.
>> > a.
>> > i.
>> > ii
>> > b.
>> > i.
>> > ii.
>> > 2.
>> > a.
>> >
>> >
>> > etc...
>> >
>> > But the export to PDF shows it all collapsed regardless of what is
>> > actually
>> > expanded.
>> >
>> > "Donovan Smith [MSFT]" wrote:
>> >
>> >> Exporting to PDF should mirror what you see in HTML. Are you saying
>> >> that
>> >> you've expanded sections in HTML and the exported PDF shows these as
>> >> collapsed?
>> >>
>> >> --
>> >> This posting is provided "AS IS" with no warranties, and confers no
>> >> rights.
>> >>
>> >>
>> >> "Cooper" <Cooper@.discussions.microsoft.com> wrote in message
>> >> news:933ACF35-0292-4CF1-9673-F2CE787FA640@.microsoft.com...
>> >> > We're trying to export a report that has drill-down information in
>> >> > it
>> >> > to
>> >> > PDF.
>> >> > Whenever we do export it, the pdf does not expand the drill-downs
>> >> > for
>> >> > us,
>> >> > which is useless. Is there a work around or any suggestions, please.
>> >> >
>> >> >
>> >> > Thank you
>> >>
>> >>
>> >>
>>

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.