Out of the box reports

Hi
My company is planning to deploy SQL Server 2005 Reporting Services to
monitor usage of a number of sites we've created using Sharepoint.
The marketing blurb says that a number of out-of-the-box reports are
available but doesn't say exactly what these reports are. Can someone
help by giving me the details?
Thanks
Tony
> My company is planning to deploy SQL Server 2005 Reporting Services to
> monitor usage of a number of sites we've created using Sharepoint.
> The marketing blurb says that a number of out-of-the-box reports are
> available but doesn't say exactly what these reports are. Can someone
> help by giving me the details?
>
The reports and the deployment guide are available for free from
Microsoft. Do a seach on microsoft.com about "Report Pack for
Sharepoint" and "Report Pack for Sharepoint Deployment Guide".
Regards,
lucm
sql

Out of the box reports

Hi
My company is planning to deploy SQL Server 2005 Reporting Services to
monitor usage of a number of sites we've created using Sharepoint.
The marketing blurb says that a number of out-of-the-box reports are
available but doesn't say exactly what these reports are. Can someone
help by giving me the details?
Thanks
Tony> My company is planning to deploy SQL Server 2005 Reporting Services to
> monitor usage of a number of sites we've created using Sharepoint.
> The marketing blurb says that a number of out-of-the-box reports are
> available but doesn't say exactly what these reports are. Can someone
> help by giving me the details?
>
The reports and the deployment guide are available for free from
Microsoft. Do a seach on microsoft.com about "Report Pack for
Sharepoint" and "Report Pack for Sharepoint Deployment Guide".
Regards,
lucm

Out of the box reports

Hi
My company is planning to deploy SQL Server 2005 Reporting Services to
monitor usage of a number of sites we've created using Sharepoint.
The marketing blurb says that a number of out-of-the-box reports are
available but doesn't say exactly what these reports are. Can someone
help by giving me the details?
Thanks
Tony> My company is planning to deploy SQL Server 2005 Reporting Services to
> monitor usage of a number of sites we've created using Sharepoint.
> The marketing blurb says that a number of out-of-the-box reports are
> available but doesn't say exactly what these reports are. Can someone
> help by giving me the details?
>
The reports and the deployment guide are available for free from
Microsoft. Do a seach on microsoft.com about "Report Pack for
Sharepoint" and "Report Pack for Sharepoint Deployment Guide".
Regards,
lucm

'Other' segment in a pie chart

Hello everybody,

I am creating a pie chart report from a cube. This report may contain unknown number of segments. Here is the thing; if more than 1 data slice is generated with a value less than 5% of the total, then a segment labelled 'other' will be generated, and data from all slices with value < 5% will be added to this 'Other' segment.

Is it possible to implement this functionality with out writing a complex MDX query?

If not can anybody give me a sample MDX query which implements similar issue(i.e. 'Other-ing' rule.)

For your information, this feature can be implemented using a third pary software such as 'Dundas chart for Reporting Service'.

Hi,

Does anybody has some idea?

--Amde

|||

This is answered here: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=638700&SiteID=1&mode=1

-- Robert

'Other' segment in a pie chart

Hello everybody,

I am creating a pie chart report from a cube. This report may contain unknown number of segments. Here is the thing; if more than 1 data slice is generated with a value less than 5% of the total, then a segment labelled 'other' will be generated, and data from all slices with value < 5% will be added to this 'Other' segment.

Is it possible to implement this functionality with out writing a complex MDX query?

If not can anybody give me a sample MDX query which implements similar issue(i.e. 'Other-ing' rule.)

For your information, this feature can be implemented using a third pary software such as 'Dundas chart for Reporting Service'.

Hi,

Does anybody has some idea?

--Amde

|||

This is answered here: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=638700&SiteID=1&mode=1

-- Robert

OT: Proliant reboots during replication

Configuration: Proliant ML350 , Win2000 Server, SQL Server 2000
internal PCI ISDN adapter ASUS P-IN-100(W,D)
This server has number of merge replications (as publisher) and does
up to 15 replications every night. From time to time (once a week or
5-6 days, but always during replication) the machine reboots.
In Compaq Integrated Management Log Viewer we have ervery time :
-PCI Bus Error (Slot 0, Bus 0, Device 15, Function 0)
-ASR Detected by System ROM
-POST Error: A Critical Error occured prior to this power-up
and in System Log:
Event Type:Error
Event Source:cpqasm
Event Category:None
Event ID:4196
Date:25.3.2004
Time:23:05:20
User:N/A
Computer:xxxxxxxxx
Description:
The system encountered a Non-Maskable Interrupt (NMI) prior to this
boot. The NMI source was: PCI bus error, slot 0.
Computer Management reported that (Slot 0, Bus 0, Device 15, Function
0) is PCI Standard ISA Bridge.
During a day there is a lot of traffic using same ISDN adapter (lot of
FTP-s) without any problem. It seems that only replication is problem.
Although I know this is most probably ISDN Adapter/drivers problem
I'm trying in this group. Maybe somebody has some hint ?
Happy greetings,
Pagus
PS: Today we had same problem with same hardware configuration at
other location, this time Proliant + Win2003 SBS as publisher.
Same problem here... Proliant ML350 G3, reboots automatically at random times...
If we test our serial port (nothing connected) with the HP-tool CPQdiagnostics (SP27119.exe) the system crashes. When we connect a mouse to that particular serial port, we got a software-error of CPQdiagnostics.
All other hardwaretests look fine.
Here we attach some minidump-debuganalyses. Can you also test these things ? Maybe we have the same problem ?
Greetings
Dieter
Microsoft (R) Windows Debugger Version 6.2.0013.1
Copyright (c) Microsoft Corporation. All rights reserved.
Loading Dump File [C:\Program Files\Debugging Tools for Windows\Mini040704-01.dmp]
Mini Kernel Dump File: Only registers and stack trace are available
Symbol search path is: SRV*c:\websymbols*http://msdl.microsoft.com/download/symbols
Executable search path is:
Windows Server 2003 Kernel Version 3790 MP (4 procs) Free x86 compatible
Product: Server, suite: TerminalServer SingleUserTS
Built by: 3790.srv03_rtm.030324-2048
Kernel base = 0x804de000 PsLoadedModuleList = 0x8057b6a8
Debug session time: Wed Apr 07 08:32:16 2004
System Uptime: 0 days 0:02:32.265
Loading Kernel Symbols
...................................... ...................................... .........
Loading unloaded module list
...
Loading User Symbols
************************************************** *****************************
* *
* Bugcheck Analysis *
* *
************************************************** *****************************
Use !analyze -v to get detailed debugging information.
BugCheck 1000008E, {c0000005, 80527564, 8056c090, 0}
Probably caused by : ntkrnlmp.exe ( nt!KiDispatchException+19e )
Followup: MachineOwner
0: kd> !analyze -v
************************************************** *****************************
* *
* Bugcheck Analysis *
* *
************************************************** *****************************
KERNEL_MODE_EXCEPTION_NOT_HANDLED_M (1000008e)
This is a very common bugcheck. Usually the exception address pinpoints
the driver/function that caused the problem. Always note this address
as well as the link date of the driver/image that contains this address.
Some common problems are exception code 0x80000003. This means a hard
coded breakpoint or assertion was hit, but this system was booted
/NODEBUG. This is not supposed to happen as developers should never have
hardcoded breakpoints in retail code, but ...
If this happens, make sure a debugger gets connected, and the
system is booted /DEBUG. This will let us see why this breakpoint is
happening.
An exception code of 0x80000002 (STATUS_DATATYPE_MISALIGNMENT) indicates
that an unaligned data reference was encountered. The trap frame will
supply additional information.
Arguments:
Arg1: c0000005, The exception code that was not handled
Arg2: 80527564, The address that the exception occurred at
Arg3: 8056c090, Trap Frame
Arg4: 00000000
Debugging Details:
EXCEPTION_CODE: (NTSTATUS) 0xc0000005 - De instructie op 0x%08lx verwijst naar geheugen op 0x%08lx. De lees- of schrijfbewerking ("%s") op het geheugen is mislukt.
FAULTING_IP:
nt!KiDispatchException+19e
80527564 e92e65feff jmp nt!KiDispatchException+0x19e (8050da97)
TRAP_FRAME: 8056c090 -- (.trap ffffffff8056c090)
ESP EDITED! New esp=8056c3f0
ErrCode = 00000000
eax=8056c6cc ebx=8056c804 ecx=81987020 edx=00010000 esi=8056c7b0 edi=00000000
eip=80527564 esp=8056c104 ebp=8056c794 iopl=0 nv up ei ng nz na pe cy
cs=0000 ss=0010 ds=0023 es=0023 fs=0030 gs=0000 efl=00000283
nt!KiDispatchException+0x19e:
80527564 e92e65feff jmp nt!KiDispatchException+0x19e (8050da97)
Resetting default scope
DEFAULT_BUCKET_ID: DRIVER_FAULT_SERVER_MINIDUMP
BUGCHECK_STR: 0x8E
CURRENT_IRQL: 0
LAST_CONTROL_TRANSFER: from 804e087a to 80527564
STACK_TEXT:
8056c794 804e087a 8056c7b0 00000000 8056c804 nt!KiDispatchException+0x19e
8056c7fc 804e07fa 00000000 00000000 00000023 nt!CommonDispatchException+0x4a
8056c804 00000000 00000023 00000023 010cfee4 nt!KiExceptionExit+0x16a
FOLLOWUP_IP:
nt!KiDispatchException+19e
80527564 e92e65feff jmp nt!KiDispatchException+0x19e (8050da97)
FOLLOWUP_NAME: MachineOwner
SYMBOL_NAME: nt!KiDispatchException+19e
MODULE_NAME: nt
IMAGE_NAME: ntkrnlmp.exe
DEBUG_FLR_IMAGE_TIMESTAMP: 3e8015c6
STACK_COMMAND: .trap ffffffff8056c090 ; kb
BUCKET_ID: 0x8E_nt!KiDispatchException+19e
Followup: MachineOwner
another one :
Loading Dump File [C:\Program Files\Debugging Tools for Windows\Mini040604-01.dmp]
Mini Kernel Dump File: Only registers and stack trace are available
Symbol search path is: SRV*c:\websymbols*http://msdl.microsoft.com/download/symbols
Executable search path is:
Windows Server 2003 Kernel Version 3790 MP (4 procs) Free x86 compatible
Product: Server, suite: TerminalServer SingleUserTS
Built by: 3790.srv03_rtm.030324-2048
Kernel base = 0x804de000 PsLoadedModuleList = 0x8057b6a8
Debug session time: Tue Apr 06 09:33:17 2004
System Uptime: 0 days 0:07:34.015
Loading Kernel Symbols
...................................... ...................................... .......
Loading unloaded module list
...
Loading User Symbols
************************************************** *****************************
* *
* Bugcheck Analysis *
* *
************************************************** *****************************
Use !analyze -v to get detailed debugging information.
BugCheck 1000008E, {80000003, 804df1c0, f7752ba4, 0}
Probably caused by : ntkrnlmp.exe ( nt!RtlpBreakWithStatusInstruction+0 )
Followup: MachineOwner
1: kd> !analyze -v
************************************************** *****************************
* *
* Bugcheck Analysis *
* *
************************************************** *****************************
KERNEL_MODE_EXCEPTION_NOT_HANDLED_M (1000008e)
This is a very common bugcheck. Usually the exception address pinpoints
the driver/function that caused the problem. Always note this address
as well as the link date of the driver/image that contains this address.
Some common problems are exception code 0x80000003. This means a hard
coded breakpoint or assertion was hit, but this system was booted
/NODEBUG. This is not supposed to happen as developers should never have
hardcoded breakpoints in retail code, but ...
If this happens, make sure a debugger gets connected, and the
system is booted /DEBUG. This will let us see why this breakpoint is
happening.
An exception code of 0x80000002 (STATUS_DATATYPE_MISALIGNMENT) indicates
that an unaligned data reference was encountered. The trap frame will
supply additional information.
Arguments:
Arg1: 80000003, The exception code that was not handled
Arg2: 804df1c0, The address that the exception occurred at
Arg3: f7752ba4, Trap Frame
Arg4: 00000000
Debugging Details:
EXCEPTION_CODE: (HRESULT) 0x80000003 (2147483651) - Een of meer argumenten zijn ongeldig
FAULTING_IP:
nt!RtlpBreakWithStatusInstruction+0
804df1c0 cc int 3
TRAP_FRAME: f7752ba4 -- (.trap fffffffff7752ba4)
ErrCode = 00000000
eax=00000004 ebx=00000000 ecx=805429fd edx=00000000 esi=00000000 edi=80000003
eip=804df1c1 esp=f7752c18 ebp=f7752c60 iopl=0 nv up di pl zr na po nc
cs=0008 ss=0010 ds=0023 es=0023 fs=0030 gs=0000 efl=00000046
nt!RtlpBreakWithStatusInstruction+0x1:
804df1c1 c20400 ret 0x4
Resetting default scope
DEFAULT_BUCKET_ID: DRIVER_FAULT_SERVER_MINIDUMP
BUGCHECK_STR: 0x8E
CURRENT_IRQL: 0
LAST_CONTROL_TRANSFER: from 80542289 to 804df1c1
STACK_TEXT:
f7752c14 80542289 00000004 80000003 00000000 nt!RtlpBreakWithStatusInstruction+0x1
f7752c60 805434e2 00000004 00000000 f77533c0 nt!KiBugCheckDebugBreak+0x19
f7752fc8 805435b9 0000008e 80000003 804df1c0 nt!KeBugCheck2+0x882
f7752fe8 80527624 0000008e 80000003 804df1c0 nt!KeBugCheckEx+0x19
f77533a4 804e087a f77533c0 00000000 f7753414 nt!KiDispatchException+0x2f5
f775340c 804e0fe1 00000000 00000000 00000000 nt!CommonDispatchException+0x4a
f775340c 804df1c1 00000000 00000000 00000000 nt!KiTrap03+0x9d
f7753484 80542289 00000004 80000003 00000000 nt!RtlpBreakWithStatusInstruction+0x1
f77534d0 805434e2 00000004 00000000 f7753c30 nt!KiBugCheckDebugBreak+0x19
f7753838 805435b9 0000008e 80000003 804df1c0 nt!KeBugCheck2+0x882
f7753858 80527624 0000008e 80000003 804df1c0 nt!KeBugCheckEx+0x19
f7753c14 804e087a f7753c30 00000000 f7753c84 nt!KiDispatchException+0x2f5
f7753c7c 804e0fe1 00000000 00000000 00000000 nt!CommonDispatchException+0x4a
f7753c7c 804df1c1 00000000 00000000 00000000 nt!KiTrap03+0x9d
f7753cf4 80542289 00000004 80000003 00000000 nt!RtlpBreakWithStatusInstruction+0x1
f7753d40 805434e2 00000004 00000000 f77544a0 nt!KiBugCheckDebugBreak+0x19
f77540a8 805435b9 0000008e 80000003 804df1c0 nt!KeBugCheck2+0x882
f77540c8 80527624 0000008e 80000003 804df1c0 nt!KeBugCheckEx+0x19
f7754484 804e087a f77544a0 00000000 f77544f4 nt!KiDispatchException+0x2f5
f77544ec 804e0fe1 00000000 00000000 00000000 nt!CommonDispatchException+0x4a
f77544ec 804df1c1 00000000 00000000 00000000 nt!KiTrap03+0x9d
f7754564 80542289 00000004 80000003 00000000 nt!RtlpBreakWithStatusInstruction+0x1
f77545b0 805434e2 00000004 00000000 f7754d10 nt!KiBugCheckDebugBreak+0x19
f7754918 805435b9 0000008e 80000003 804df1c0 nt!KeBugCheck2+0x882
f7754938 80527624 0000008e 80000003 804df1c0 nt!KeBugCheckEx+0x19
f7754cf4 804e087a f7754d10 00000000 f7754d64 nt!KiDispatchException+0x2f5
f7754d5c 804e0fe1 00000000 00000000 00000020 nt!CommonDispatchException+0x4a
f7754d5c 804df1c1 00000000 00000000 00000020 nt!KiTrap03+0x9d
f7754dd4 80542289 00000004 00000000 00000000 nt!RtlpBreakWithStatusInstruction+0x1
f7754e20 805434e2 00000004 a2000000 84010400 nt!KiBugCheckDebugBreak+0x19
f7755188 805435b9 0000009c 00000000 f77551d0 nt!KeBugCheck2+0x882
f77551a8 8074cfab 0000009c 00000000 f77551d0 nt!KeBugCheckEx+0x19
f77552d4 8074584f f774fef0 00000000 00000000 hal!HalpMcaExceptionHandler+0xc9
FOLLOWUP_IP:
nt!RtlpBreakWithStatusInstruction+0
804df1c0 cc int 3
FOLLOWUP_NAME: MachineOwner
SYMBOL_NAME: nt!RtlpBreakWithStatusInstruction+0
MODULE_NAME: nt
IMAGE_NAME: ntkrnlmp.exe
DEBUG_FLR_IMAGE_TIMESTAMP: 3e8015c6
STACK_COMMAND: .trap fffffffff7752ba4 ; kb
BUCKET_ID: 0x8E_nt!RtlpBreakWithStatusInstruction+0
Followup: MachineOwner

Osql and CommandLine stored procedures

I'm currently developing a number of SQL scripts to handle a major upgrade of our database from a development server to a production server using Osql.

Everything is working fine, but I have each of the scripts generating text-output and am hoping someone may know how to suppress some the Caution text (specifically triggered when a column has been renamed).

Can anyone provide a possible solution? (there's so many notes being written to the console its easy to miss the errors I'm concerned about.

Thanks!

TedNot that I am aware of. You might try SET ANSI_WARNINGS OFF but that will not suppress the types of warnings to which you are referring.

Terri

Orphaned Table Footers

Hello.
I have a report that uses one table in the body. The actual report header is
empty and the actual report footer only shows the page number. I use the
Table header and have "Repeat on New Page" set to True. I use the table
header instead because I need to display some summary data at the top of each
page.
I have 4 groups total and the header of the outermost group (table1_group1)
is the one that repeats on each page.
The reports display fine most of the time and the Table1_group1 table header
repeats as it should, but whenever the spacing works out that the
Table1_Footer1 table footer needs to start on a new page, the footer prints
on its own without the table header. The table1_Group1 table footer does not
repeat on each page and only shows up as the last page for each group as it
shows some totals/sums.
Any ideas on how to fix this so the Table_1Group1 table header will print
even when only the Table1Group1 table footer is being printed?
Thanks,
Brian.Hi Brian,
I'd like to get a clear understanding of your issue to
be able to assist you better.
>I have a report that uses one table in the body. The
actual report header is
>empty and the actual report footer only shows the page
number. I use the
1. In Reporting Services there is no sections called
Report Header or Report Footer although the black space
above/below the data region can be regarded as Report
Header/Report Footer. Since "the actual report footer
only shows the page number", I'd like to confirm if you
mean Page Header/Page Footer by saying Report
Header/Report Footer.
>Table header and have "Repeat on New Page" set to True.
I use the table
>header instead because I need to display some summary
data at the top of each
>page.
2. This is the second one I'd like to confirm. You set
the "RepeatOnNewPage" property of the Table Header
rather than the Group Header to true.
>I have 4 groups total and the header of the outermost
group (table1_group1)
>is the one that repeats on each page.
3. How did you do with the outermost group named
table1_group1 so that it repeats on each page? Did you
set the "RepeatOnNewPage" property of the Group Header
of this group to true or place a "Page Break at end" of
the group?
>The reports display fine most of the time and the
Table1_group1 table header
4. Here by saying "the Table1_group1 table header" do
you mean the "group header of Table1_group1"?
>repeats as it should, but whenever the spacing works
out that the
>Table1_Footer1 table footer needs to start on a new
page,
5. A Table Footer only appears at the end of a table.
I'd like to confirm if you mean Table Footer or Group
Footer of Table1_group1.
>the footer prints
>on its own without the table header. The table1_Group1
table footer does not
>repeat on each page and only shows up as the last page
for each group as it
>shows some totals/sums.
>Any ideas on how to fix this so the Table_1Group1 table
header will print
>even when only the Table1Group1 table footer is being
printed?
6. Setting the "RepeatOnNewPage" property of the Group
Header to true should have no such a problem. By doing
this the group header repeats on each page.
For us, the most efficient troubleshooting method would
be reproducing this issue on our end. If the issue
persists, please try to reproduce the issue with a
sample database and post the detailed reproduce steps.
If anything is unclear, get in touch.
Sincerely,
William Wang
Microsoft Online Partner Support
Get Secure! - <www.microsoft.com/security>
=====================================================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: Orphaned Table Footers
>thread-index: AcUCWF6Szxan+iN7TLGB155pQjDGbg==>X-WBNR-Posting-Host: 204.92.98.25
>From: "=?Utf-8?B?QnJpYW4=?=" <Bri-Guy@.nospam.nospam>
>Subject: Orphaned Table Footers
>Date: Mon, 24 Jan 2005 13:05:01 -0800
>Lines: 20
>Message-ID:
<C6FB5F66-C1CB-41A0-A449-620826ECF7D7@.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: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
>Xref: cpmsftngxa10.phx.gbl
microsoft.public.sqlserver.reportingsvcs:40664
>X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
>Hello.
>I have a report that uses one table in the body. The
actual report header is
>empty and the actual report footer only shows the page
number. I use the
>Table header and have "Repeat on New Page" set to True.
I use the table
>header instead because I need to display some summary
data at the top of each
>page.
>I have 4 groups total and the header of the outermost
group (table1_group1)
>is the one that repeats on each page.
>The reports display fine most of the time and the
Table1_group1 table header
>repeats as it should, but whenever the spacing works
out that the
>Table1_Footer1 table footer needs to start on a new
page, the footer prints
>on its own without the table header. The table1_Group1
table footer does not
>repeat on each page and only shows up as the last page
for each group as it
>shows some totals/sums.
>Any ideas on how to fix this so the Table_1Group1 table
header will print
>even when only the Table1Group1 table footer is being
printed?
>Thanks,
>Brian.
>|||Hello.
Sorry, I used some wrong terminology. Here are the clarifications.
1) -Page header is empty.
- it is the page footer that only shows the page number
2) -Table header row is deleted (I don't use it).
- RepeatOnNewPage property of the Table1_Group1 header is set to true. This
is the header that contains some summary data and I want it to repeat on each
page.
- Table Footer is included. RepeatOnNewPage property is set to TRUE. This is
just an empty row with a bottom border. This repeats on each page to give the
table a bottom border on each page.
3) -Table1_Group1 Header RepeatOnNewPage Property is TRUE
-When I go "Edit Group", Page break at start, include group header, include
group footer, AND repeat group header are checked off. So both "Repeat Group
Header" is checked and RepeatOnNewPage property is TRUE.
4) - Yes, I mean the Group Header of Table1_Group1
5) - Yes, I mean the Group Footer of Table1_Group1
I think this might be the problem:
The Group Headers will repeat on each page in the print preview and when
exporting to PDF as long as the page displays data from the Table Details
section or data from inner groups. But if the Outermost group footer is
squeezed onto the next page by itself then the group header does not show.
I was able to replicate this problem using a very simple report.
Steps:
1) Create a new report. have the data set return only 1 row to make things
simple (.EG Select Top 1 * from table).
2) Create a table in the body of the report
3) Get rid of the table header and the table footer. so only the table
details section remains.
4) Add a group. Group on anything since only 1 row is returned by the query.
-so now there's 3 rows in the layout. Table1_Group1 Header, Detail, and
Table1_Group1 Footer.
5) Type something into the table1_group1 header,
-Edit the group and check off
6) Drag a field into the body.
7) type something into the table1_Group1 footer. footer only shows up at the
end of each group change and does not repeat on each page.
8) Now, make the detail row long, so that it just squeezes the table1_Group1
footer onto the next page in the print preview.
The Table1_Group1 Header will show up on the first page along with the
detail row, but in the next page, only the table1_Group1 footer row shows.
The table1_Group1 header does not appear even though it should repeat on each
page.
This happens in the Print Preview (NOT THE PREVIEW TAB OR WHEN VIEWING
ONLINE) and also when you export the report to PDF. Viewing the report just
online is fine.
For my real report, the table1_Group1 header always repeats fine except on
pages where only the table1_Group1 footer has been squeezed onto the next
page by itself.
Like I said, my report has 4 groups, each group gives subtotals at various
levels and the table1_Group1 Footer gives a grand total for each set.
Hopefully the problem is clear now.
Thanks!
Brian.
"William Wang[MSFT]" wrote:
> Hi Brian,
> I'd like to get a clear understanding of your issue to
> be able to assist you better.
> >I have a report that uses one table in the body. The
> actual report header is
> >empty and the actual report footer only shows the page
> number. I use the
> 1. In Reporting Services there is no sections called
> Report Header or Report Footer although the black space
> above/below the data region can be regarded as Report
> Header/Report Footer. Since "the actual report footer
> only shows the page number", I'd like to confirm if you
> mean Page Header/Page Footer by saying Report
> Header/Report Footer.
>
> >Table header and have "Repeat on New Page" set to True.
> I use the table
> >header instead because I need to display some summary
> data at the top of each
> >page.
> 2. This is the second one I'd like to confirm. You set
> the "RepeatOnNewPage" property of the Table Header
> rather than the Group Header to true.
>
> >I have 4 groups total and the header of the outermost
> group (table1_group1)
> >is the one that repeats on each page.
> 3. How did you do with the outermost group named
> table1_group1 so that it repeats on each page? Did you
> set the "RepeatOnNewPage" property of the Group Header
> of this group to true or place a "Page Break at end" of
> the group?
>
> >The reports display fine most of the time and the
> Table1_group1 table header
> 4. Here by saying "the Table1_group1 table header" do
> you mean the "group header of Table1_group1"?
>
> >repeats as it should, but whenever the spacing works
> out that the
> >Table1_Footer1 table footer needs to start on a new
> page,
> 5. A Table Footer only appears at the end of a table.
> I'd like to confirm if you mean Table Footer or Group
> Footer of Table1_group1.
>
> >the footer prints
> >on its own without the table header. The table1_Group1
> table footer does not
> >repeat on each page and only shows up as the last page
> for each group as it
> >shows some totals/sums.
> >Any ideas on how to fix this so the Table_1Group1 table
> header will print
> >even when only the Table1Group1 table footer is being
> printed?
> 6. Setting the "RepeatOnNewPage" property of the Group
> Header to true should have no such a problem. By doing
> this the group header repeats on each page.
> For us, the most efficient troubleshooting method would
> be reproducing this issue on our end. If the issue
> persists, please try to reproduce the issue with a
> sample database and post the detailed reproduce steps.
> If anything is unclear, get in touch.
> Sincerely,
> William Wang
> Microsoft Online Partner Support
> Get Secure! - <www.microsoft.com/security>
> =====================================================> 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: Orphaned Table Footers
> >thread-index: AcUCWF6Szxan+iN7TLGB155pQjDGbg==> >X-WBNR-Posting-Host: 204.92.98.25
> >From: "=?Utf-8?B?QnJpYW4=?=" <Bri-Guy@.nospam.nospam>
> >Subject: Orphaned Table Footers
> >Date: Mon, 24 Jan 2005 13:05:01 -0800
> >Lines: 20
> >Message-ID:
> <C6FB5F66-C1CB-41A0-A449-620826ECF7D7@.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: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
> >Xref: cpmsftngxa10.phx.gbl
> microsoft.public.sqlserver.reportingsvcs:40664
> >X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> >
> >Hello.
> >
> >I have a report that uses one table in the body. The
> actual report header is
> >empty and the actual report footer only shows the page
> number. I use the
> >Table header and have "Repeat on New Page" set to True.
> I use the table
> >header instead because I need to display some summary
> data at the top of each
> >page.
> >I have 4 groups total and the header of the outermost
> group (table1_group1)
> >is the one that repeats on each page.
> >The reports display fine most of the time and the
> Table1_group1 table header
> >repeats as it should, but whenever the spacing works
> out that the
> >Table1_Footer1 table footer needs to start on a new
> page, the footer prints
> >on its own without the table header. The table1_Group1
> table footer does not
> >repeat on each page and only shows up as the last page
> for each group as it
> >shows some totals/sums.
> >Any ideas on how to fix this so the Table_1Group1 table
> header will print
> >even when only the Table1Group1 table footer is being
> printed?
> >
> >Thanks,
> >Brian.
> >
>|||Hi Brian,
I will be looking into this issue and I will update you
once I have more information.
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.
=====================================================
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/support
overview/40010469
Others:
https://partner.microsoft.com/US/technicalsupport/support
overview/
If you are outside the United States, please visit our
International Support page:
http://support.microsoft.com/default.aspx?scid=%2finterna
tional.aspx.
=====================================================
This posting is provided "AS IS" with no warranties, and
confers no rights.
--
>Thread-Topic: Orphaned Table Footers
>thread-index: AcUDE9iY3e1yULFPQLmd8LylZ4RFtQ==>X-WBNR-Posting-Host: 204.92.98.25
>From: "=?Utf-8?B?QnJpYW4=?=" <Bri-Guy@.nospam.nospam>
>References:
<C6FB5F66-C1CB-41A0-A449-620826ECF7D7@.microsoft.com>
<QmipjprAFHA.2768@.cpmsftngxa10.phx.gbl>
>Subject: RE: Orphaned Table Footers
>Date: Tue, 25 Jan 2005 11:27:02 -0800
>Lines: 228
>Message-ID:
<F2866859-4257-41B1-9F2F-FAACB7EEC085@.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: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
>Xref: cpmsftngxa10.phx.gbl
microsoft.public.sqlserver.reportingsvcs:40795
>X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
>Hello.
>Sorry, I used some wrong terminology. Here are the
clarifications.
>1) -Page header is empty.
>- it is the page footer that only shows the page number
>2) -Table header row is deleted (I don't use it).
>- RepeatOnNewPage property of the Table1_Group1 header
is set to true. This
>is the header that contains some summary data and I
want it to repeat on each
>page.
>- Table Footer is included. RepeatOnNewPage property is
set to TRUE. This is
>just an empty row with a bottom border. This repeats on
each page to give the
>table a bottom border on each page.
>
>3) -Table1_Group1 Header RepeatOnNewPage Property is
TRUE
>-When I go "Edit Group", Page break at start, include
group header, include
>group footer, AND repeat group header are checked off.
So both "Repeat Group
>Header" is checked and RepeatOnNewPage property is TRUE.
>4) - Yes, I mean the Group Header of Table1_Group1
>5) - Yes, I mean the Group Footer of Table1_Group1
>I think this might be the problem:
>The Group Headers will repeat on each page in the print
preview and when
>exporting to PDF as long as the page displays data from
the Table Details
>section or data from inner groups. But if the Outermost
group footer is
>squeezed onto the next page by itself then the group
header does not show.
>I was able to replicate this problem using a very
simple report.
>Steps:
>1) Create a new report. have the data set return only 1
row to make things
>simple (.EG Select Top 1 * from table).
>2) Create a table in the body of the report
>3) Get rid of the table header and the table footer. so
only the table
>details section remains.
>4) Add a group. Group on anything since only 1 row is
returned by the query.
> -so now there's 3 rows in the layout. Table1_Group1
Header, Detail, and
>Table1_Group1 Footer.
>5) Type something into the table1_group1 header,
> -Edit the group and check off
>6) Drag a field into the body.
>7) type something into the table1_Group1 footer. footer
only shows up at the
>end of each group change and does not repeat on each
page.
>8) Now, make the detail row long, so that it just
squeezes the table1_Group1
>footer onto the next page in the print preview.
>The Table1_Group1 Header will show up on the first page
along with the
>detail row, but in the next page, only the
table1_Group1 footer row shows.
>The table1_Group1 header does not appear even though it
should repeat on each
>page.
>This happens in the Print Preview (NOT THE PREVIEW TAB
OR WHEN VIEWING
>ONLINE) and also when you export the report to PDF.
Viewing the report just
>online is fine.
>For my real report, the table1_Group1 header always
repeats fine except on
>pages where only the table1_Group1 footer has been
squeezed onto the next
>page by itself.
>Like I said, my report has 4 groups, each group gives
subtotals at various
>levels and the table1_Group1 Footer gives a grand total
for each set.
>Hopefully the problem is clear now.
>Thanks!
>Brian.
>"William Wang[MSFT]" wrote:
>> Hi Brian,
>> I'd like to get a clear understanding of your issue
to
>> be able to assist you better.
>> >I have a report that uses one table in the body. The
>> actual report header is
>> >empty and the actual report footer only shows the
page
>> number. I use the
>> 1. In Reporting Services there is no sections called
>> Report Header or Report Footer although the black
space
>> above/below the data region can be regarded as Report
>> Header/Report Footer. Since "the actual report footer
>> only shows the page number", I'd like to confirm if
you
>> mean Page Header/Page Footer by saying Report
>> Header/Report Footer.
>>
>> >Table header and have "Repeat on New Page" set to
True.
>> I use the table
>> >header instead because I need to display some
summary
>> data at the top of each
>> >page.
>> 2. This is the second one I'd like to confirm. You
set
>> the "RepeatOnNewPage" property of the Table Header
>> rather than the Group Header to true.
>>
>> >I have 4 groups total and the header of the
outermost
>> group (table1_group1)
>> >is the one that repeats on each page.
>> 3. How did you do with the outermost group named
>> table1_group1 so that it repeats on each page? Did
you
>> set the "RepeatOnNewPage" property of the Group
Header
>> of this group to true or place a "Page Break at end"
of
>> the group?
>>
>> >The reports display fine most of the time and the
>> Table1_group1 table header
>> 4. Here by saying "the Table1_group1 table header" do
>> you mean the "group header of Table1_group1"?
>>
>> >repeats as it should, but whenever the spacing works
>> out that the
>> >Table1_Footer1 table footer needs to start on a new
>> page,
>> 5. A Table Footer only appears at the end of a table.
>> I'd like to confirm if you mean Table Footer or Group
>> Footer of Table1_group1.
>>
>> >the footer prints
>> >on its own without the table header. The
table1_Group1
>> table footer does not
>> >repeat on each page and only shows up as the last
page
>> for each group as it
>> >shows some totals/sums.
>> >Any ideas on how to fix this so the Table_1Group1
table
>> header will print
>> >even when only the Table1Group1 table footer is
being
>> printed?
>> 6. Setting the "RepeatOnNewPage" property of the
Group
>> Header to true should have no such a problem. By
doing
>> this the group header repeats on each page.
>> For us, the most efficient troubleshooting method
would
>> be reproducing this issue on our end. If the issue
>> persists, please try to reproduce the issue with a
>> sample database and post the detailed reproduce steps.
>> If anything is unclear, get in touch.
>> Sincerely,
>> William Wang
>> Microsoft Online Partner Support
>> Get Secure! - <www.microsoft.com/security>
>> =====================================================>> 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: Orphaned Table Footers
>> >thread-index: AcUCWF6Szxan+iN7TLGB155pQjDGbg==>> >X-WBNR-Posting-Host: 204.92.98.25
>> >From: "=?Utf-8?B?QnJpYW4=?=" <Bri-Guy@.nospam.nospam>
>> >Subject: Orphaned Table Footers
>> >Date: Mon, 24 Jan 2005 13:05:01 -0800
>> >Lines: 20
>> >Message-ID:
>> <C6FB5F66-C1CB-41A0-A449-620826ECF7D7@.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: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
>> >Xref: cpmsftngxa10.phx.gbl
>> microsoft.public.sqlserver.reportingsvcs:40664
>> >X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
>> >
>> >Hello.
>> >
>> >I have a report that uses one table in the body. The
>> actual report header is
>> >empty and the actual report footer only shows the
page
>> number. I use the
>> >Table header and have "Repeat on New Page" set to
True.
>> I use the table
>> >header instead because I need to display some
summary
>> data at the top of each
>> >page.
>> >I have 4 groups total and the header of the
outermost
>> group (table1_group1)
>> >is the one that repeats on each page.
>> >The reports display fine most of the time and the
>> Table1_group1 table header
>> >repeats as it should, but whenever the spacing works
>> out that the
>> >Table1_Footer1 table footer needs to start on a new
>> page, the footer prints
>> >on its own without the table header. The
table1_Group1
>> table footer does not
>> >repeat on each page and only shows up as the last
page
>> for each group as it
>> >shows some totals/sums.
>> >Any ideas on how to fix this so the Table_1Group1
table
>> header will print
>> >even when only the Table1Group1 table footer is
being
>> printed?
>> >
>> >Thanks,
>> >Brian.
>> >
>>
>|||Hi Brian,
From the product team's feedback, in this case we've
made the detail row tall enough that the header row plus
the detail row plus the footer row is simply too big for
a page.
In the case of HTML and Preview, we use a flexible
pagination algorithm that allows pages to grow somewhat
to accommodate this sort of layout.
In the case of PDF or Print Preview, we must respect the
page size settings precisely.
This is by design in Reporting Services. As an end user
too, I can truly understand your concern about it.
Currently we have some options for you regarding this
issue:
a. You may want to send a feature change request to
mswish@.microsoft.com. By submitting your concern to
mswish@.microsoft.com you can get your voice into the
design plans for upcoming versions. Microsoft takes
customer requests and suggestions very seriously. MSWISH
is your voice to the development team. A significant
number of the design change requests come from our
customers through the MSWISH alias and the MSWISH web
site. http://www.microsoft.com/mswish. I encourage you
to submit this request.
b. You can talk to the support engineers directly in
Microsoft Product Support Services (PSS) to see if they
can find a workaround or offer a fix. For a complete
list of Microsoft Product Support Services phone
numbers, please go to the following address on the World
Wide Web:
<http://support.microsoft.com/directory/overview.asp>
If you are outside the US please see
http://support.microsoft.com for regional support phone
numbers.
HTH!
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.
--
>X-Tomcat-ID: 215340416
>References:
<C6FB5F66-C1CB-41A0-A449-620826ECF7D7@.microsoft.com>
<QmipjprAFHA.2768@.cpmsftngxa10.phx.gbl>
<F2866859-4257-41B1-9F2F-FAACB7EEC085@.microsoft.com>
>MIME-Version: 1.0
>Content-Type: text/plain
>Content-Transfer-Encoding: 7bit
>From: v-rxwang@.online.microsoft.com (William Wang[MSFT])
>Organization: Microsoft
>Date: Wed, 26 Jan 2005 10:18:13 GMT
>Subject: RE: Orphaned Table Footers
>X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
>Message-ID: <8rTWYB5AFHA.2504@.cpmsftngxa10.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.reportingsvcs
>Lines: 273
>Path: cpmsftngxa10.phx.gbl
>Xref: cpmsftngxa10.phx.gbl
microsoft.public.sqlserver.reportingsvcs:40883
>NNTP-Posting-Host: TOMCATIMPORT1 10.201.218.122
>Hi Brian,
>I will be looking into this issue and I will update you
>once I have more information.
>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.
>=====================================================>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/suppor
t
>overview/40010469
>Others:
>https://partner.microsoft.com/US/technicalsupport/suppor
t
>overview/
>If you are outside the United States, please visit our
>International Support page:
>http://support.microsoft.com/default.aspx?scid=%2fintern
a
>tional.aspx.
>=====================================================>This posting is provided "AS IS" with no warranties,
and
>confers no rights.
>--
>>Thread-Topic: Orphaned Table Footers
>>thread-index: AcUDE9iY3e1yULFPQLmd8LylZ4RFtQ==>>X-WBNR-Posting-Host: 204.92.98.25
>>From: "=?Utf-8?B?QnJpYW4=?=" <Bri-Guy@.nospam.nospam>
>>References:
><C6FB5F66-C1CB-41A0-A449-620826ECF7D7@.microsoft.com>
><QmipjprAFHA.2768@.cpmsftngxa10.phx.gbl>
>>Subject: RE: Orphaned Table Footers
>>Date: Tue, 25 Jan 2005 11:27:02 -0800
>>Lines: 228
>>Message-ID:
><F2866859-4257-41B1-9F2F-FAACB7EEC085@.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: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
>>Xref: cpmsftngxa10.phx.gbl
>microsoft.public.sqlserver.reportingsvcs:40795
>>X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
>>Hello.
>>Sorry, I used some wrong terminology. Here are the
>clarifications.
>>1) -Page header is empty.
>>- it is the page footer that only shows the page number
>>2) -Table header row is deleted (I don't use it).
>>- RepeatOnNewPage property of the Table1_Group1 header
>is set to true. This
>>is the header that contains some summary data and I
>want it to repeat on each
>>page.
>>- Table Footer is included. RepeatOnNewPage property
is
>set to TRUE. This is
>>just an empty row with a bottom border. This repeats
on
>each page to give the
>>table a bottom border on each page.
>>
>>3) -Table1_Group1 Header RepeatOnNewPage Property is
>TRUE
>>-When I go "Edit Group", Page break at start, include
>group header, include
>>group footer, AND repeat group header are checked off.
>So both "Repeat Group
>>Header" is checked and RepeatOnNewPage property is
TRUE.
>>4) - Yes, I mean the Group Header of Table1_Group1
>>5) - Yes, I mean the Group Footer of Table1_Group1
>>I think this might be the problem:
>>The Group Headers will repeat on each page in the
print
>preview and when
>>exporting to PDF as long as the page displays data
from
>the Table Details
>>section or data from inner groups. But if the
Outermost
>group footer is
>>squeezed onto the next page by itself then the group
>header does not show.
>>I was able to replicate this problem using a very
>simple report.
>>Steps:
>>1) Create a new report. have the data set return only
1
>row to make things
>>simple (.EG Select Top 1 * from table).
>>2) Create a table in the body of the report
>>3) Get rid of the table header and the table footer.
so
>only the table
>>details section remains.
>>4) Add a group. Group on anything since only 1 row is
>returned by the query.
>> -so now there's 3 rows in the layout. Table1_Group1
>Header, Detail, and
>>Table1_Group1 Footer.
>>5) Type something into the table1_group1 header,
>> -Edit the group and check off
>>6) Drag a field into the body.
>>7) type something into the table1_Group1 footer.
footer
>only shows up at the
>>end of each group change and does not repeat on each
>page.
>>8) Now, make the detail row long, so that it just
>squeezes the table1_Group1
>>footer onto the next page in the print preview.
>>The Table1_Group1 Header will show up on the first
page
>along with the
>>detail row, but in the next page, only the
>table1_Group1 footer row shows.
>>The table1_Group1 header does not appear even though
it
>should repeat on each
>>page.
>>This happens in the Print Preview (NOT THE PREVIEW TAB
>OR WHEN VIEWING
>>ONLINE) and also when you export the report to PDF.
>Viewing the report just
>>online is fine.
>>For my real report, the table1_Group1 header always
>repeats fine except on
>>pages where only the table1_Group1 footer has been
>squeezed onto the next
>>page by itself.
>>Like I said, my report has 4 groups, each group gives
>subtotals at various
>>levels and the table1_Group1 Footer gives a grand
total
>for each set.
>>Hopefully the problem is clear now.
>>Thanks!
>>Brian.
>>"William Wang[MSFT]" wrote:
>> Hi Brian,
>> I'd like to get a clear understanding of your issue
>to
>> be able to assist you better.
>> >I have a report that uses one table in the body.
The
>> actual report header is
>> >empty and the actual report footer only shows the
>page
>> number. I use the
>> 1. In Reporting Services there is no sections called
>> Report Header or Report Footer although the black
>space
>> above/below the data region can be regarded as
Report
>> Header/Report Footer. Since "the actual report
footer
>> only shows the page number", I'd like to confirm if
>you
>> mean Page Header/Page Footer by saying Report
>> Header/Report Footer.
>>
>> >Table header and have "Repeat on New Page" set to
>True.
>> I use the table
>> >header instead because I need to display some
>summary
>> data at the top of each
>> >page.
>> 2. This is the second one I'd like to confirm. You
>set
>> the "RepeatOnNewPage" property of the Table Header
>> rather than the Group Header to true.
>>
>> >I have 4 groups total and the header of the
>outermost
>> group (table1_group1)
>> >is the one that repeats on each page.
>> 3. How did you do with the outermost group named
>> table1_group1 so that it repeats on each page? Did
>you
>> set the "RepeatOnNewPage" property of the Group
>Header
>> of this group to true or place a "Page Break at end"
>of
>> the group?
>>
>> >The reports display fine most of the time and the
>> Table1_group1 table header
>> 4. Here by saying "the Table1_group1 table header"
do
>> you mean the "group header of Table1_group1"?
>>
>> >repeats as it should, but whenever the spacing
works
>> out that the
>> >Table1_Footer1 table footer needs to start on a new
>> page,
>> 5. A Table Footer only appears at the end of a
table.
>> I'd like to confirm if you mean Table Footer or
Group
>> Footer of Table1_group1.
>>
>> >the footer prints
>> >on its own without the table header. The
>table1_Group1
>> table footer does not
>> >repeat on each page and only shows up as the last
>page
>> for each group as it
>> >shows some totals/sums.
>> >Any ideas on how to fix this so the Table_1Group1
>table
>> header will print
>> >even when only the Table1Group1 table footer is
>being
>> printed?
>> 6. Setting the "RepeatOnNewPage" property of the
>Group
>> Header to true should have no such a problem. By
>doing
>> this the group header repeats on each page.
>> For us, the most efficient troubleshooting method
>would
>> be reproducing this issue on our end. If the issue
>> persists, please try to reproduce the issue with a
>> sample database and post the detailed reproduce
steps.
>> If anything is unclear, get in touch.
>> Sincerely,
>> William Wang
>> Microsoft Online Partner Support
>> Get Secure! - <www.microsoft.com/security>
>> =====================================================>> 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: Orphaned Table Footers
>> >thread-index: AcUCWF6Szxan+iN7TLGB155pQjDGbg==>> >X-WBNR-Posting-Host: 204.92.98.25
>> >From: "=?Utf-8?B?QnJpYW4=?=" <Bri-Guy@.nospam.nospam>
>> >Subject: Orphaned Table Footers
>> >Date: Mon, 24 Jan 2005 13:05:01 -0800
>> >Lines: 20
>> >Message-ID:
>> <C6FB5F66-C1CB-41A0-A449-620826ECF7D7@.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: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
>> >Xref: cpmsftngxa10.phx.gbl
>> microsoft.public.sqlserver.reportingsvcs:40664
>> >X-Tomcat-NG:
microsoft.public.sqlserver.reportingsvcs
>> >
>> >Hello.
>> >
>> >I have a report that uses one table in the body.
The
>> actual report header is
>> >empty and the actual report footer only shows the
>page
>> number. I use the
>> >Table header and have "Repeat on New Page" set to
>True.
>> I use the table
>> >header instead because I need to display some
>summary
>> data at the top of each
>> >page.
>> >I have 4 groups total and the header of the
>outermost
>> group (table1_group1)
>> >is the one that repeats on each page.
>> >The reports display fine most of the time and the
>> Table1_group1 table header
>> >repeats as it should, but whenever the spacing
works
>> out that the
>> >Table1_Footer1 table footer needs to start on a new
>> page, the footer prints
>> >on its own without the table header. The
>table1_Group1
>> table footer does not
>> >repeat on each page and only shows up as the last
>page
>> for each group as it
>> >shows some totals/sums.
>> >Any ideas on how to fix this so the Table_1Group1
>table
>> header will print
>> >even when only the Table1Group1 table footer is
>being
>> printed?
>> >
>> >Thanks,
>> >Brian.
>> >
>>
>|||Hi William,
I have the same problem as Brian and need to find a solution.
Whilst I accept that pagination dictates that the footer will be forced
onto a new page, it seems to me that, where one section of the
group/table is rendered on a new page (in this case the footer), then
the header should also be repeated on that page.
Can you or the product team suggest a workaround for this issue ?
Dave Martin
William Wang[MSFT] wrote:
> Hi Brian,
> From the product team's feedback, in this case we've
> made the detail row tall enough that the header row plus
> the detail row plus the footer row is simply too big for
> a page.
> In the case of HTML and Preview, we use a flexible
> pagination algorithm that allows pages to grow somewhat
> to accommodate this sort of layout.
> In the case of PDF or Print Preview, we must respect the
> page size settings precisely.
> This is by design in Reporting Services. As an end user
> too, I can truly understand your concern about it.
> Currently we have some options for you regarding this
> issue:
> a. You may want to send a feature change request to
> mswish@.microsoft.com. By submitting your concern to
> mswish@.microsoft.com you can get your voice into the
> design plans for upcoming versions. Microsoft takes
> customer requests and suggestions very seriously. MSWISH
> is your voice to the development team. A significant
> number of the design change requests come from our
> customers through the MSWISH alias and the MSWISH web
> site. http://www.microsoft.com/mswish. I encourage you
> to submit this request.
> b. You can talk to the support engineers directly in
> Microsoft Product Support Services (PSS) to see if they
> can find a workaround or offer a fix. For a complete
> list of Microsoft Product Support Services phone
> numbers, please go to the following address on the World
> Wide Web:
> <http://support.microsoft.com/directory/overview.asp>
> If you are outside the US please see
> http://support.microsoft.com for regional support phone
> numbers.
> HTH!
> 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.
> --
>> X-Tomcat-ID: 215340416
>> References:
> <C6FB5F66-C1CB-41A0-A449-620826ECF7D7@.microsoft.com>
> <QmipjprAFHA.2768@.cpmsftngxa10.phx.gbl>
> <F2866859-4257-41B1-9F2F-FAACB7EEC085@.microsoft.com>
>> MIME-Version: 1.0
>> Content-Type: text/plain
>> Content-Transfer-Encoding: 7bit
>> From: v-rxwang@.online.microsoft.com (William Wang[MSFT])
>> Organization: Microsoft
>> Date: Wed, 26 Jan 2005 10:18:13 GMT
>> Subject: RE: Orphaned Table Footers
>> X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
>> Message-ID: <8rTWYB5AFHA.2504@.cpmsftngxa10.phx.gbl>
>> Newsgroups: microsoft.public.sqlserver.reportingsvcs
>> Lines: 273
>> Path: cpmsftngxa10.phx.gbl
>> Xref: cpmsftngxa10.phx.gbl
> microsoft.public.sqlserver.reportingsvcs:40883
>> NNTP-Posting-Host: TOMCATIMPORT1 10.201.218.122
>> Hi Brian,
>> I will be looking into this issue and I will update you
>> once I have more information.
>> 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.
>> =====================================================>> 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/suppor
> t
>> overview/40010469
>> Others:
>> https://partner.microsoft.com/US/technicalsupport/suppor
> t
>> overview/
>> If you are outside the United States, please visit our
>> International Support page:
>> http://support.microsoft.com/default.aspx?scid=%2fintern
> a
>> tional.aspx.
>> =====================================================>> This posting is provided "AS IS" with no warranties,
> and
>> confers no rights.
>> --
>> Thread-Topic: Orphaned Table Footers
>> thread-index: AcUDE9iY3e1yULFPQLmd8LylZ4RFtQ==>> X-WBNR-Posting-Host: 204.92.98.25
>> From: "=?Utf-8?B?QnJpYW4=?=" <Bri-Guy@.nospam.nospam>
>> References:
>> <C6FB5F66-C1CB-41A0-A449-620826ECF7D7@.microsoft.com>
>> <QmipjprAFHA.2768@.cpmsftngxa10.phx.gbl>
>> Subject: RE: Orphaned Table Footers
>> Date: Tue, 25 Jan 2005 11:27:02 -0800
>> Lines: 228
>> Message-ID:
>> <F2866859-4257-41B1-9F2F-FAACB7EEC085@.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: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
>> Xref: cpmsftngxa10.phx.gbl
>> microsoft.public.sqlserver.reportingsvcs:40795
>> X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
>> Hello.
>> Sorry, I used some wrong terminology. Here are the
>> clarifications.
>> 1) -Page header is empty.
>> - it is the page footer that only shows the page number
>> 2) -Table header row is deleted (I don't use it).
>> - RepeatOnNewPage property of the Table1_Group1 header
>> is set to true. This
>> is the header that contains some summary data and I
>> want it to repeat on each
>> page.
>> - Table Footer is included. RepeatOnNewPage property
> is
>> set to TRUE. This is
>> just an empty row with a bottom border. This repeats
> on
>> each page to give the
>> table a bottom border on each page.
>>
>> 3) -Table1_Group1 Header RepeatOnNewPage Property is
>> TRUE
>> -When I go "Edit Group", Page break at start, include
>> group header, include
>> group footer, AND repeat group header are checked off.
>> So both "Repeat Group
>> Header" is checked and RepeatOnNewPage property is
> TRUE.
>> 4) - Yes, I mean the Group Header of Table1_Group1
>> 5) - Yes, I mean the Group Footer of Table1_Group1
>> I think this might be the problem:
>> The Group Headers will repeat on each page in the
> print
>> preview and when
>> exporting to PDF as long as the page displays data
> from
>> the Table Details
>> section or data from inner groups. But if the
> Outermost
>> group footer is
>> squeezed onto the next page by itself then the group
>> header does not show.
>> I was able to replicate this problem using a very
>> simple report.
>> Steps:
>> 1) Create a new report. have the data set return only
> 1
>> row to make things
>> simple (.EG Select Top 1 * from table).
>> 2) Create a table in the body of the report
>> 3) Get rid of the table header and the table footer.
> so
>> only the table
>> details section remains.
>> 4) Add a group. Group on anything since only 1 row is
>> returned by the query.
>> -so now there's 3 rows in the layout. Table1_Group1
>> Header, Detail, and
>> Table1_Group1 Footer.
>> 5) Type something into the table1_group1 header,
>> -Edit the group and check off
>> 6) Drag a field into the body.
>> 7) type something into the table1_Group1 footer.
> footer
>> only shows up at the
>> end of each group change and does not repeat on each
>> page.
>> 8) Now, make the detail row long, so that it just
>> squeezes the table1_Group1
>> footer onto the next page in the print preview.
>> The Table1_Group1 Header will show up on the first
> page
>> along with the
>> detail row, but in the next page, only the
>> table1_Group1 footer row shows.
>> The table1_Group1 header does not appear even though
> it
>> should repeat on each
>> page.
>> This happens in the Print Preview (NOT THE PREVIEW TAB
>> OR WHEN VIEWING
>> ONLINE) and also when you export the report to PDF.
>> Viewing the report just
>> online is fine.
>> For my real report, the table1_Group1 header always
>> repeats fine except on
>> pages where only the table1_Group1 footer has been
>> squeezed onto the next
>> page by itself.
>> Like I said, my report has 4 groups, each group gives
>> subtotals at various
>> levels and the table1_Group1 Footer gives a grand
> total
>> for each set.
>> Hopefully the problem is clear now.
>> Thanks!
>> Brian.
>> "William Wang[MSFT]" wrote:
>> Hi Brian,
>> I'd like to get a clear understanding of your issue
>> to
>> be able to assist you better.
>> I have a report that uses one table in the body.
> The
>> actual report header is
>> empty and the actual report footer only shows the
>> page
>> number. I use the
>> 1. In Reporting Services there is no sections called
>> Report Header or Report Footer although the black
>> space
>> above/below the data region can be regarded as
> Report
>> Header/Report Footer. Since "the actual report
> footer
>> only shows the page number", I'd like to confirm if
>> you
>> mean Page Header/Page Footer by saying Report
>> Header/Report Footer.
>>
>> Table header and have "Repeat on New Page" set to
>> True.
>> I use the table
>> header instead because I need to display some
>> summary
>> data at the top of each
>> page.
>> 2. This is the second one I'd like to confirm. You
>> set
>> the "RepeatOnNewPage" property of the Table Header
>> rather than the Group Header to true.
>>
>> I have 4 groups total and the header of the
>> outermost
>> group (table1_group1)
>> is the one that repeats on each page.
>> 3. How did you do with the outermost group named
>> table1_group1 so that it repeats on each page? Did
>> you
>> set the "RepeatOnNewPage" property of the Group
>> Header
>> of this group to true or place a "Page Break at end"
>> of
>> the group?
>>
>> The reports display fine most of the time and the
>> Table1_group1 table header
>> 4. Here by saying "the Table1_group1 table header"
> do
>> you mean the "group header of Table1_group1"?
>>
>> repeats as it should, but whenever the spacing
> works
>> out that the
>> Table1_Footer1 table footer needs to start on a new
>> page,
>> 5. A Table Footer only appears at the end of a
> table.
>> I'd like to confirm if you mean Table Footer or
> Group
>> Footer of Table1_group1.
>>
>> the footer prints
>> on its own without the table header. The
>> table1_Group1
>> table footer does not
>> repeat on each page and only shows up as the last
>> page
>> for each group as it
>> shows some totals/sums.
>> Any ideas on how to fix this so the Table_1Group1
>> table
>> header will print
>> even when only the Table1Group1 table footer is
>> being
>> printed?
>> 6. Setting the "RepeatOnNewPage" property of the
>> Group
>> Header to true should have no such a problem. By
>> doing
>> this the group header repeats on each page.
>> For us, the most efficient troubleshooting method
>> would
>> be reproducing this issue on our end. If the issue
>> persists, please try to reproduce the issue with a
>> sample database and post the detailed reproduce
> steps.
>> If anything is unclear, get in touch.
>> Sincerely,
>> William Wang
>> Microsoft Online Partner Support
>> Get Secure! - <www.microsoft.com/security>
>> =====================================================>> 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: Orphaned Table Footers
>> thread-index: AcUCWF6Szxan+iN7TLGB155pQjDGbg==>> X-WBNR-Posting-Host: 204.92.98.25
>> From: "=?Utf-8?B?QnJpYW4=?=" <Bri-Guy@.nospam.nospam>
>> Subject: Orphaned Table Footers
>> Date: Mon, 24 Jan 2005 13:05:01 -0800
>> Lines: 20
>> Message-ID:
>> <C6FB5F66-C1CB-41A0-A449-620826ECF7D7@.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: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
>> Xref: cpmsftngxa10.phx.gbl
>> microsoft.public.sqlserver.reportingsvcs:40664
>> X-Tomcat-NG:
> microsoft.public.sqlserver.reportingsvcs
>> Hello.
>> I have a report that uses one table in the body.
> The
>> actual report header is
>> empty and the actual report footer only shows the
>> page
>> number. I use the
>> Table header and have "Repeat on New Page" set to
>> True.
>> I use the table
>> header instead because I need to display some
>> summary
>> data at the top of each
>> page.
>> I have 4 groups total and the header of the
>> outermost
>> group (table1_group1)
>> is the one that repeats on each page.
>> The reports display fine most of the time and the
>> Table1_group1 table header
>> repeats as it should, but whenever the spacing
> works
>> out that the
>> Table1_Footer1 table footer needs to start on a new
>> page, the footer prints
>> on its own without the table header. The
>> table1_Group1
>> table footer does not
>> repeat on each page and only shows up as the last
>> page
>> for each group as it
>> shows some totals/sums.
>> Any ideas on how to fix this so the Table_1Group1
>> table
>> header will print
>> even when only the Table1Group1 table footer is
>> being
>> printed?
>> Thanks,
>> Brian.
>>
>