Hey everyone, does anyonw know how to output a report directly to PDF?
That is, without passing any parameters, but defaulted in the report
itslef. So a user would not have a choice to view it in the report
manager?I think the only way to do this is to have your own frontend. No way to
configure the server to do this (I think it would be a bad idea overal, PDFs
are much much slower and more compute intensive). I agree for some reports
it would be nice to mark it as rendering only in a certain format. But, no
capability for that exists.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<Daniel.P.Lyonnais@.lmco.com> wrote in message
news:1131047107.559743.200760@.f14g2000cwb.googlegroups.com...
> Hey everyone, does anyonw know how to output a report directly to PDF?
> That is, without passing any parameters, but defaulted in the report
> itslef. So a user would not have a choice to view it in the report
> manager?
>|||Daniel;
You can simply render the report as a PDF file as shown below. Will that do
what you need?
Wayne
=======================================Private Sub Page_Load(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles MyBase.Load
Dim rs1 As New Wedding.rs.ReportingService
rs1.Credentials = New System.Net.NetworkCredential("myServer", "tmyPW", "")
Dim results As Byte(), image As Byte()
Dim streamids As String(), streamid As String
' Render the report to HTML4.0
results = rs1.Render(Session("ReportPath"), "PDF", _
Nothing,
"<DeviceInfo><StreamRoot>/WebApplication1/</StreamRoot></DeviceInfo>",
Nothing, _
Nothing, Nothing, Nothing, Nothing, Nothing, Nothing, streamids)
Response.BinaryWrite(results)
End Sub
<Daniel.P.Lyonnais@.lmco.com> wrote in message
news:1131047107.559743.200760@.f14g2000cwb.googlegroups.com...
> Hey everyone, does anyonw know how to output a report directly to PDF?
> That is, without passing any parameters, but defaulted in the report
> itslef. So a user would not have a choice to view it in the report
> manager?
>sql
Showing posts with label report. Show all posts
Showing posts with label report. Show all posts
Friday, March 30, 2012
Output 10 rows
Hi! I am a newbie, need to make a report with only 10 rows, and not the whole result. How do I actually specify the output as 10 rows?
Thank you so much in advance!
Thank you so much in advance!
Depends on your exact circumstances.
If you want show 10 per page then you need to
put a list control in the body|||Thank you som much!
SELECT TOP 10 SUM(cd.price) as Sales, ... gave me a list of the most sold CD's + sales figures. How if I want a list including numbers (1 Elton John, 2 Madonna 3, 4, 5, 6, 7,8,9,10etc)
How do I make a list and a sequence of numbers on a report?
Moreover I wonder how to define sales per age-groups? I have a file "age" of customers, need to create groups(<16, 16-20, 21-30 etc) and select sales per group. How do I do this?
|||
curiousss wrote:
Moreover I wonder how to define sales per age-groups? I have a file "age" of customers, need to create groups(<16, 16-20, 21-30 etc) and select sales per group. How do I do this?
You can use a nested IIF within the group criteria to do this.
=IIF(Age < 16, "<16",IIF(Age <21,"16-20),IIF(Age<31,"21-30",">30")))
Note matching the parens can be a pain, but I am sure you will figure it out.
|||Further to this, to create a sequence of numbers just use the RowNumber function.
=CStr(RowNumber(Nothing)) + " " + Fields!Album.Value
Output 10 rows
Hi! I am a newbie, need to make a report with only 10 rows, and not the whole result. How do I actually specify the output as 10 rows?
Thank you so much in advance!
Thank you so much in advance!
Depends on your exact circumstances.
If you want show 10 per page then you need to
put a list control in the body|||Thank you som much!
SELECT TOP 10 SUM(cd.price) as Sales, ... gave me a list of the most sold CD's + sales figures. How if I want a list including numbers (1 Elton John, 2 Madonna 3, 4, 5, 6, 7,8,9,10etc)
How do I make a list and a sequence of numbers on a report?
Moreover I wonder how to define sales per age-groups? I have a file "age" of customers, need to create groups(<16, 16-20, 21-30 etc) and select sales per group. How do I do this?
|||
Moreover I wonder how to define sales per age-groups? I have a file "age" of customers, need to create groups(<16, 16-20, 21-30 etc) and select sales per group. How do I do this?
You can use a nested IIF within the group criteria to do this.
=IIF(Age < 16, "<16",IIF(Age <21,"16-20),IIF(Age<31,"21-30",">30")))
Note matching the parens can be a pain, but I am sure you will figure it out.
|||Further to this, to create a sequence of numbers just use the RowNumber function.
=CStr(RowNumber(Nothing)) + " " + Fields!Album.Value
Wednesday, March 28, 2012
Outlook 2002 and Report Services Attachments
When a subscription send an email with the report attached, Outlook 2002 does
not show that there is an attachment or have the ability to open it.
I have tested this by using Outlook 2003 and a Web Email Client to get the
same email, and the attachment is present in all cases except for Outlook
2002. I have also forwarded the email from Outlook 2003 to 2002 and the
attachment is not present, but if I save the attachment in Outlook 2003 and
attach it to an email and send it to 2002 the attachment is available.
--
HaroldsHi Harolds,
- Does your attachment contains all English language information?
- What's the mail server you are using? Exchange Server 2000 or Exchange
Server 2003?
- Have you upgraded to the latest version of SQL Server 2000 Reporting
Services SP2 or SQL Server 2005 Reporting Services?
Sincerely yours,
Michael Cheng
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.|||-Yes the attachment contains all English language information.
-We do not use exchange server
-I am not sure but I believe we are using SP2, how would I know which
version of SQL Server 2000 Reporting services we are using.
--
Harolds
"Michael Cheng [MSFT]" wrote:
> Hi Harolds,
> - Does your attachment contains all English language information?
> - What's the mail server you are using? Exchange Server 2000 or Exchange
> Server 2003?
> - Have you upgraded to the latest version of SQL Server 2000 Reporting
> Services SP2 or SQL Server 2005 Reporting Services?
> Sincerely yours,
> Michael Cheng
> 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.
>|||Hi,
If you are not using Exchange Server, what mail server you are using? We
have an known issue with IBM Lotus Domino servers as it cannot load the
attachment, and the reports appear as a zero-byte file attachment. Check
the KB below for more detailed information.
FIX: You may receive a zero-byte attachment in e-mail when e-mail
subscriptions are sent to Lotus Domino e-mail servers by SQL Server 2000
Reporting Services
http://support.microsoft.com/?id=872774
To identify whether you have upgraded to SQL Server 2000 Service Pack 2,
you may go to the report server via link <http://<machine>/reportserver> to
see the bottom line
If it appears to be 8.00.1038, you have upgraded to SP2
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
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.|||This problem is not in the mail server, because Outlook 2003 has NO problems
with the attachment, also the mail server (CommuniGate Pro) has a web
interface for which it also has NO problems with the attachment. The problem
is that Outlook 2002 doesn't recognize the fact that the email from the
report server has an attachment.
--
Harolds
"Michael Cheng [MSFT]" wrote:
> Hi,
> If you are not using Exchange Server, what mail server you are using? We
> have an known issue with IBM Lotus Domino servers as it cannot load the
> attachment, and the reports appear as a zero-byte file attachment. Check
> the KB below for more detailed information.
> FIX: You may receive a zero-byte attachment in e-mail when e-mail
> subscriptions are sent to Lotus Domino e-mail servers by SQL Server 2000
> Reporting Services
> http://support.microsoft.com/?id=872774
> To identify whether you have upgraded to SQL Server 2000 Service Pack 2,
> you may go to the report server via link <http://<machine>/reportserver> to
> see the bottom line
> If it appears to be 8.00.1038, you have upgraded to SP2
> Thank you for your patience and cooperation. If you have any questions or
> concerns, don't hesitate to let me know. We are always here to be of
> assistance!
>
> Sincerely yours,
> Michael Cheng
> 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.
>|||Hi Harolds,
I understand it is only Outlook 2002 that you will encounter the error
with. However, we must check the whole process internally from Reporting
Services to Mail Server and Outlook 2002. This work had be to done by
opening a Support incident with Microsoft Customer Service and Support so
that a dedicated Support Professional can assist with this case. If you
need any help in this regard, please let me know.
For a complete list of Microsoft Customer Service and Support phone
numbers, please go to the following address on the World Wide Web:
http://support.microsoft.com/directory/overview.asp
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
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.sql
not show that there is an attachment or have the ability to open it.
I have tested this by using Outlook 2003 and a Web Email Client to get the
same email, and the attachment is present in all cases except for Outlook
2002. I have also forwarded the email from Outlook 2003 to 2002 and the
attachment is not present, but if I save the attachment in Outlook 2003 and
attach it to an email and send it to 2002 the attachment is available.
--
HaroldsHi Harolds,
- Does your attachment contains all English language information?
- What's the mail server you are using? Exchange Server 2000 or Exchange
Server 2003?
- Have you upgraded to the latest version of SQL Server 2000 Reporting
Services SP2 or SQL Server 2005 Reporting Services?
Sincerely yours,
Michael Cheng
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.|||-Yes the attachment contains all English language information.
-We do not use exchange server
-I am not sure but I believe we are using SP2, how would I know which
version of SQL Server 2000 Reporting services we are using.
--
Harolds
"Michael Cheng [MSFT]" wrote:
> Hi Harolds,
> - Does your attachment contains all English language information?
> - What's the mail server you are using? Exchange Server 2000 or Exchange
> Server 2003?
> - Have you upgraded to the latest version of SQL Server 2000 Reporting
> Services SP2 or SQL Server 2005 Reporting Services?
> Sincerely yours,
> Michael Cheng
> 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.
>|||Hi,
If you are not using Exchange Server, what mail server you are using? We
have an known issue with IBM Lotus Domino servers as it cannot load the
attachment, and the reports appear as a zero-byte file attachment. Check
the KB below for more detailed information.
FIX: You may receive a zero-byte attachment in e-mail when e-mail
subscriptions are sent to Lotus Domino e-mail servers by SQL Server 2000
Reporting Services
http://support.microsoft.com/?id=872774
To identify whether you have upgraded to SQL Server 2000 Service Pack 2,
you may go to the report server via link <http://<machine>/reportserver> to
see the bottom line
If it appears to be 8.00.1038, you have upgraded to SP2
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
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.|||This problem is not in the mail server, because Outlook 2003 has NO problems
with the attachment, also the mail server (CommuniGate Pro) has a web
interface for which it also has NO problems with the attachment. The problem
is that Outlook 2002 doesn't recognize the fact that the email from the
report server has an attachment.
--
Harolds
"Michael Cheng [MSFT]" wrote:
> Hi,
> If you are not using Exchange Server, what mail server you are using? We
> have an known issue with IBM Lotus Domino servers as it cannot load the
> attachment, and the reports appear as a zero-byte file attachment. Check
> the KB below for more detailed information.
> FIX: You may receive a zero-byte attachment in e-mail when e-mail
> subscriptions are sent to Lotus Domino e-mail servers by SQL Server 2000
> Reporting Services
> http://support.microsoft.com/?id=872774
> To identify whether you have upgraded to SQL Server 2000 Service Pack 2,
> you may go to the report server via link <http://<machine>/reportserver> to
> see the bottom line
> If it appears to be 8.00.1038, you have upgraded to SP2
> Thank you for your patience and cooperation. If you have any questions or
> concerns, don't hesitate to let me know. We are always here to be of
> assistance!
>
> Sincerely yours,
> Michael Cheng
> 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.
>|||Hi Harolds,
I understand it is only Outlook 2002 that you will encounter the error
with. However, we must check the whole process internally from Reporting
Services to Mail Server and Outlook 2002. This work had be to done by
opening a Support incident with Microsoft Customer Service and Support so
that a dedicated Support Professional can assist with this case. If you
need any help in this regard, please let me know.
For a complete list of Microsoft Customer Service and Support phone
numbers, please go to the following address on the World Wide Web:
http://support.microsoft.com/directory/overview.asp
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
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.sql
Outer Joins in Report Model
Hi,
I already posted that in the MSDN technical forums... But I hope that here
are some other experts perhaps knowing what to do...
Just imagine you have two tables, i.e. customers and notes. You can have one
or more notes per customer. Your database has "clean" primary and foreing
keys defined for that scenario. You build a report model on it. The roles
are detected correctly, so there is a "optional many" cardinality on the one
side and a "one" cardinality on the other. However if you use this in a
report and grab the SQL using the SQL Profiler you'll see that an inner join
is used instead of an outer join (because you defined "OPTIONAL many" in the
model).
So what is this?
Please mark the correct answer:
( ) My fault (explain below)
( ) Bug
( ) Feature (explain below)
_______________________________________________________
Thanks ;-)
ThomasIt's pretty ambiguous whether an INNER JOIN or OUTER JOIN should be used,
without knowing the subject matter being reported.
Consider the case of a referral bonus report, where any employee can make a
referral. That's an optional condition, but you would only want those
employees who made the referral to appear. So there has to be some
discretion left to the report developer.
--
Cheers,
'(' Jeff A. Stucker
\
Senior Consultant
www.rapidigm.com
"Thomas Pagel" <thomas.pagel@.community.nospam> wrote in message
news:O4cMFut5FHA.2888@.tk2msftngp13.phx.gbl...
> Hi,
> I already posted that in the MSDN technical forums... But I hope that here
> are some other experts perhaps knowing what to do...
> Just imagine you have two tables, i.e. customers and notes. You can have
> one or more notes per customer. Your database has "clean" primary and
> foreing keys defined for that scenario. You build a report model on it.
> The roles are detected correctly, so there is a "optional many"
> cardinality on the one side and a "one" cardinality on the other. However
> if you use this in a report and grab the SQL using the SQL Profiler you'll
> see that an inner join is used instead of an outer join (because you
> defined "OPTIONAL many" in the model).
> So what is this?
> Please mark the correct answer:
> ( ) My fault (explain below)
> ( ) Bug
> ( ) Feature (explain below)
> _______________________________________________________
>
> Thanks ;-)
>
> Thomas
>|||Jeff,
but why do you have cardinality attributes like "optional many"? I think
that defines exactly what you want! And why isn't that used? And your case
would be handled by a simple filter...
Thanks,
Thomas
"Jeff A. Stucker" <jeff@.mobilize.net> wrote in message
news:%23sIqudv5FHA.1276@.TK2MSFTNGP10.phx.gbl...
> It's pretty ambiguous whether an INNER JOIN or OUTER JOIN should be used,
> without knowing the subject matter being reported.
> Consider the case of a referral bonus report, where any employee can make
> a referral. That's an optional condition, but you would only want those
> employees who made the referral to appear. So there has to be some
> discretion left to the report developer.
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Senior Consultant
> www.rapidigm.com
> "Thomas Pagel" <thomas.pagel@.community.nospam> wrote in message
> news:O4cMFut5FHA.2888@.tk2msftngp13.phx.gbl...
>> Hi,
>> I already posted that in the MSDN technical forums... But I hope that
>> here are some other experts perhaps knowing what to do...
>> Just imagine you have two tables, i.e. customers and notes. You can have
>> one or more notes per customer. Your database has "clean" primary and
>> foreing keys defined for that scenario. You build a report model on it.
>> The roles are detected correctly, so there is a "optional many"
>> cardinality on the one side and a "one" cardinality on the other. However
>> if you use this in a report and grab the SQL using the SQL Profiler
>> you'll see that an inner join is used instead of an outer join (because
>> you defined "OPTIONAL many" in the model).
>> So what is this?
>> Please mark the correct answer:
>> ( ) My fault (explain below)
>> ( ) Bug
>> ( ) Feature (explain below)
>> _______________________________________________________
>>
>> Thanks ;-)
>>
>> Thomas
>|||Hi Thomas,
Welcome to MSDN Managed Newsgorup!
I understood you concern is why inner join is used instead of outer join
since "optional many" defined. If I have misunderstood your concern, please
feel free to point it out.
Yes, I have tested it on my side and I believe this is a "by design"
feature of Report Model.
Sincerely yours,
Michael Cheng
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.|||Michael,
thanks for the reply... That's really bad news and I really don't understand
what the use of the cardinally attribute is if it's not used...
Thomas
"Michael Cheng [MSFT]" <v-mingqc@.online.microsoft.com> wrote in message
news:tu4xGR26FHA.1236@.TK2MSFTNGXA02.phx.gbl...
> Hi Thomas,
> Welcome to MSDN Managed Newsgorup!
> I understood you concern is why inner join is used instead of outer join
> since "optional many" defined. If I have misunderstood your concern,
> please
> feel free to point it out.
> Yes, I have tested it on my side and I believe this is a "by design"
> feature of Report Model.
>
> Sincerely yours,
> Michael Cheng
> 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.
>|||Hi Thomas,
I have submit this to our development team via internal channel. If there
is any update, I will reply here.
You are also encouraged to submit this feeling to the MSDN Product Feedback
Center below
http://lab.msdn.microsoft.com/productfeedback/default.aspx
Thanks so much for your feedback and question.
Sincerely yours,
Michael Cheng
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.
I already posted that in the MSDN technical forums... But I hope that here
are some other experts perhaps knowing what to do...
Just imagine you have two tables, i.e. customers and notes. You can have one
or more notes per customer. Your database has "clean" primary and foreing
keys defined for that scenario. You build a report model on it. The roles
are detected correctly, so there is a "optional many" cardinality on the one
side and a "one" cardinality on the other. However if you use this in a
report and grab the SQL using the SQL Profiler you'll see that an inner join
is used instead of an outer join (because you defined "OPTIONAL many" in the
model).
So what is this?
Please mark the correct answer:
( ) My fault (explain below)
( ) Bug
( ) Feature (explain below)
_______________________________________________________
Thanks ;-)
ThomasIt's pretty ambiguous whether an INNER JOIN or OUTER JOIN should be used,
without knowing the subject matter being reported.
Consider the case of a referral bonus report, where any employee can make a
referral. That's an optional condition, but you would only want those
employees who made the referral to appear. So there has to be some
discretion left to the report developer.
--
Cheers,
'(' Jeff A. Stucker
\
Senior Consultant
www.rapidigm.com
"Thomas Pagel" <thomas.pagel@.community.nospam> wrote in message
news:O4cMFut5FHA.2888@.tk2msftngp13.phx.gbl...
> Hi,
> I already posted that in the MSDN technical forums... But I hope that here
> are some other experts perhaps knowing what to do...
> Just imagine you have two tables, i.e. customers and notes. You can have
> one or more notes per customer. Your database has "clean" primary and
> foreing keys defined for that scenario. You build a report model on it.
> The roles are detected correctly, so there is a "optional many"
> cardinality on the one side and a "one" cardinality on the other. However
> if you use this in a report and grab the SQL using the SQL Profiler you'll
> see that an inner join is used instead of an outer join (because you
> defined "OPTIONAL many" in the model).
> So what is this?
> Please mark the correct answer:
> ( ) My fault (explain below)
> ( ) Bug
> ( ) Feature (explain below)
> _______________________________________________________
>
> Thanks ;-)
>
> Thomas
>|||Jeff,
but why do you have cardinality attributes like "optional many"? I think
that defines exactly what you want! And why isn't that used? And your case
would be handled by a simple filter...
Thanks,
Thomas
"Jeff A. Stucker" <jeff@.mobilize.net> wrote in message
news:%23sIqudv5FHA.1276@.TK2MSFTNGP10.phx.gbl...
> It's pretty ambiguous whether an INNER JOIN or OUTER JOIN should be used,
> without knowing the subject matter being reported.
> Consider the case of a referral bonus report, where any employee can make
> a referral. That's an optional condition, but you would only want those
> employees who made the referral to appear. So there has to be some
> discretion left to the report developer.
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Senior Consultant
> www.rapidigm.com
> "Thomas Pagel" <thomas.pagel@.community.nospam> wrote in message
> news:O4cMFut5FHA.2888@.tk2msftngp13.phx.gbl...
>> Hi,
>> I already posted that in the MSDN technical forums... But I hope that
>> here are some other experts perhaps knowing what to do...
>> Just imagine you have two tables, i.e. customers and notes. You can have
>> one or more notes per customer. Your database has "clean" primary and
>> foreing keys defined for that scenario. You build a report model on it.
>> The roles are detected correctly, so there is a "optional many"
>> cardinality on the one side and a "one" cardinality on the other. However
>> if you use this in a report and grab the SQL using the SQL Profiler
>> you'll see that an inner join is used instead of an outer join (because
>> you defined "OPTIONAL many" in the model).
>> So what is this?
>> Please mark the correct answer:
>> ( ) My fault (explain below)
>> ( ) Bug
>> ( ) Feature (explain below)
>> _______________________________________________________
>>
>> Thanks ;-)
>>
>> Thomas
>|||Hi Thomas,
Welcome to MSDN Managed Newsgorup!
I understood you concern is why inner join is used instead of outer join
since "optional many" defined. If I have misunderstood your concern, please
feel free to point it out.
Yes, I have tested it on my side and I believe this is a "by design"
feature of Report Model.
Sincerely yours,
Michael Cheng
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.|||Michael,
thanks for the reply... That's really bad news and I really don't understand
what the use of the cardinally attribute is if it's not used...
Thomas
"Michael Cheng [MSFT]" <v-mingqc@.online.microsoft.com> wrote in message
news:tu4xGR26FHA.1236@.TK2MSFTNGXA02.phx.gbl...
> Hi Thomas,
> Welcome to MSDN Managed Newsgorup!
> I understood you concern is why inner join is used instead of outer join
> since "optional many" defined. If I have misunderstood your concern,
> please
> feel free to point it out.
> Yes, I have tested it on my side and I believe this is a "by design"
> feature of Report Model.
>
> Sincerely yours,
> Michael Cheng
> 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.
>|||Hi Thomas,
I have submit this to our development team via internal channel. If there
is any update, I will reply here.
You are also encouraged to submit this feeling to the MSDN Product Feedback
Center below
http://lab.msdn.microsoft.com/productfeedback/default.aspx
Thanks so much for your feedback and question.
Sincerely yours,
Michael Cheng
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.
Monday, March 26, 2012
Outer Join Issues - Please Help
I am working on the record source for a report to produce monthly customer statements. Thanks to everyone here, I have been able to overcome many, many hurdles I have encountered. I just have one last issue I need to get resolved (famous last words, I know).
At the heart of my record source are two entities:
1. AROPNFIL - A table of all Accounts Receivable items (invoices, payments, credits, etc.)
2. fnBalance(@.StartDate) - A table valued function that gives me the starting balance for a customer on a particular date by summing the net Amounts of all items in the AROPNFIL that occured before the @.startdate. (i.e. Invoices have a positive amount, payments have a negative amount, so they net out so that only unpaid invoices remain.)
These are joined on customer_number. The query also selects only the rows in the AROPNFIL table that are between @.StartDate and @.EndDate for the month.
Everything was going great until...I realized that no statement was being created for a customer if they didn't have any activity in the current month, even though they had a starting balance.
So I tried an outer join, telling the query to select all rows from the fnBalance table. But that still wasn't returning the rows I wanted. After several hours of cursing and feeling the need for a drink, I realized why that wasn't working. Because the customer in question, let's call it "Coast01" had rows in the AROPNFIL table before the @.StartDate, it was seeing that as having completed the join and hence no reason to return a row for that starting balance.
So, this is what I need, a way to write what I am going to try to interpret as the following.
Select *
From (AROPNFIL WHERE Doc_date BETWEEN @.StartDate AND @.EndDate) RIGHT OUTER JOIN fnBalance(@.StartDate)
Does that make sense? I need the join with fnBalance to take place after the query has selected only the rows between @.startdate and @.enddate so that the row for the balance for "Coast01" will appear even though there is no activity in the current month.
But I am at a loss for how to write that in the FROM and WHERE clauses. I guess one way would be to create a query selecting rows from AROPNFIL WHERE doc_date BETWEEN @.StartDate AND @.EndDate and then create another query performing the outer join between that query and fnBalance, but I don't really want to do that because the rest of my record source query is actually a lot more complicated than what I've explained here, and I'd rather not have to create additional queries if I don't have to. But if you guys tell me there is no other way, I'll believe you.
Thank you all!Actually, I think I'm on the right path here using a derived table, please correct me if I'm wrong:
SELECT *
FROM (SELECT * FROM
AROPNFIL WHERE Doc_date BETWEEN @.StartDate AND @.EndDate) RIGHT OUTER JOIN
fnBalance(@.StartDate) StartBalance ON AROPNFIL.cus_no = StartBalance.cus_no
Obviously, I'll get rid of the *s, but no one here cares about what columns I'm actually pulling out.|||This is correct, I got it to work!!!
At the heart of my record source are two entities:
1. AROPNFIL - A table of all Accounts Receivable items (invoices, payments, credits, etc.)
2. fnBalance(@.StartDate) - A table valued function that gives me the starting balance for a customer on a particular date by summing the net Amounts of all items in the AROPNFIL that occured before the @.startdate. (i.e. Invoices have a positive amount, payments have a negative amount, so they net out so that only unpaid invoices remain.)
These are joined on customer_number. The query also selects only the rows in the AROPNFIL table that are between @.StartDate and @.EndDate for the month.
Everything was going great until...I realized that no statement was being created for a customer if they didn't have any activity in the current month, even though they had a starting balance.
So I tried an outer join, telling the query to select all rows from the fnBalance table. But that still wasn't returning the rows I wanted. After several hours of cursing and feeling the need for a drink, I realized why that wasn't working. Because the customer in question, let's call it "Coast01" had rows in the AROPNFIL table before the @.StartDate, it was seeing that as having completed the join and hence no reason to return a row for that starting balance.
So, this is what I need, a way to write what I am going to try to interpret as the following.
Select *
From (AROPNFIL WHERE Doc_date BETWEEN @.StartDate AND @.EndDate) RIGHT OUTER JOIN fnBalance(@.StartDate)
Does that make sense? I need the join with fnBalance to take place after the query has selected only the rows between @.startdate and @.enddate so that the row for the balance for "Coast01" will appear even though there is no activity in the current month.
But I am at a loss for how to write that in the FROM and WHERE clauses. I guess one way would be to create a query selecting rows from AROPNFIL WHERE doc_date BETWEEN @.StartDate AND @.EndDate and then create another query performing the outer join between that query and fnBalance, but I don't really want to do that because the rest of my record source query is actually a lot more complicated than what I've explained here, and I'd rather not have to create additional queries if I don't have to. But if you guys tell me there is no other way, I'll believe you.
Thank you all!Actually, I think I'm on the right path here using a derived table, please correct me if I'm wrong:
SELECT *
FROM (SELECT * FROM
AROPNFIL WHERE Doc_date BETWEEN @.StartDate AND @.EndDate) RIGHT OUTER JOIN
fnBalance(@.StartDate) StartBalance ON AROPNFIL.cus_no = StartBalance.cus_no
Obviously, I'll get rid of the *s, but no one here cares about what columns I'm actually pulling out.|||This is correct, I got it to work!!!
Wednesday, March 21, 2012
Out of Memory Exception
I'm getting an out of memory exception when designing by report model and
selecting save. I'm using 64bit windows xp 4Gb Ram and two dual core xeons
so presumably this is a bug! Anyone have any ideas?Hello Phil,
I would like to know whether there is any related error in the Report Log
File.
Would you please try to check the Report log File and post the error here
for me to troubleshooting?
By default, the log file is located at \Microsoft SQL Server\<SQL Server
Instance>\Reporting Services\LogFiles.
Please let me know the resault. Thank you!
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Hi Phil,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Supportsql
selecting save. I'm using 64bit windows xp 4Gb Ram and two dual core xeons
so presumably this is a bug! Anyone have any ideas?Hello Phil,
I would like to know whether there is any related error in the Report Log
File.
Would you please try to check the Report log File and post the error here
for me to troubleshooting?
By default, the log file is located at \Microsoft SQL Server\<SQL Server
Instance>\Reporting Services\LogFiles.
Please let me know the resault. Thank you!
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Hi Phil,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Supportsql
Out of memory error when running large report
I have built a large report but when I try to execute inside of the Report
Designer, I get the following error and then an abort:
[An error has occurred during report processing
Exception of type System.OutOfMemoryException was thrown]
I have applied SRS SP1 and here is the MSD info:
Microsoft Visual Basic .NET 69457-005-1826837-18410
Microsoft SQL Server Report Designer Version 8.00.878.00
Running on XP SP2 with 1.25 gig RAM
Is there a work-around for this?
Thanks for any help!http://support.microsoft.com/?kbid=840709
This article may help you.
| From: "Mike Harbinger" <MikeH@.Cybervillage.net>
| Subject: Out of memory error when running large report
| Date: Thu, 6 Jan 2005 18:47:55 -0800
| Lines: 18
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
| X-RFC2646: Format=Flowed; Original
| Message-ID: <#$rvPNG9EHA.1408@.TK2MSFTNGP10.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: 69.106.50.114
| Path:
cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP10|||Thanks for the reponse Brad, but I am not getting the error from the report
server but from inside of the .Net Visual Studio Reporting Services
designer.
""Brad Syputa - MS"" <bradsy@.Online.Microsoft.com> wrote in message
news:g7L9ZjO9EHA.3200@.cpmsftngxa10.phx.gbl...
> http://support.microsoft.com/?kbid=840709
> This article may help you.
>
> --
> | From: "Mike Harbinger" <MikeH@.Cybervillage.net>
> | Subject: Out of memory error when running large report
> | Date: Thu, 6 Jan 2005 18:47:55 -0800
> | Lines: 18
> | X-Priority: 3
> | X-MSMail-Priority: Normal
> | X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
> | X-RFC2646: Format=Flowed; Original
> | Message-ID: <#$rvPNG9EHA.1408@.TK2MSFTNGP10.phx.gbl>
> | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | NNTP-Posting-Host: 69.106.50.114
> | Path:
> cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP10
> phx.gbl
> | Xref: cpmsftngxa10.phx.gbl
> microsoft.public.sqlserver.reportingsvcs:38909
> | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> |
> | I have built a large report but when I try to execute inside of the
> Report
> | Designer, I get the following error and then an abort:
> |
> | [An error has occurred during report processing
> | Exception of type System.OutOfMemoryException was thrown]
> |
> |
> | I have applied SRS SP1 and here is the MSD info:
> | Microsoft Visual Basic .NET 69457-005-1826837-18410
> | Microsoft SQL Server Report Designer Version 8.00.878.00
> |
> | Running on XP SP2 with 1.25 gig RAM
> |
> | Is there a work-around for this?
> |
> | Thanks for any help!
> |
> |
> |
>
Designer, I get the following error and then an abort:
[An error has occurred during report processing
Exception of type System.OutOfMemoryException was thrown]
I have applied SRS SP1 and here is the MSD info:
Microsoft Visual Basic .NET 69457-005-1826837-18410
Microsoft SQL Server Report Designer Version 8.00.878.00
Running on XP SP2 with 1.25 gig RAM
Is there a work-around for this?
Thanks for any help!http://support.microsoft.com/?kbid=840709
This article may help you.
| From: "Mike Harbinger" <MikeH@.Cybervillage.net>
| Subject: Out of memory error when running large report
| Date: Thu, 6 Jan 2005 18:47:55 -0800
| Lines: 18
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
| X-RFC2646: Format=Flowed; Original
| Message-ID: <#$rvPNG9EHA.1408@.TK2MSFTNGP10.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: 69.106.50.114
| Path:
cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP10|||Thanks for the reponse Brad, but I am not getting the error from the report
server but from inside of the .Net Visual Studio Reporting Services
designer.
""Brad Syputa - MS"" <bradsy@.Online.Microsoft.com> wrote in message
news:g7L9ZjO9EHA.3200@.cpmsftngxa10.phx.gbl...
> http://support.microsoft.com/?kbid=840709
> This article may help you.
>
> --
> | From: "Mike Harbinger" <MikeH@.Cybervillage.net>
> | Subject: Out of memory error when running large report
> | Date: Thu, 6 Jan 2005 18:47:55 -0800
> | Lines: 18
> | X-Priority: 3
> | X-MSMail-Priority: Normal
> | X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
> | X-RFC2646: Format=Flowed; Original
> | Message-ID: <#$rvPNG9EHA.1408@.TK2MSFTNGP10.phx.gbl>
> | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | NNTP-Posting-Host: 69.106.50.114
> | Path:
> cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP10
> phx.gbl
> | Xref: cpmsftngxa10.phx.gbl
> microsoft.public.sqlserver.reportingsvcs:38909
> | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> |
> | I have built a large report but when I try to execute inside of the
> Report
> | Designer, I get the following error and then an abort:
> |
> | [An error has occurred during report processing
> | Exception of type System.OutOfMemoryException was thrown]
> |
> |
> | I have applied SRS SP1 and here is the MSD info:
> | Microsoft Visual Basic .NET 69457-005-1826837-18410
> | Microsoft SQL Server Report Designer Version 8.00.878.00
> |
> | Running on XP SP2 with 1.25 gig RAM
> |
> | Is there a work-around for this?
> |
> | Thanks for any help!
> |
> |
> |
>
Out of memory error
I'm trying to generate a very large report. My server's got 32 gigs of memory though, so memory shouldn't be an issue. However, when I try to generate my report, I get the following outofmemory error message in the error log on the server:
EventType clr20r3, P1 w3wp.exe, P2 6.0.3790.3959, P3 45d6968e, P4 mscorlib, P5 2.0.0.0, P6 4333ab80, P7 116e, P8 29, P9 system.outofmemoryexception, P10 NIL.
The w3wp.exe process maxes out at ~1,250 MB. I imagine I just have to change a setting somewhere to allow this to grow beyond that, but I can't seem to find that setting. What do I have to do?
Thanks!
-Carl
Were you able to resolve this issue?
Anyone have any ideas?
|||I am receiving this same error in the desktop development studio - system.outofmemory was thrown with 1044612 rows. It runs fine in the "Data" tab and in management studio but when I try to preview the report in the "Preview "tab I get this error. Any resolution for this?|||I am having the same problem - the query runs perfectly fine in Management studio, or the Data tab - but when the report is generated it gives out of memory error.
Is there a resolution, or a workaround (would a custom ITemporaryStorage class resolve this issue - I can't find any example code or discussion on this except MSDN api docs)
Out of memory error
I'm trying to generate a very large report. My server's got 32 gigs of memory though, so memory shouldn't be an issue. However, when I try to generate my report, I get the following outofmemory error message in the error log on the server:
EventType clr20r3, P1 w3wp.exe, P2 6.0.3790.3959, P3 45d6968e, P4 mscorlib, P5 2.0.0.0, P6 4333ab80, P7 116e, P8 29, P9 system.outofmemoryexception, P10 NIL.
The w3wp.exe process maxes out at ~1,250 MB. I imagine I just have to change a setting somewhere to allow this to grow beyond that, but I can't seem to find that setting. What do I have to do?
Thanks!
-Carl
Were you able to resolve this issue?
Anyone have any ideas?
|||I am receiving this same error in the desktop development studio - system.outofmemory was thrown with 1044612 rows. It runs fine in the "Data" tab and in management studio but when I try to preview the report in the "Preview "tab I get this error. Any resolution for this?|||I am having the same problem - the query runs perfectly fine in Management studio, or the Data tab - but when the report is generated it gives out of memory error.
Is there a resolution, or a workaround (would a custom ITemporaryStorage class resolve this issue - I can't find any example code or discussion on this except MSDN api docs)
Out of memory error
I'm trying to generate a very large report. My server's got 32 gigs of memory though, so memory shouldn't be an issue. However, when I try to generate my report, I get the following outofmemory error message in the error log on the server:
EventType clr20r3, P1 w3wp.exe, P2 6.0.3790.3959, P3 45d6968e, P4 mscorlib, P5 2.0.0.0, P6 4333ab80, P7 116e, P8 29, P9 system.outofmemoryexception, P10 NIL.
The w3wp.exe process maxes out at ~1,250 MB. I imagine I just have to change a setting somewhere to allow this to grow beyond that, but I can't seem to find that setting. What do I have to do?
Thanks!
-Carl
Were you able to resolve this issue?
Anyone have any ideas?
|||I am receiving this same error in the desktop development studio - system.outofmemory was thrown with 1044612 rows. It runs fine in the "Data" tab and in management studio but when I try to preview the report in the "Preview "tab I get this error. Any resolution for this?|||I am having the same problem - the query runs perfectly fine in Management studio, or the Data tab - but when the report is generated it gives out of memory error.
Is there a resolution, or a workaround (would a custom ITemporaryStorage class resolve this issue - I can't find any example code or discussion on this except MSDN api docs)
sqlOut of Memery Error while reading records
Hi,
I'm using CR9 with PostgreSQL.
While trying to run a report for a particular date, it returns
"Failed to open rowset"
"Out of memory while trying to read tuples"
But while running the same thing as a sql query from Postgres by limiting the records count it's working fine. So I think the problem is with the crystal reports.
Is there any way to limit the no of records? Also I tried to limit the records in CR RAS. It's not working.
Any idea, pls. help me
ThanksWhat's the maximum size of the table/ Max no of records Crystal Reports Support?
OR
Is it depends on the physical size of the machine.
I caught by the error "Out of Memory while reading tuples". The same table is working while filtering the records by another field which returns smaller no of records.
Have any idea, pls share with me.
Thankssql
I'm using CR9 with PostgreSQL.
While trying to run a report for a particular date, it returns
"Failed to open rowset"
"Out of memory while trying to read tuples"
But while running the same thing as a sql query from Postgres by limiting the records count it's working fine. So I think the problem is with the crystal reports.
Is there any way to limit the no of records? Also I tried to limit the records in CR RAS. It's not working.
Any idea, pls. help me
ThanksWhat's the maximum size of the table/ Max no of records Crystal Reports Support?
OR
Is it depends on the physical size of the machine.
I caught by the error "Out of Memory while reading tuples". The same table is working while filtering the records by another field which returns smaller no of records.
Have any idea, pls share with me.
Thankssql
Tuesday, March 20, 2012
OTP: Accessing RDL Reports from Visual Basic 6.0 Application
Hai! I don't know is this a silly question. Is it possible to execute and display the rdl (Sql server 2005 reporting services) report from visual basic 6.0 application.
I have a full fledged Visual basic windows application and using crystal reports. I want to create the reports using SQL server 2005 reporting services and access it from my Visual Basic 6.0 Windows application.
Thanks in advance
I'm afraid VB6 support has ended, and so VB6 questions are off topic here. Try www.vbcity.com instead.|||I'm trying to do the same and wondered whether you have found a solution.Thanks
'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
Wednesday, March 7, 2012
osql -L
Can anyone suggest why two client PCs on the same network report different
lists of servers using osql -L ?
Nick.
BOL says the -L option 'Lists the locally configured servers and the names
of the servers broadcasting on the network.'
So... it could be that they really are on different subnets and yuo don't
realize it. But 'locally configured' servers is the more likely answer.
-L will show all server aliases hat are defined on the client using the
Client Network Utility. You probably have different lists there...
Brian Moran
Principal Mentor
Solid Quality Learning
SQL Server MVP
http://www.solidqualitylearning.com
"Nick Stephens" <NickStephens@.discussions.microsoft.com> wrote in message
news:7C1AC5D3-F374-4BFA-B220-90D97DD253F4@.microsoft.com...
> Can anyone suggest why two client PCs on the same network report different
> lists of servers using osql -L ?
> Nick.
|||My colleague and I had also discussed the possibility of different subnets
being an issue, but didn't have the tehcnical knowledge to sound out our
ideas so we moved on and in fact checked out the configs via the Client
Network Utility.
The only difference that we found was a single alias on his machine whereas
on mine the list is empty and yet there are 49 servers to be found. Maybe
there's a different list of which I'm unaware ?
Inspired by a reply to a similar post I knocked up a quick VB6 app to use
DMO and list the servers. Unsurprisingly, I got exactly the same list as with
osql -L.
However, several entries in my list differ from that when we use my
colleague's machine.
Still, at your suggestion I'll take a closer look at the configs, Biran -
many thanks for your help.
Regards, Nick.
"Brian Moran" wrote:
>
> BOL says the -L option 'Lists the locally configured servers and the names
> of the servers broadcasting on the network.'
> So... it could be that they really are on different subnets and yuo don't
> realize it. But 'locally configured' servers is the more likely answer.
> -L will show all server aliases hat are defined on the client using the
> Client Network Utility. You probably have different lists there...
> --
> Brian Moran
> Principal Mentor
> Solid Quality Learning
> SQL Server MVP
> http://www.solidqualitylearning.com
>
> "Nick Stephens" <NickStephens@.discussions.microsoft.com> wrote in message
> news:7C1AC5D3-F374-4BFA-B220-90D97DD253F4@.microsoft.com...
>
>
|||Brian, further to my initial reply to your post, we have found that it is
indeed a subnet thang. Our machines are on different subnets.
Thanks again.
Regards, Nick.
"Brian Moran" wrote:
>
> BOL says the -L option 'Lists the locally configured servers and the names
> of the servers broadcasting on the network.'
> So... it could be that they really are on different subnets and yuo don't
> realize it. But 'locally configured' servers is the more likely answer.
> -L will show all server aliases hat are defined on the client using the
> Client Network Utility. You probably have different lists there...
> --
> Brian Moran
> Principal Mentor
> Solid Quality Learning
> SQL Server MVP
> http://www.solidqualitylearning.com
>
> "Nick Stephens" <NickStephens@.discussions.microsoft.com> wrote in message
> news:7C1AC5D3-F374-4BFA-B220-90D97DD253F4@.microsoft.com...
>
>
|||You can get different results at different times from the same PC as
well due to server responses not coming back in time. OSQL -L is based
on UDP network broadcasts. There are different factors that play into
what you get back for results. You can find the issues listed at:
http://www.sqldev.net/misc/ListSQLSvr.htm
-Sue
On Thu, 4 Nov 2004 08:13:03 -0800, "Nick Stephens"
<NickStephens@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>Brian, further to my initial reply to your post, we have found that it is
>indeed a subnet thang. Our machines are on different subnets.
>Thanks again.
>Regards, Nick.
>"Brian Moran" wrote:
|||Many thanks, Sue !
Nick.
"Sue Hoegemeier" wrote:
> You can get different results at different times from the same PC as
> well due to server responses not coming back in time. OSQL -L is based
> on UDP network broadcasts. There are different factors that play into
> what you get back for results. You can find the issues listed at:
> http://www.sqldev.net/misc/ListSQLSvr.htm
> -Sue
> On Thu, 4 Nov 2004 08:13:03 -0800, "Nick Stephens"
> <NickStephens@.discussions.microsoft.com> wrote:
>
>
lists of servers using osql -L ?
Nick.
BOL says the -L option 'Lists the locally configured servers and the names
of the servers broadcasting on the network.'
So... it could be that they really are on different subnets and yuo don't
realize it. But 'locally configured' servers is the more likely answer.
-L will show all server aliases hat are defined on the client using the
Client Network Utility. You probably have different lists there...
Brian Moran
Principal Mentor
Solid Quality Learning
SQL Server MVP
http://www.solidqualitylearning.com
"Nick Stephens" <NickStephens@.discussions.microsoft.com> wrote in message
news:7C1AC5D3-F374-4BFA-B220-90D97DD253F4@.microsoft.com...
> Can anyone suggest why two client PCs on the same network report different
> lists of servers using osql -L ?
> Nick.
|||My colleague and I had also discussed the possibility of different subnets
being an issue, but didn't have the tehcnical knowledge to sound out our
ideas so we moved on and in fact checked out the configs via the Client
Network Utility.
The only difference that we found was a single alias on his machine whereas
on mine the list is empty and yet there are 49 servers to be found. Maybe
there's a different list of which I'm unaware ?
Inspired by a reply to a similar post I knocked up a quick VB6 app to use
DMO and list the servers. Unsurprisingly, I got exactly the same list as with
osql -L.
However, several entries in my list differ from that when we use my
colleague's machine.
Still, at your suggestion I'll take a closer look at the configs, Biran -
many thanks for your help.
Regards, Nick.
"Brian Moran" wrote:
>
> BOL says the -L option 'Lists the locally configured servers and the names
> of the servers broadcasting on the network.'
> So... it could be that they really are on different subnets and yuo don't
> realize it. But 'locally configured' servers is the more likely answer.
> -L will show all server aliases hat are defined on the client using the
> Client Network Utility. You probably have different lists there...
> --
> Brian Moran
> Principal Mentor
> Solid Quality Learning
> SQL Server MVP
> http://www.solidqualitylearning.com
>
> "Nick Stephens" <NickStephens@.discussions.microsoft.com> wrote in message
> news:7C1AC5D3-F374-4BFA-B220-90D97DD253F4@.microsoft.com...
>
>
|||Brian, further to my initial reply to your post, we have found that it is
indeed a subnet thang. Our machines are on different subnets.
Thanks again.
Regards, Nick.
"Brian Moran" wrote:
>
> BOL says the -L option 'Lists the locally configured servers and the names
> of the servers broadcasting on the network.'
> So... it could be that they really are on different subnets and yuo don't
> realize it. But 'locally configured' servers is the more likely answer.
> -L will show all server aliases hat are defined on the client using the
> Client Network Utility. You probably have different lists there...
> --
> Brian Moran
> Principal Mentor
> Solid Quality Learning
> SQL Server MVP
> http://www.solidqualitylearning.com
>
> "Nick Stephens" <NickStephens@.discussions.microsoft.com> wrote in message
> news:7C1AC5D3-F374-4BFA-B220-90D97DD253F4@.microsoft.com...
>
>
|||You can get different results at different times from the same PC as
well due to server responses not coming back in time. OSQL -L is based
on UDP network broadcasts. There are different factors that play into
what you get back for results. You can find the issues listed at:
http://www.sqldev.net/misc/ListSQLSvr.htm
-Sue
On Thu, 4 Nov 2004 08:13:03 -0800, "Nick Stephens"
<NickStephens@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>Brian, further to my initial reply to your post, we have found that it is
>indeed a subnet thang. Our machines are on different subnets.
>Thanks again.
>Regards, Nick.
>"Brian Moran" wrote:
|||Many thanks, Sue !
Nick.
"Sue Hoegemeier" wrote:
> You can get different results at different times from the same PC as
> well due to server responses not coming back in time. OSQL -L is based
> on UDP network broadcasts. There are different factors that play into
> what you get back for results. You can find the issues listed at:
> http://www.sqldev.net/misc/ListSQLSvr.htm
> -Sue
> On Thu, 4 Nov 2004 08:13:03 -0800, "Nick Stephens"
> <NickStephens@.discussions.microsoft.com> wrote:
>
>
Saturday, February 25, 2012
osql and 'real' csv format
I want to use osql to generate the query report in comma separated format
(csv), but even though I specified output file as report.csv, the data in the
file is not comma separated, instead, it's just like what we see when we do
query with SQL QUERY ANALYZER with "results in text" menu seletect. for
example, suppose the query is select column1, column2 from table1, and I
expect the data in .csv file as
r11,r12
r21,r22
r31,r32
instead, I get:
header1 header2
-- --
r11 r12
r21 r22
r31 r32
my statement is:
"c:\sql2ksp3\x86\binn\osql" -E -d mydb -Q "select * from table1" -o
c:\mydb\report.csv
what am i missing here and how to get report in 'real' csv format?
Appreciate your help and time on this, THANKS!
You may try something like
[script]
bcp "SELECT au_fname, au_lname FROM pubs..Authors ORDER BY au_lname"
queryout c:\Authors.txt -t , -r \n -c -SYourServerName -T
[/script]
And take a look at this article "Showdown-bcp vs. DTS"
http://www.windowsitpro.com/Articles...rticleID=19760
Cristian Lefter, SQL Server MVP
"gongzuo" <gongzuo@.discussions.microsoft.com> wrote in message
news:A7B5CE27-E2C1-4BCE-9B24-7EBF0588C921@.microsoft.com...
>I want to use osql to generate the query report in comma separated format
> (csv), but even though I specified output file as report.csv, the data in
> the
> file is not comma separated, instead, it's just like what we see when we
> do
> query with SQL QUERY ANALYZER with "results in text" menu seletect. for
> example, suppose the query is select column1, column2 from table1, and I
> expect the data in .csv file as
> r11,r12
> r21,r22
> r31,r32
> instead, I get:
> header1 header2
> -- --
> r11 r12
> r21 r22
> r31 r32
> my statement is:
> "c:\sql2ksp3\x86\binn\osql" -E -d mydb -Q "select * from table1" -o
> c:\mydb\report.csv
> what am i missing here and how to get report in 'real' csv format?
> Appreciate your help and time on this, THANKS!
|||Try this
"c:\sql2ksp3\x86\binn\osql" -E -d mydb -Q "select * from table1" -s"," -o
c:\mydb\report.csv
"gongzuo" wrote:
> I want to use osql to generate the query report in comma separated format
> (csv), but even though I specified output file as report.csv, the data in the
> file is not comma separated, instead, it's just like what we see when we do
> query with SQL QUERY ANALYZER with "results in text" menu seletect. for
> example, suppose the query is select column1, column2 from table1, and I
> expect the data in .csv file as
> r11,r12
> r21,r22
> r31,r32
> instead, I get:
> header1 header2
> -- --
> r11 r12
> r21 r22
> r31 r32
> my statement is:
> "c:\sql2ksp3\x86\binn\osql" -E -d mydb -Q "select * from table1" -o
> c:\mydb\report.csv
> what am i missing here and how to get report in 'real' csv format?
> Appreciate your help and time on this, THANKS!
|||Try this
"c:\sql2ksp3\x86\binn\osql" -E -d mydb -Q "select * from table1" -s"," -o
c:\mydb\report.csv
"gongzuo" wrote:
> I want to use osql to generate the query report in comma separated format
> (csv), but even though I specified output file as report.csv, the data in the
> file is not comma separated, instead, it's just like what we see when we do
> query with SQL QUERY ANALYZER with "results in text" menu seletect. for
> example, suppose the query is select column1, column2 from table1, and I
> expect the data in .csv file as
> r11,r12
> r21,r22
> r31,r32
> instead, I get:
> header1 header2
> -- --
> r11 r12
> r21 r22
> r31 r32
> my statement is:
> "c:\sql2ksp3\x86\binn\osql" -E -d mydb -Q "select * from table1" -o
> c:\mydb\report.csv
> what am i missing here and how to get report in 'real' csv format?
> Appreciate your help and time on this, THANKS!
|||it works, Thanks!
one more question:
how to generate a 'real' .xls format report using the same method?
or what's the col_separator character for an .xls format?
[i changed the generated .csv to .xls and the data are not align with
the columns in .xls file; I changed the '.csv' to '.xls' in the statement
only to generated the same in wrong format.
"msdnbuddy" wrote:
[vbcol=seagreen]
> Try this
> "c:\sql2ksp3\x86\binn\osql" -E -d mydb -Q "select * from table1" -s"," -o
> c:\mydb\report.csv
> "gongzuo" wrote:
|||it works, thanks!
one more: what's the colomn-separator character for an .xls format?
i changed the report generated by the above statement from 'report.csv'
to 'report.xls' and the data are not align with the columns in the file;
I changed the '.csv' to '.xls' in the statement and only get the similar
wrong .xls format]
"msdnbuddy" wrote:
[vbcol=seagreen]
> Try this
> "c:\sql2ksp3\x86\binn\osql" -E -d mydb -Q "select * from table1" -s"," -o
> c:\mydb\report.csv
> "gongzuo" wrote:
|||The problem that was causing the columns to not align was that the column
width of the output file was (by default) 80 cols. This can be corrected
with the -w switch
"c:\sql2ksp3\x86\binn\osql" -E -d mydb -Q "select * from table1" -s"," -w
500 -o
c:\mydb\report.csv
Depending on how many columns are returned in your select statement, I would
suggest that you increase or decrease the width. I did a "select * from
orders" on the northwind db and widht of 500 resulted in a well formatted
..xls file. Give it a try.
Cheers.
"gongzuo" wrote:
[vbcol=seagreen]
> it works, thanks!
> one more: what's the colomn-separator character for an .xls format?
> i changed the report generated by the above statement from 'report.csv'
> to 'report.xls' and the data are not align with the columns in the file;
> I changed the '.csv' to '.xls' in the statement and only get the similar
> wrong .xls format]
> "msdnbuddy" wrote:
|||Thanks !
another problem :
using -s","
I couldn't get the whole date_time , for example, for the date_time is
2005-04-20 14:38:36.000, I only get 38:36:0
I did "select BirthDate from employees" on the nothwind db and get 00:00:0
for all the 9 records.
appreciate your help and time!
"msdnbuddy" wrote:
[vbcol=seagreen]
> The problem that was causing the columns to not align was that the column
> width of the output file was (by default) 80 cols. This can be corrected
> with the -w switch
> "c:\sql2ksp3\x86\binn\osql" -E -d mydb -Q "select * from table1" -s"," -w
> 500 -o
> c:\mydb\report.csv
> Depending on how many columns are returned in your select statement, I would
> suggest that you increase or decrease the width. I did a "select * from
> orders" on the northwind db and widht of 500 resulted in a well formatted
> .xls file. Give it a try.
> Cheers.
> "gongzuo" wrote:
|||I too am having this date problem. Also, can osql use tabs as delimiters? -s
"\t" doesn't work.
"gongzuo" wrote:
[vbcol=seagreen]
> Thanks !
> another problem :
> using -s","
> I couldn't get the whole date_time , for example, for the date_time is
> 2005-04-20 14:38:36.000, I only get 38:36:0
> I did "select BirthDate from employees" on the nothwind db and get 00:00:0
> for all the 9 records.
> appreciate your help and time!
> "msdnbuddy" wrote:
(csv), but even though I specified output file as report.csv, the data in the
file is not comma separated, instead, it's just like what we see when we do
query with SQL QUERY ANALYZER with "results in text" menu seletect. for
example, suppose the query is select column1, column2 from table1, and I
expect the data in .csv file as
r11,r12
r21,r22
r31,r32
instead, I get:
header1 header2
-- --
r11 r12
r21 r22
r31 r32
my statement is:
"c:\sql2ksp3\x86\binn\osql" -E -d mydb -Q "select * from table1" -o
c:\mydb\report.csv
what am i missing here and how to get report in 'real' csv format?
Appreciate your help and time on this, THANKS!
You may try something like
[script]
bcp "SELECT au_fname, au_lname FROM pubs..Authors ORDER BY au_lname"
queryout c:\Authors.txt -t , -r \n -c -SYourServerName -T
[/script]
And take a look at this article "Showdown-bcp vs. DTS"
http://www.windowsitpro.com/Articles...rticleID=19760
Cristian Lefter, SQL Server MVP
"gongzuo" <gongzuo@.discussions.microsoft.com> wrote in message
news:A7B5CE27-E2C1-4BCE-9B24-7EBF0588C921@.microsoft.com...
>I want to use osql to generate the query report in comma separated format
> (csv), but even though I specified output file as report.csv, the data in
> the
> file is not comma separated, instead, it's just like what we see when we
> do
> query with SQL QUERY ANALYZER with "results in text" menu seletect. for
> example, suppose the query is select column1, column2 from table1, and I
> expect the data in .csv file as
> r11,r12
> r21,r22
> r31,r32
> instead, I get:
> header1 header2
> -- --
> r11 r12
> r21 r22
> r31 r32
> my statement is:
> "c:\sql2ksp3\x86\binn\osql" -E -d mydb -Q "select * from table1" -o
> c:\mydb\report.csv
> what am i missing here and how to get report in 'real' csv format?
> Appreciate your help and time on this, THANKS!
|||Try this
"c:\sql2ksp3\x86\binn\osql" -E -d mydb -Q "select * from table1" -s"," -o
c:\mydb\report.csv
"gongzuo" wrote:
> I want to use osql to generate the query report in comma separated format
> (csv), but even though I specified output file as report.csv, the data in the
> file is not comma separated, instead, it's just like what we see when we do
> query with SQL QUERY ANALYZER with "results in text" menu seletect. for
> example, suppose the query is select column1, column2 from table1, and I
> expect the data in .csv file as
> r11,r12
> r21,r22
> r31,r32
> instead, I get:
> header1 header2
> -- --
> r11 r12
> r21 r22
> r31 r32
> my statement is:
> "c:\sql2ksp3\x86\binn\osql" -E -d mydb -Q "select * from table1" -o
> c:\mydb\report.csv
> what am i missing here and how to get report in 'real' csv format?
> Appreciate your help and time on this, THANKS!
|||Try this
"c:\sql2ksp3\x86\binn\osql" -E -d mydb -Q "select * from table1" -s"," -o
c:\mydb\report.csv
"gongzuo" wrote:
> I want to use osql to generate the query report in comma separated format
> (csv), but even though I specified output file as report.csv, the data in the
> file is not comma separated, instead, it's just like what we see when we do
> query with SQL QUERY ANALYZER with "results in text" menu seletect. for
> example, suppose the query is select column1, column2 from table1, and I
> expect the data in .csv file as
> r11,r12
> r21,r22
> r31,r32
> instead, I get:
> header1 header2
> -- --
> r11 r12
> r21 r22
> r31 r32
> my statement is:
> "c:\sql2ksp3\x86\binn\osql" -E -d mydb -Q "select * from table1" -o
> c:\mydb\report.csv
> what am i missing here and how to get report in 'real' csv format?
> Appreciate your help and time on this, THANKS!
|||it works, Thanks!
one more question:
how to generate a 'real' .xls format report using the same method?
or what's the col_separator character for an .xls format?
[i changed the generated .csv to .xls and the data are not align with
the columns in .xls file; I changed the '.csv' to '.xls' in the statement
only to generated the same in wrong format.
"msdnbuddy" wrote:
[vbcol=seagreen]
> Try this
> "c:\sql2ksp3\x86\binn\osql" -E -d mydb -Q "select * from table1" -s"," -o
> c:\mydb\report.csv
> "gongzuo" wrote:
|||it works, thanks!
one more: what's the colomn-separator character for an .xls format?
i changed the report generated by the above statement from 'report.csv'
to 'report.xls' and the data are not align with the columns in the file;
I changed the '.csv' to '.xls' in the statement and only get the similar
wrong .xls format]
"msdnbuddy" wrote:
[vbcol=seagreen]
> Try this
> "c:\sql2ksp3\x86\binn\osql" -E -d mydb -Q "select * from table1" -s"," -o
> c:\mydb\report.csv
> "gongzuo" wrote:
|||The problem that was causing the columns to not align was that the column
width of the output file was (by default) 80 cols. This can be corrected
with the -w switch
"c:\sql2ksp3\x86\binn\osql" -E -d mydb -Q "select * from table1" -s"," -w
500 -o
c:\mydb\report.csv
Depending on how many columns are returned in your select statement, I would
suggest that you increase or decrease the width. I did a "select * from
orders" on the northwind db and widht of 500 resulted in a well formatted
..xls file. Give it a try.
Cheers.
"gongzuo" wrote:
[vbcol=seagreen]
> it works, thanks!
> one more: what's the colomn-separator character for an .xls format?
> i changed the report generated by the above statement from 'report.csv'
> to 'report.xls' and the data are not align with the columns in the file;
> I changed the '.csv' to '.xls' in the statement and only get the similar
> wrong .xls format]
> "msdnbuddy" wrote:
|||Thanks !
another problem :
using -s","
I couldn't get the whole date_time , for example, for the date_time is
2005-04-20 14:38:36.000, I only get 38:36:0
I did "select BirthDate from employees" on the nothwind db and get 00:00:0
for all the 9 records.
appreciate your help and time!
"msdnbuddy" wrote:
[vbcol=seagreen]
> The problem that was causing the columns to not align was that the column
> width of the output file was (by default) 80 cols. This can be corrected
> with the -w switch
> "c:\sql2ksp3\x86\binn\osql" -E -d mydb -Q "select * from table1" -s"," -w
> 500 -o
> c:\mydb\report.csv
> Depending on how many columns are returned in your select statement, I would
> suggest that you increase or decrease the width. I did a "select * from
> orders" on the northwind db and widht of 500 resulted in a well formatted
> .xls file. Give it a try.
> Cheers.
> "gongzuo" wrote:
|||I too am having this date problem. Also, can osql use tabs as delimiters? -s
"\t" doesn't work.
"gongzuo" wrote:
[vbcol=seagreen]
> Thanks !
> another problem :
> using -s","
> I couldn't get the whole date_time , for example, for the date_time is
> 2005-04-20 14:38:36.000, I only get 38:36:0
> I did "select BirthDate from employees" on the nothwind db and get 00:00:0
> for all the 9 records.
> appreciate your help and time!
> "msdnbuddy" wrote:
Monday, February 20, 2012
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.
>>
>
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
>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
>> 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.
>>
>
Subscribe to:
Posts (Atom)