Adjusting Report width automatically

Hi All,

We are having a table report which has set of columns where the visibility is made false based on report parameters. It works fine and the table automatically shrinks. But, the page width remains as early and has lot of blank space in it. It also causes printer to print many blank pages.

Is there a way to control pagewidth dynamically? Thought of adding a custom assembly to control page width - but how to access the page that is getting displayed. "this" will refer to the the assembly class instead of report as such.

Any help is highly appreciated.

Regards, kart

Sizing is one of the few aspects of RS that cannot be controlled using expressions. Column widths are fixed and only row height supports auto sizing.

Paging is one of the last aspects of the rendering to be determined and it's also specific (and petentially different) to each rendering format. So HTML, Excel and PDF will all treat paging their own way. Hence I don't the possibility of there being an object that exposes a "CurrentPage" property in order to control it's properties at runtime. Maybe in future version MS will exposes some events raised by the renderers that you could hook into, but to my knowledge that's not available right now.

Hence the only way I see of achieveing what you suggest is to write your own rendering extension - which is not trivial - that handles the sizing of each page.

|||

You can try to change all the columns width to zero. (its not a good solution for export to excel but only to HTML)

Adjusting Report width automatically

Hi All,

We are having a table report which has set of columns where the visibility is made false based on report parameters. It works fine and the table automatically shrinks. But, the page width remains as early and has lot of blank space in it. It also causes printer to print many blank pages.

Is there a way to control pagewidth dynamically? Thought of adding a custom assembly to control page width - but how to access the page that is getting displayed. "this" will refer to the the assembly class instead of report as such.

Any help is highly appreciated.

Regards, kart

Sizing is one of the few aspects of RS that cannot be controlled using expressions. Column widths are fixed and only row height supports auto sizing.

Paging is one of the last aspects of the rendering to be determined and it's also specific (and petentially different) to each rendering format. So HTML, Excel and PDF will all treat paging their own way. Hence I don't the possibility of there being an object that exposes a "CurrentPage" property in order to control it's properties at runtime. Maybe in future version MS will exposes some events raised by the renderers that you could hook into, but to my knowledge that's not available right now.

Hence the only way I see of achieveing what you suggest is to write your own rendering extension - which is not trivial - that handles the sizing of each page.

|||

You can try to change all the columns width to zero. (its not a good solution for export to excel but only to HTML)

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

Adding C++ var into db

Since the SQL server doesn't have visibility to internal
C++ variables in an application, the variables need to be
passed to the server somehow. There are a variety of ways
of doing this including converting the value to text and
stuffing it in the query string. A better way is to use
the API's parameter passing functions (i.e. for ODBC this
is SQLBindParameter).
Cheers
Mitch vH
Microsoft Consulting

>--Original Message--
>What is the syntax of adding C++ variables into SQL
Server/mySQL?
>Could anyone raise an example?
>I've tried
>insert into aTable (field1, field2) values (variable1,
variable2)
>But mySQL throws error messages at me saying varible1 is
not in the field
>list. Haven't tried it yet for SQL Server..
>Thanks for your attention
>Jack
>
>.
>
Hi Mitch,
Nice to meet you. According to your message, I'd like to know if you can
raise an example for me to reference. Thanks
Jack
"Mitch" <anonymous@.discussions.microsoft.com>
??:537a01c42cd1$c241b690$a301280a@.phx.gbl...[vbcol=seagreen]
> Since the SQL server doesn't have visibility to internal
> C++ variables in an application, the variables need to be
> passed to the server somehow. There are a variety of ways
> of doing this including converting the value to text and
> stuffing it in the query string. A better way is to use
> the API's parameter passing functions (i.e. for ODBC this
> is SQLBindParameter).
> Cheers
> Mitch vH
> Microsoft Consulting
> Server/mySQL?
> variable2)
> not in the field
|||Hi,
I've just asked other guys. They said to convert integers into varchars
using sprintf then stuffing it into the SQLStr. I'm in doubt about the
necessarity of this move because the field I designed was an integer field.
Could anyone explain?
Thanks
Jack
"Jack" <jl@.knight.com> glsD
:Oim1KPNLEHA.2624@.TK2MSFTNGP09.phx.gbl...
> Hi Mitch,
> Nice to meet you. According to your message, I'd like to know if you can
> raise an example for me to reference. Thanks
> Jack
> "Mitch" <anonymous@.discussions.microsoft.com>
> ??:537a01c42cd1$c241b690$a301280a@.phx.gbl...
>

Adding C++ var into db

Since the SQL server doesn't have visibility to internal
C++ variables in an application, the variables need to be
passed to the server somehow. There are a variety of ways
of doing this including converting the value to text and
stuffing it in the query string. A better way is to use
the API's parameter passing functions (i.e. for ODBC this
is SQLBindParameter).
Cheers
Mitch vH
Microsoft Consulting

>--Original Message--
>What is the syntax of adding C++ variables into SQL
Server/mySQL?
>Could anyone raise an example?
>I've tried
>insert into aTable (field1, field2) values (variable1,
variable2)
>But mysql throws error messages at me saying varible1 is
not in the field
>list. Haven't tried it yet for SQL Server..
>Thanks for your attention
>Jack
>
>.
>Hi Mitch,
Nice to meet you. According to your message, I'd like to know if you can
raise an example for me to reference. Thanks
Jack
"Mitch" <anonymous@.discussions.microsoft.com>
'?:537a01c42cd1$c241b690$a301280a@.phx.gbl...[vbcol=seagreen]
> Since the SQL server doesn't have visibility to internal
> C++ variables in an application, the variables need to be
> passed to the server somehow. There are a variety of ways
> of doing this including converting the value to text and
> stuffing it in the query string. A better way is to use
> the API's parameter passing functions (i.e. for ODBC this
> is SQLBindParameter).
> Cheers
> Mitch vH
> Microsoft Consulting
>
> Server/mySQL?
> variable2)
> not in the field|||Hi,
I've just asked other guys. They said to convert integers into varchars
using sprintf then stuffing it into the SQLStr. I'm in doubt about the
necessarity of this move because the field I designed was an integer field.
Could anyone explain?
Thanks
Jack
"Jack" <jl@.knight.com> glsD
:Oim1KPNLEHA.2624@.TK2MSFTNGP09.phx.gbl...
> Hi Mitch,
> Nice to meet you. According to your message, I'd like to know if you can
> raise an example for me to reference. Thanks
> Jack
> "Mitch" <anonymous@.discussions.microsoft.com>
> '?:537a01c42cd1$c241b690$a301280a@.phx.gbl...
>