Body values in Header and header values in body

Hi,

I want to display a value from db in the header section. I have read a couple of information that I should place the value in a in-visible text field an reference it in the header with the ReportItems. This works great with the first page but on the second page the header information are empty (I think because the Textfield is on Page 1 not Page 2)... So is there a way to accomplish that for all pages? Not only the first page....

My second one, hope you don't mind that I post it in the same thread, is:

My Report needs to display the total size of pages in the body. I did not realy found anything useful where I can retrieve from the total size of pages of my reports....

thanks for any help

f.

I have run into issues with wanting to display data in the report headers. I have pretty much moved on from wanting to do it since it is such a pain.

Also to show the total pages I put this code in the page footer, ="Page " & Globals!PageNumber & " of " & Globals!TotalPage. This will show the current page out of how many pages at the bottom of each page.

|||I have tried Globals!TotalPage but it cannot be placed in the body... I got an error message|||The Globals!TotalPages can only be used in a page header or footer, not in the body. You will have to add a page header or footer and then put it in a textbox there.

BODY not getting assigned BackgroundColor and BODY does not have CanShrink property: REPOS

I have simplified the problem I am having down by creating an empty report
with and Page Header, Body and PageFooter. I have set the BackgroundColor
of all three to "White".
I am using VS.NET to design the Report and ASP.NET with C# to call the
Reporting Services web service Render method using HTML4.0 format to render
the report inline on my web page with a blue background.
The css (a1_s) for the Body does not a Background color as seen below in the
Supporting Examples:
The bigger problem is that I have a Table in the Body. Both do not have a
CanGrow or CanShrink property, at least exposed in VS.NET. The Table is the
only thing in the Body. The Table has a Header, Group, Detail and Footer.
If the report returns no detail, I see the Table Header and the Table
Footer. It knew to collapse/shrink the Group and Detail sections but did
not shrink the Table and/or the Body. Under the Table Footer and before the
Page Footer is a gap which is the transparent area.
The Lame workarounds I have found so far are:
- reduce the Height of the Body and the Table to the smallest allowed by the
VS.NET, but during design you have to increase it and not forget to decrease
it when you are done
- put the Table in a rectangle with a "White" BackgroundColor but there is
still a big gap between the Table Footer and Page Footer
Supporting Examples:
The RDL is:
<?xml version="1.0" encoding="utf-8"?>
<Report
xmlns="http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefini
tion"
xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
<PageHeader>
<PrintOnLastPage>true</PrintOnLastPage>
<PrintOnFirstPage>true</PrintOnFirstPage>
<Style>
<BackgroundColor>White</BackgroundColor>
</Style>
<Height>0.25in</Height>
</PageHeader>
<RightMargin>1in</RightMargin>
<Body>
<Style>
<BackgroundColor>White</BackgroundColor>
</Style>
<Height>2in</Height>
</Body>
<TopMargin>1in</TopMargin>
<Width>6.5in</Width>
<LeftMargin>1in</LeftMargin>
<rd:SnapToGrid>true</rd:SnapToGrid>
<rd:DrawGrid>true</rd:DrawGrid>
<rd:ReportID>89d2899d-7bc6-4d9d-b3f5-1bee26df10a3</rd:ReportID>
<PageFooter>
<PrintOnLastPage>true</PrintOnLastPage>
<PrintOnFirstPage>true</PrintOnFirstPage>
<Style>
<BackgroundColor>White</BackgroundColor>
</Style>
<Height>0.25in</Height>
</PageFooter>
<BottomMargin>1in</BottomMargin>
<Language>en-US</Language>
</Report>
The CSS snippet is:
.a1_s{HEIGHT:50.80mm;overflow:hidden;WIDTH:165.10mm}
.a3{border:1pt None
Black;background-color:White;background-repeat:Repeat;padding-left:0pt;paddi
ng-top:0pt;padding-right:0pt;padding-bottom:0pt;HEIGHT:6.35mm;overflow:hidde
n;WIDTH:100%}
.a5{border:1pt None
Black;background-color:White;background-repeat:Repeat;padding-left:0pt;paddi
ng-top:0pt;padding-right:0pt;padding-bottom:0pt;HEIGHT:6.35mm;overflow:hidde
n;WIDTH:100%}
The generated HTML for the report is
<div id="oReportDiv" onresize="javascript:OnResizeDiv()" style="OVERFLOW:
auto; WIDTH: 100%; HEIGHT: 100%">
<table cellpadding="0" cellspacing="0">
<tr>
<td id="oReportCell" style="PADDING: 10px">
<DIV class="a3"> </DIV>
<DIV class="a1_s"> </DIV>
<DIV class="a5"> </DIV>
<script language="javascript" type="text/javascript">
<!--
var docMapIds = [];
//-->
</script>
</td><td style="WIDTH: 100%; HEIGHT: 0px"></td>
</tr><tr>
<td style="WIDTH: 0px; HEIGHT: 100%"></td>
</tr>
</table>
</div>Hi Douglas,
I am looking into this issue, I will keep you updated as soon as I find
there is anything useful to add :)
Thank you for your patience and corporation.
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 Douglas,
From your descriptions, I understood that you are not able to generate
html as you expected when using Render method called from web service. If I
have misunderstood your concern, please feel free to point it out.
BODY do not has CanShrink property, but I am not sure why you are not able
to assign BackgoundColor property? Is it possible for you to assign the
BackgoundColor in the Report Designer?
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 Michael,
I am able to assign BackgroundColor in the Report Designer as confirmed by
the RDL I supplied in my first post.
The class generated for the Body ("a1_s") does not have a background-color
where as the Header ("a3") and Footer("a5") do have it. This can also be
seen by the Style Sheet and HTML provided in my first post.
Why doesn't a background-color get generated for the Body?
Doug
"Michael Cheng [MSFT]" <v-mingqc@.online.microsoft.com> wrote in message
news:CzW6x8ENFHA.2900@.TK2MSFTNGXA03.phx.gbl...
> Hi Douglas,
> From your descriptions, I understood that you are not able to generate
> html as you expected when using Render method called from web service. If
I
> have misunderstood your concern, please feel free to point it out.
> BODY do not has CanShrink property, but I am not sure why you are not able
> to assign BackgoundColor property? Is it possible for you to assign the
> BackgoundColor in the Report Designer?
>
> 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 Doug,
You may also manually write the code to change the background of HTML code
after calling Web service render method as workaround for your scenario.
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 Michael,
So, is this a known issue?
If so, might it be corrected in SP2?
With the workaround you suggested, since I have one container for all
reports, a User Control, I would have to query the report to see what color
to change it to.
The only way I have found to query the report is to call the
GetReportDefinition Method of the ReportingService Class and then parse the
.rdl.
Is there an easier way?
Thanks,
Doug
"Michael Cheng [MSFT]" <v-mingqc@.online.microsoft.com> wrote in message
news:nacubipNFHA.2720@.TK2MSFTNGXA03.phx.gbl...
> Hi Doug,
> You may also manually write the code to change the background of HTML code
> after calling Web service render method as workaround for your scenario.
>
> 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 Douglas,
Thanks for your kindly patience:)
Yes, I am sorry to say that this is currently by design feature of
Reporting Services now.
If the body of the report does not have a border, the background color is
taken to be the background color for the entire page, not just the body. As
a result, it is placed on the <BODY> element rather than in the CSS for the
<DIV> corresponding to the body of the report.
I don't think SP2 will fix this.
Thanks again for your patience and corporation. 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 Michael,
I tested your findings and setting the BODY border color to white and solid
is the best workaround so far and much more manageable.
Thanks,
Doug
"Michael Cheng [MSFT]" <v-mingqc@.online.microsoft.com> wrote in message
news:9sYecjlOFHA.3136@.TK2MSFTNGXA01.phx.gbl...
> Hi Douglas,
> Thanks for your kindly patience:)
> Yes, I am sorry to say that this is currently by design feature of
> Reporting Services now.
> If the body of the report does not have a border, the background color is
> taken to be the background color for the entire page, not just the body.
As
> a result, it is placed on the <BODY> element rather than in the CSS for
the
> <DIV> corresponding to the body of the report.
> I don't think SP2 will fix this.
> Thanks again for your patience and corporation. 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 Doug,
Thanks for your understanding:) If you have any questions or concerns next
time, 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.

Body is overlapping header

Hello~
I have a report with a header and body.
The header has the usual stuff, title, logo, parameter fields, etc
The body is a table.
When I run the report, the table overlaps the header... I don't
understand why this is happening...
So... what I'm doing right now is I have to leave an inch of blank
space just before the table in the body. But cosmetically the report
doesnt look right...
Thanks!On Jul 12, 4:55 pm, OogleGoogle <Yvonh...@.gmail.com> wrote:
> Hello~
> I have a report with a header and body.
> The header has the usual stuff, title, logo, parameter fields, etc
> The body is a table.
> When I run the report, the table overlaps the header... I don't
> understand why this is happening...
> So... what I'm doing right now is I have to leave an inch of blank
> space just before the table in the body. But cosmetically the report
> doesnt look right...
> Thanks!
This seems like a unique situation. I would suggest putting the
contents of the header into one rectangle and doing the same for the
table control in the body. Also, you might want to right-click inside
the blank area of the header -> select Properties -> and increase the
BorderWidth. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||On Jul 12, 9:40 pm, EMartinez <emartinez...@.gmail.com> wrote:
> On Jul 12, 4:55 pm, OogleGoogle <Yvonh...@.gmail.com> wrote:
> > Hello~
> > I have a report with a header and body.
> > The header has the usual stuff, title, logo, parameter fields, etc
> > The body is a table.
> > When I run the report, the table overlaps the header... I don't
> > understand why this is happening...
> > So... what I'm doing right now is I have to leave an inch of blank
> > space just before the table in the body. But cosmetically the report
> > doesnt look right...
> > Thanks!
> This seems like a unique situation. I would suggest putting the
> contents of the header into one rectangle and doing the same for the
> table control in the body. Also, you might want to right-click inside
> the blank area of the header -> select Properties -> and increase the
> BorderWidth. Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
Under the properties tab for the report itself, try changing the
margins it may or may not help.

Blank page in report manager

When i load report manager everything appears to be running fine. The header, footer and nav bar at the top load correctly. Even the directory and file tree load fine.

The problem is when you click on a report everything from below the nav bar ( where the report would be rendered) blanks out and load bar at the bottom just tacks at full.

One way to fix this problem is to open the web config file for report manager save it then close the file.

This is not a viable solution to the problem. I was wondering if any one else had the same problem . If so how to fix it ?

Has anyone had a similar problem with reporting services. Also is there a place to formally site this as a bug

|||

We are having a very similar problem that is driving me nuts. My end users will get this situation - Report Manager banner and links at top, and blank below the color line. They all have the appropriate permissions. At first, we thought it was caused by an Internet Explorer patch, an uninstalling that patch seemed to work... for a little while. Now, they are complaining again. I get the same patches, and I still have full access (of course, I do have sys admin and sql admin rights). I have a suspicion that it is not an IE patch, but an IE security setting or security policy that may be causing it. When I looked at the Report Manager homepage in FrontPage (just to see what I could see), I noticed that banner is rendered in HTML, and it sets the language for the rest of the page to Javascript. If the Internet Explorer security doesn't allow Javascript, or even prompts for permissions, that may be preventing the display of the rest of the page, and would explain why the banner displays and doesn't just throw an error message to the end user. I am investigating this more. Let me know if you have any thoughts.

Tee Dubs

Blank page in report manager

When i load report manager everything appears to be running fine. The header, footer and nav bar at the top load correctly. Even the directory and file tree load fine.

The problem is when you click on a report everything from below the nav bar ( where the report would be rendered) blanks out and load bar at the bottom just tacks at full.

One way to fix this problem is to open the web config file for report manager save it then close the file.

This is not a viable solution to the problem. I was wondering if any one else had the same problem . If so how to fix it ?

Has anyone had a similar problem with reporting services. Also is there a place to formally site this as a bug

|||

We are having a very similar problem that is driving me nuts. My end users will get this situation - Report Manager banner and links at top, and blank below the color line. They all have the appropriate permissions. At first, we thought it was caused by an Internet Explorer patch, an uninstalling that patch seemed to work... for a little while. Now, they are complaining again. I get the same patches, and I still have full access (of course, I do have sys admin and sql admin rights). I have a suspicion that it is not an IE patch, but an IE security setting or security policy that may be causing it. When I looked at the Report Manager homepage in FrontPage (just to see what I could see), I noticed that banner is rendered in HTML, and it sets the language for the rest of the page to Javascript. If the Internet Explorer security doesn't allow Javascript, or even prompts for permissions, that may be preventing the display of the rest of the page, and would explain why the banner displays and doesn't just throw an error message to the end user. I am investigating this more. Let me know if you have any thoughts.

Tee Dubs

blank page in pdf report

When I export my report to PDF, I get a blank page that shows up. The
header and footer are on the second page, but the body is blank. There
isn't enough data for a second page. Why is one being created? Any ideas?Most likely, something in your footer is touching one or more of your
margins. Make sure everything is inside the margins and you should be
good.

Blank Page

The report has just one page of information...but a blank second page is
printed with the page header and footer...
Any advise ?make sure you dont have "new page after" checked in the properties and also
check to make sure the dotted back ground is the same size as your table. I
am drawing a blank so all I can think of is dotted background. I know there
is another word for it. LOL!!! Its the area in the layout view behind your
table or graphs. Just resize it by dragging the edge to make it the same
size as your table.
"Ranga" <Ranga@.discussions.microsoft.com> wrote in message
news:60E22DEE-A30F-4142-94AB-376E8B730AC7@.microsoft.com...
> The report has just one page of information...but a blank second page is
> printed with the page header and footer...
> Any advise ?