Adding visibility toggle to a table group

Hi!
I'm trying to add a visibility toggle to a table group in my report. The
table has one main group and a subgroup. I want to hide initially details
from the subgroup. So I changed the visibility property of this subgroup to
"Hidden" and then choosed that visibility can be toggled by another report
item (which is in my case a textbox containing the name of a subgroup in the
subgroup header). When I generated this report in Excel-format I got 2 spread
sheets: a Document map containing links with the names o my subgroups and a
report without '+/-' toggle boxes. Is it something I'm doing wrong?I didn't see anything wrong. Can you reproduce this issue by creating a new
report which uses the sample database Adventureworks2000 as its data
source? If you can repro, please post the exact steps and then we'll be
able to investigate this issue further.
Also, if you export the sample report "Territory Sales Drilldown" to an
Excel file, do you still have this issue?
What service pack level is your RS at?
Sincerely,
William Wang
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
This posting is provided "AS IS" with no warranties, and confers no rights.
--
>Thread-Topic: Adding visibility toggle to a table group
>thread-index: AcVUm584XIOzJcqORpunHlK8qwgPdg==>X-WBNR-Posting-Host: 62.97.217.178
>From: "=?Utf-8?B?QW5uYQ==?=" <mercatus2004@.online.nospam>
>Subject: Adding visibility toggle to a table group
>Date: Mon, 9 May 2005 06:33:01 -0700
>Lines: 10
>Message-ID: <859FB97C-86DE-47F7-AFB7-0F595B90C040@.microsoft.com>
>MIME-Version: 1.0
>Content-Type: text/plain;
> charset="Utf-8"
>Content-Transfer-Encoding: 7bit
>X-Newsreader: Microsoft CDO for Windows 2000
>Content-Class: urn:content-classes:message
>Importance: normal
>Priority: normal
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
>Newsgroups: microsoft.public.sqlserver.reportingsvcs
>NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:43164
>X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
>Hi!
>I'm trying to add a visibility toggle to a table group in my report. The
>table has one main group and a subgroup. I want to hide initially details
>from the subgroup. So I changed the visibility property of this subgroup
to
>"Hidden" and then choosed that visibility can be toggled by another report
>item (which is in my case a textbox containing the name of a subgroup in
the
>subgroup header). When I generated this report in Excel-format I got 2
spread
>sheets: a Document map containing links with the names o my subgroups and
a
>report without '+/-' toggle boxes. Is it something I'm doing wrong?
>|||Thank you for your answer.
I compared my report with "Territory Sales Drilldown", it uses query string
as datasource and performs grouping there, while I'm using a stored
procedure. Territory sales drilldown report works fine. Does it mean that for
getting this toggle-functionality I have to use query string?
I'm using Service Pack 2 in my reporting services.
Regards,
Anna
"William Wang[MSFT]" wrote:
> I didn't see anything wrong. Can you reproduce this issue by creating a new
> report which uses the sample database Adventureworks2000 as its data
> source? If you can repro, please post the exact steps and then we'll be
> able to investigate this issue further.
> Also, if you export the sample report "Territory Sales Drilldown" to an
> Excel file, do you still have this issue?
> What service pack level is your RS at?
> Sincerely,
> William Wang
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> This posting is provided "AS IS" with no warranties, and confers no rights.
> --
> >Thread-Topic: Adding visibility toggle to a table group
> >thread-index: AcVUm584XIOzJcqORpunHlK8qwgPdg==> >X-WBNR-Posting-Host: 62.97.217.178
> >From: "=?Utf-8?B?QW5uYQ==?=" <mercatus2004@.online.nospam>
> >Subject: Adding visibility toggle to a table group
> >Date: Mon, 9 May 2005 06:33:01 -0700
> >Lines: 10
> >Message-ID: <859FB97C-86DE-47F7-AFB7-0F595B90C040@.microsoft.com>
> >MIME-Version: 1.0
> >Content-Type: text/plain;
> > charset="Utf-8"
> >Content-Transfer-Encoding: 7bit
> >X-Newsreader: Microsoft CDO for Windows 2000
> >Content-Class: urn:content-classes:message
> >Importance: normal
> >Priority: normal
> >X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> >Newsgroups: microsoft.public.sqlserver.reportingsvcs
> >NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
> >Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
> >Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:43164
> >X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> >
> >Hi!
> >I'm trying to add a visibility toggle to a table group in my report. The
> >table has one main group and a subgroup. I want to hide initially details
> >from the subgroup. So I changed the visibility property of this subgroup
> to
> >"Hidden" and then choosed that visibility can be toggled by another report
> >item (which is in my case a textbox containing the name of a subgroup in
> the
> >subgroup header). When I generated this report in Excel-format I got 2
> spread
> >sheets: a Document map containing links with the names o my subgroups and
> a
> >report without '+/-' toggle boxes. Is it something I'm doing wrong?
> >
> >
>|||Hi Anna,
I don't think you have to use a query string as the dataset. In the sample
db Adventureworks2000, I created a stored procedure and use it as the
dataset for the "Territory Sales Drilldown" report, deployed it and then
exported the report to an Excel file, the report still worked fine.
Therefore I believe this issue is specific to your report. Can you managed
to create another report using Adventureworks2000 as its data source and
reproduce this issue? You can then send the report to me so that I will
able to test this issue on my end and see find out what has been wrong. My
e-mail address is v-rxwang@.microsoft.com.
Sincerely,
William Wang
Microsoft Online Partner Support
This posting is provided "AS IS" with no warranties, and confers no rights.
--
>Thread-Topic: Adding visibility toggle to a table group
>thread-index: AcVVb0YGcz2tQamgShu62D42ca+yyA==>X-WBNR-Posting-Host: 62.97.217.178
>From: "=?Utf-8?B?QW5uYQ==?=" <mercatus2004@.online.nospam>
>References: <859FB97C-86DE-47F7-AFB7-0F595B90C040@.microsoft.com>
<9rqBBERVFHA.3052@.TK2MSFTNGXA01.phx.gbl>
>Subject: RE: Adding visibility toggle to a table group
>Date: Tue, 10 May 2005 07:48:05 -0700
>Lines: 77
>Message-ID: <0E31FF65-52E9-43D8-B395-EF13AE6A77C8@.microsoft.com>
>MIME-Version: 1.0
>Content-Type: text/plain;
> charset="Utf-8"
>Content-Transfer-Encoding: 7bit
>X-Newsreader: Microsoft CDO for Windows 2000
>Content-Class: urn:content-classes:message
>Importance: normal
>Priority: normal
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
>Newsgroups: microsoft.public.sqlserver.reportingsvcs
>NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:43296
>X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
>Thank you for your answer.
>I compared my report with "Territory Sales Drilldown", it uses query
string
>as datasource and performs grouping there, while I'm using a stored
>procedure. Territory sales drilldown report works fine. Does it mean that
for
>getting this toggle-functionality I have to use query string?
>I'm using Service Pack 2 in my reporting services.
>Regards,
>Anna
>
>"William Wang[MSFT]" wrote:
>> I didn't see anything wrong. Can you reproduce this issue by creating a
new
>> report which uses the sample database Adventureworks2000 as its data
>> source? If you can repro, please post the exact steps and then we'll be
>> able to investigate this issue further.
>> Also, if you export the sample report "Territory Sales Drilldown" to an
>> Excel file, do you still have this issue?
>> What service pack level is your RS at?
>> Sincerely,
>> William Wang
>> Microsoft Online Partner Support
>> When responding to posts, please "Reply to Group" via your newsreader so
>> that others may learn and benefit from your issue.
>> This posting is provided "AS IS" with no warranties, and confers no
rights.
>> --
>> >Thread-Topic: Adding visibility toggle to a table group
>> >thread-index: AcVUm584XIOzJcqORpunHlK8qwgPdg==>> >X-WBNR-Posting-Host: 62.97.217.178
>> >From: "=?Utf-8?B?QW5uYQ==?=" <mercatus2004@.online.nospam>
>> >Subject: Adding visibility toggle to a table group
>> >Date: Mon, 9 May 2005 06:33:01 -0700
>> >Lines: 10
>> >Message-ID: <859FB97C-86DE-47F7-AFB7-0F595B90C040@.microsoft.com>
>> >MIME-Version: 1.0
>> >Content-Type: text/plain;
>> > charset="Utf-8"
>> >Content-Transfer-Encoding: 7bit
>> >X-Newsreader: Microsoft CDO for Windows 2000
>> >Content-Class: urn:content-classes:message
>> >Importance: normal
>> >Priority: normal
>> >X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
>> >Newsgroups: microsoft.public.sqlserver.reportingsvcs
>> >NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
>> >Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
>> >Xref: TK2MSFTNGXA01.phx.gbl
microsoft.public.sqlserver.reportingsvcs:43164
>> >X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
>> >
>> >Hi!
>> >I'm trying to add a visibility toggle to a table group in my report.
The
>> >table has one main group and a subgroup. I want to hide initially
details
>> >from the subgroup. So I changed the visibility property of this
subgroup
>> to
>> >"Hidden" and then choosed that visibility can be toggled by another
report
>> >item (which is in my case a textbox containing the name of a subgroup
in
>> the
>> >subgroup header). When I generated this report in Excel-format I got 2
>> spread
>> >sheets: a Document map containing links with the names o my subgroups
and
>> a
>> >report without '+/-' toggle boxes. Is it something I'm doing wrong?
>> >
>> >
>>
>|||Hei William!
I've also created a stored procedure in db Adventureworks2000 and then
created a report based on that. It works fine when I run it in preview, but
not when I exporting it to Excel. I send you the project to your mail
address, so you can see what I'm doing wtrong.
"William Wang[MSFT]" wrote:
> Hi Anna,
> I don't think you have to use a query string as the dataset. In the sample
> db Adventureworks2000, I created a stored procedure and use it as the
> dataset for the "Territory Sales Drilldown" report, deployed it and then
> exported the report to an Excel file, the report still worked fine.
> Therefore I believe this issue is specific to your report. Can you managed
> to create another report using Adventureworks2000 as its data source and
> reproduce this issue? You can then send the report to me so that I will
> able to test this issue on my end and see find out what has been wrong. My
> e-mail address is v-rxwang@.microsoft.com.
> Sincerely,
> William Wang
> Microsoft Online Partner Support
> This posting is provided "AS IS" with no warranties, and confers no rights.
> --
> >Thread-Topic: Adding visibility toggle to a table group
> >thread-index: AcVVb0YGcz2tQamgShu62D42ca+yyA==> >X-WBNR-Posting-Host: 62.97.217.178
> >From: "=?Utf-8?B?QW5uYQ==?=" <mercatus2004@.online.nospam>
> >References: <859FB97C-86DE-47F7-AFB7-0F595B90C040@.microsoft.com>
> <9rqBBERVFHA.3052@.TK2MSFTNGXA01.phx.gbl>
> >Subject: RE: Adding visibility toggle to a table group
> >Date: Tue, 10 May 2005 07:48:05 -0700
> >Lines: 77
> >Message-ID: <0E31FF65-52E9-43D8-B395-EF13AE6A77C8@.microsoft.com>
> >MIME-Version: 1.0
> >Content-Type: text/plain;
> > charset="Utf-8"
> >Content-Transfer-Encoding: 7bit
> >X-Newsreader: Microsoft CDO for Windows 2000
> >Content-Class: urn:content-classes:message
> >Importance: normal
> >Priority: normal
> >X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> >Newsgroups: microsoft.public.sqlserver.reportingsvcs
> >NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
> >Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
> >Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:43296
> >X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> >
> >Thank you for your answer.
> >
> >I compared my report with "Territory Sales Drilldown", it uses query
> string
> >as datasource and performs grouping there, while I'm using a stored
> >procedure. Territory sales drilldown report works fine. Does it mean that
> for
> >getting this toggle-functionality I have to use query string?
> >
> >I'm using Service Pack 2 in my reporting services.
> >
> >Regards,
> >
> >Anna
> >
> >
> >"William Wang[MSFT]" wrote:
> >
> >> I didn't see anything wrong. Can you reproduce this issue by creating a
> new
> >> report which uses the sample database Adventureworks2000 as its data
> >> source? If you can repro, please post the exact steps and then we'll be
> >> able to investigate this issue further.
> >>
> >> Also, if you export the sample report "Territory Sales Drilldown" to an
> >> Excel file, do you still have this issue?
> >>
> >> What service pack level is your RS at?
> >>
> >> Sincerely,
> >>
> >> William Wang
> >> Microsoft Online Partner Support
> >>
> >> When responding to posts, please "Reply to Group" via your newsreader so
> >> that others may learn and benefit from your issue.
> >>
> >> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> >>
> >> --
> >> >Thread-Topic: Adding visibility toggle to a table group
> >> >thread-index: AcVUm584XIOzJcqORpunHlK8qwgPdg==> >> >X-WBNR-Posting-Host: 62.97.217.178
> >> >From: "=?Utf-8?B?QW5uYQ==?=" <mercatus2004@.online.nospam>
> >> >Subject: Adding visibility toggle to a table group
> >> >Date: Mon, 9 May 2005 06:33:01 -0700
> >> >Lines: 10
> >> >Message-ID: <859FB97C-86DE-47F7-AFB7-0F595B90C040@.microsoft.com>
> >> >MIME-Version: 1.0
> >> >Content-Type: text/plain;
> >> > charset="Utf-8"
> >> >Content-Transfer-Encoding: 7bit
> >> >X-Newsreader: Microsoft CDO for Windows 2000
> >> >Content-Class: urn:content-classes:message
> >> >Importance: normal
> >> >Priority: normal
> >> >X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> >> >Newsgroups: microsoft.public.sqlserver.reportingsvcs
> >> >NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
> >> >Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
> >> >Xref: TK2MSFTNGXA01.phx.gbl
> microsoft.public.sqlserver.reportingsvcs:43164
> >> >X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> >> >
> >> >Hi!
> >> >I'm trying to add a visibility toggle to a table group in my report.
> The
> >> >table has one main group and a subgroup. I want to hide initially
> details
> >> >from the subgroup. So I changed the visibility property of this
> subgroup
> >> to
> >> >"Hidden" and then choosed that visibility can be toggled by another
> report
> >> >item (which is in my case a textbox containing the name of a subgroup
> in
> >> the
> >> >subgroup header). When I generated this report in Excel-format I got 2
> >> spread
> >> >sheets: a Document map containing links with the names o my subgroups
> and
> >> a
> >> >report without '+/-' toggle boxes. Is it something I'm doing wrong?
> >> >
> >> >
> >>
> >>
> >
>|||Hi Anna,
From your report, I see that you have correctly set the Visibility
properties (Hidden and ToggleItem) of the Sales_SalesPerson Header and the
Detail row. However, for each of the two rows, click its row handler, and
then click Edit Group. On the Visibility tab, there are incorrect settings.
You just want to choose the Visible option under "Initial visibility" and
clear the "Visibility can be toggled by another report item" check box.
After that, save the report to an Excel file. This time the Excel file
should be fine.
Feel free to let me know if anything is unclear.
Sincerely,
William Wang
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
This posting is provided "AS IS" with no warranties, and confers no rights.
--
>Thread-Topic: Adding visibility toggle to a table group
>thread-index: AcVWBmyJjdj51eYgT8OKveDvIzn2oA==>X-WBNR-Posting-Host: 62.97.217.178
>From: "=?Utf-8?B?QW5uYQ==?=" <mercatus2004@.online.nospam>
>References: <859FB97C-86DE-47F7-AFB7-0F595B90C040@.microsoft.com>
<9rqBBERVFHA.3052@.TK2MSFTNGXA01.phx.gbl>
<0E31FF65-52E9-43D8-B395-EF13AE6A77C8@.microsoft.com>
<4dmYVsdVFHA.3928@.TK2MSFTNGXA01.phx.gbl>
>Subject: RE: Adding visibility toggle to a table group
>Date: Wed, 11 May 2005 01:50:04 -0700
>Lines: 144
>Message-ID: <F4A9DDEC-E0FB-4FAB-8C2C-13AC07DEFAD1@.microsoft.com>
>MIME-Version: 1.0
>Content-Type: text/plain;
> charset="Utf-8"
>Content-Transfer-Encoding: 7bit
>X-Newsreader: Microsoft CDO for Windows 2000
>Content-Class: urn:content-classes:message
>Importance: normal
>Priority: normal
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
>Newsgroups: microsoft.public.sqlserver.reportingsvcs
>NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGXA03.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:43397
>X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
>Hei William!
>I've also created a stored procedure in db Adventureworks2000 and then
>created a report based on that. It works fine when I run it in preview,
but
>not when I exporting it to Excel. I send you the project to your mail
>address, so you can see what I'm doing wtrong.
>"William Wang[MSFT]" wrote:
>> Hi Anna,
>> I don't think you have to use a query string as the dataset. In the
sample
>> db Adventureworks2000, I created a stored procedure and use it as the
>> dataset for the "Territory Sales Drilldown" report, deployed it and then
>> exported the report to an Excel file, the report still worked fine.
>> Therefore I believe this issue is specific to your report. Can you
managed
>> to create another report using Adventureworks2000 as its data source and
>> reproduce this issue? You can then send the report to me so that I will
>> able to test this issue on my end and see find out what has been wrong.
My
>> e-mail address is v-rxwang@.microsoft.com.
>> Sincerely,
>> William Wang
>> Microsoft Online Partner Support
>> This posting is provided "AS IS" with no warranties, and confers no
rights.
>> --
>> >Thread-Topic: Adding visibility toggle to a table group
>> >thread-index: AcVVb0YGcz2tQamgShu62D42ca+yyA==>> >X-WBNR-Posting-Host: 62.97.217.178
>> >From: "=?Utf-8?B?QW5uYQ==?=" <mercatus2004@.online.nospam>
>> >References: <859FB97C-86DE-47F7-AFB7-0F595B90C040@.microsoft.com>
>> <9rqBBERVFHA.3052@.TK2MSFTNGXA01.phx.gbl>
>> >Subject: RE: Adding visibility toggle to a table group
>> >Date: Tue, 10 May 2005 07:48:05 -0700
>> >Lines: 77
>> >Message-ID: <0E31FF65-52E9-43D8-B395-EF13AE6A77C8@.microsoft.com>
>> >MIME-Version: 1.0
>> >Content-Type: text/plain;
>> > charset="Utf-8"
>> >Content-Transfer-Encoding: 7bit
>> >X-Newsreader: Microsoft CDO for Windows 2000
>> >Content-Class: urn:content-classes:message
>> >Importance: normal
>> >Priority: normal
>> >X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
>> >Newsgroups: microsoft.public.sqlserver.reportingsvcs
>> >NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
>> >Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
>> >Xref: TK2MSFTNGXA01.phx.gbl
microsoft.public.sqlserver.reportingsvcs:43296
>> >X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
>> >
>> >Thank you for your answer.
>> >
>> >I compared my report with "Territory Sales Drilldown", it uses query
>> string
>> >as datasource and performs grouping there, while I'm using a stored
>> >procedure. Territory sales drilldown report works fine. Does it mean
that
>> for
>> >getting this toggle-functionality I have to use query string?
>> >
>> >I'm using Service Pack 2 in my reporting services.
>> >
>> >Regards,
>> >
>> >Anna
>> >
>> >
>> >"William Wang[MSFT]" wrote:
>> >
>> >> I didn't see anything wrong. Can you reproduce this issue by creating
a
>> new
>> >> report which uses the sample database Adventureworks2000 as its data
>> >> source? If you can repro, please post the exact steps and then we'll
be
>> >> able to investigate this issue further.
>> >>
>> >> Also, if you export the sample report "Territory Sales Drilldown" to
an
>> >> Excel file, do you still have this issue?
>> >>
>> >> What service pack level is your RS at?
>> >>
>> >> Sincerely,
>> >>
>> >> William Wang
>> >> Microsoft Online Partner Support
>> >>
>> >> When responding to posts, please "Reply to Group" via your newsreader
so
>> >> that others may learn and benefit from your issue.
>> >>
>> >> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> >>
>> >> --
>> >> >Thread-Topic: Adding visibility toggle to a table group
>> >> >thread-index: AcVUm584XIOzJcqORpunHlK8qwgPdg==>> >> >X-WBNR-Posting-Host: 62.97.217.178
>> >> >From: "=?Utf-8?B?QW5uYQ==?=" <mercatus2004@.online.nospam>
>> >> >Subject: Adding visibility toggle to a table group
>> >> >Date: Mon, 9 May 2005 06:33:01 -0700
>> >> >Lines: 10
>> >> >Message-ID: <859FB97C-86DE-47F7-AFB7-0F595B90C040@.microsoft.com>
>> >> >MIME-Version: 1.0
>> >> >Content-Type: text/plain;
>> >> > charset="Utf-8"
>> >> >Content-Transfer-Encoding: 7bit
>> >> >X-Newsreader: Microsoft CDO for Windows 2000
>> >> >Content-Class: urn:content-classes:message
>> >> >Importance: normal
>> >> >Priority: normal
>> >> >X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
>> >> >Newsgroups: microsoft.public.sqlserver.reportingsvcs
>> >> >NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
>> >> >Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
>> >> >Xref: TK2MSFTNGXA01.phx.gbl
>> microsoft.public.sqlserver.reportingsvcs:43164
>> >> >X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
>> >> >
>> >> >Hi!
>> >> >I'm trying to add a visibility toggle to a table group in my report.
>> The
>> >> >table has one main group and a subgroup. I want to hide initially
>> details
>> >> >from the subgroup. So I changed the visibility property of this
>> subgroup
>> >> to
>> >> >"Hidden" and then choosed that visibility can be toggled by another
>> report
>> >> >item (which is in my case a textbox containing the name of a
subgroup
>> in
>> >> the
>> >> >subgroup header). When I generated this report in Excel-format I got
2
>> >> spread
>> >> >sheets: a Document map containing links with the names o my
subgroups
>> and
>> >> a
>> >> >report without '+/-' toggle boxes. Is it something I'm doing wrong?
>> >> >
>> >> >
>> >>
>> >>
>> >
>>
>sql