Hello David,
Report items can be hidden from the user viewing the report. You can hide
them from view when the report is rendered in HTML, you can cause a report
item to toggle between visible and hidden when the user clicks on another
report item, or you can hide them based on the contents of other report
items. You can hide any report item, including groups, columns, or rows in
a table or matrix. You can also define matrices that contain static and
dynamic rows and columns. When the report runs, dynamic column headers
expand right for as many columns as there are groups. They can instead
expand to the left if the Direction property of the matrix is set to RTL.
Hidden report items render differently when exporting into Excel depending
on the data region type being hidden.
For example, if you use Matrix, please try the following steps to show all
groups.
1. In Visual Studio, and open the report in layout mode
2. Right click a Group cell on column/row->Edit Group->Visiblity
3. Make sure Initial visiblity option is "Visible"
Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
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.
=====================================================
Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN outages or "business down"
situations. This benefit is available 24 hours a day, 7 days a week to all
Microsoft technology partners in the United States and Canada.
This and other support options are available here:
BCPS:
https://partner.microsoft.com/US/technicalsupport/supportoverview/40010469 Others:
https://partner.microsoft.com/US/technicalsupport/supportoverview/ If you are outside the United States, please visit our International
Support page:
http://support.microsoft.com/default.aspx?scid=%2finternational.aspx.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------
| Thread-Topic: Delivering expanded reports using Report Manager scheduling
| thread-index: AcU67++GO0Bnv80IRCmdnLpeh9VReA==
| X-WBNR-Posting-Host: 163.231.6.87
| From: "=?Utf-8?B?RGF2aWQgU3dhbnNvbg==?="
<DavidSwansonSDG@newsgroup.nospam>
| Subject: Delivering expanded reports using Report Manager scheduling
| Date: Wed, 6 Apr 2005 14:31:04 -0700
| Lines: 11
| Message-ID: <8DE41E96-D458-4C17-B4AC-AA855196DAA9@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.1.29
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:40218
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| I have a report that in its default state has detail rows hidden. You
click
| the little plus sign and they are visible as expected.
|
| The problem is that if you schedule this report, the report is delivered
| unexpanded which is of very little use for this particular report. Is
there
| a way to force full expansion of the toggles when it is delivered via
report
| manager scheduled reports?
|
| If not, please put on wish list.
|
| Thanks, David
|
