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

Export to excel problem

Hi,

I have a tabular report that has a toggle(collapsible item) in the details area. The toggle works fine in the report designer but when I export it to excel, the toggle is not exported. Are there some properties that I missed configuring?

Thanks!

Do you have other table rows between details and the row with the toggle? If this is the case, we cannot generate the outlines in Excel since Excel requires the rows to be consecutive.

Thank you,

Nico

|||

We had no problem when we use Reporting Services Standard edition. But after we installed Reporting Service SP2, we got the same problem as you. Unfortunately, I don't have solution yet.

Do you have Reporting Services SP2 installed?

Please let me know.

Alison

|||Did you set the visibility of the table to some expression? If so, just set to visible or hidden, then the toggle will be exported in Excel.

Export to excel problem

Hi,

I have a tabular report that has a toggle(collapsible item) in the details area. The toggle works fine in the report designer but when I export it to excel, the toggle is not exported. Are there some properties that I missed configuring?

Thanks!

Do you have other table rows between details and the row with the toggle? If this is the case, we cannot generate the outlines in Excel since Excel requires the rows to be consecutive.

Thank you,

Nico

|||

We had no problem when we use Reporting Services Standard edition. But after we installed Reporting Service SP2, we got the same problem as you. Unfortunately, I don't have solution yet.

Do you have Reporting Services SP2 installed?

Please let me know.

Alison

|||Did you set the visibility of the table to some expression? If so, just set to visible or hidden, then the toggle will be exported in Excel.

Export to excel problem

Hi,

I have a tabular report that has a toggle(collapsible item) in the details area. The toggle works fine in the report designer but when I export it to excel, the toggle is not exported. Are there some properties that I missed configuring?

Thanks!

Do you have other table rows between details and the row with the toggle? If this is the case, we cannot generate the outlines in Excel since Excel requires the rows to be consecutive.

Thank you,

Nico

|||

We had no problem when we use Reporting Services Standard edition. But after we installed Reporting Service SP2, we got the same problem as you. Unfortunately, I don't have solution yet.

Do you have Reporting Services SP2 installed?

Please let me know.

Alison

|||Did you set the visibility of the table to some expression? If so, just set to visible or hidden, then the toggle will be exported in Excel.

export to exce1

I am using subreport techique to include in my report layout. I can see all
the report and subreport (by clicking the toggle key) from the internet
browser. After exporting to EXCEL format, i can't see the subreport items.
What went wrong'
Thanks.What version/service pack are you using? Is your subreport contained in a
table?
--
Andy Potter
blog : http://sqlreportingservices.spaces.live.com
info@.(NOSPAM)lakeclaireenterprises.com
"Theresa" <Theresa@.discussions.microsoft.com> wrote in message
news:94D59D45-FE59-4B88-8FE0-7A33080AFD31@.microsoft.com...
>I am using subreport techique to include in my report layout. I can see
>all
> the report and subreport (by clicking the toggle key) from the internet
> browser. After exporting to EXCEL format, i can't see the subreport
> items.
> What went wrong'
> Thanks.|||Hi Andy,
Thanks for your email.
I am using SQL 2005 (version 9.00.1399.00) and Excel 2003 SP2. The subreport
is contained in the detailed row of my table. This subreport is perfected
for my application, it return different number of rows and with hidden
property set to true. Each time click the toggle key it display the result
from the subreport. Unfortunately, it just could not display the contents of
the subreport when exported to Excel. Thanks for your attention. And would
like to hear your response.
"Andy Potter" wrote:
> What version/service pack are you using? Is your subreport contained in a
> table?
> --
> Andy Potter
> blog : http://sqlreportingservices.spaces.live.com
> info@.(NOSPAM)lakeclaireenterprises.com
> "Theresa" <Theresa@.discussions.microsoft.com> wrote in message
> news:94D59D45-FE59-4B88-8FE0-7A33080AFD31@.microsoft.com...
> >I am using subreport techique to include in my report layout. I can see
> >all
> > the report and subreport (by clicking the toggle key) from the internet
> > browser. After exporting to EXCEL format, i can't see the subreport
> > items.
> > What went wrong'
> > Thanks.
>
>