Footer Formatting - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Development Tools

Reporting Services Development

Footer Formatting

Author

Topic

CoachBarker
Posting Yak Master

170 Posts

Posted - 2009-01-09 : 10:16:31

I've built my report with a Header, Body and Footer. When the report runs it returns the values I am looking for and the Footer is right up beneath the body of the report. But when I print the report, the Footer is way down at the bottom of the page. Is there a setting I need to set to keep the footer up to the body of the report?

Thanks for the help
CoachBarker

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-01-09 : 11:45:55

you need to make sure you footer is just below your tables,matrices,... in designer window. any space left in body after container will cause unwanted space to appear while priniting

CoachBarker
Posting Yak Master

170 Posts

Posted - 2009-01-09 : 11:54:26

There is no space under the body and before the footer. What is the trick to adding an image to the post. I see the Insert Image button, but what are you supposed to do in between the image code braces?

Thanks for the help
CoachBarker

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-01-09 : 12:00:10

just post image in some shared webservers and put link between image tags

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-01-09 : 12:01:46

between another reason why this happens is when you've two or more containers overlapping in designer or width of container exceeding normal page width.

CoachBarker
Posting Yak Master

170 Posts

Posted - 2009-01-09 : 12:51:30

This is what my report looks like in the designer

and this is how it looks in preview.

Thanks for the help
CoachBarker

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-01-09 : 13:08:57

how many rows of data does your table contain? the footer will always be aligned towards bottom of page in print preview, so if there's not enough data to show, you might feel like lots of space between footer and data

CoachBarker
Posting Yak Master

170 Posts

Posted - 2009-01-09 : 13:19:20

So then you are saying that even though I have most of those fields set as hidden, they are still expading and taking up space in the report body? If that is so how do I use those values if they are not on the report?

Yeah I guess it does, will have to think on this

Thanks for the help
CoachBarker

CoachBarker
Posting Yak Master

170 Posts

Posted - 2009-01-12 : 08:04:10

Well I haven't figured out how to access the values I need from the report query without having the required fields in the body of th report and then pass them to the header or footer.

Suggestions

Thanks for the help
CoachBarker

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-01-17 : 03:03:17

quote:
Originally posted by CoachBarker

Well I haven't figured out how to access the values I need from the report query without having the required fields in the body of th report and then pass them to the header or footer.

Suggestions

Thanks for the help
CoachBarker

why? cant you directly access fields available in dataset using Fields collection? just using Fields!YourField.value? whats the need for including them in report body if you dont want to display them at all?

CoachBarker
Posting Yak Master

170 Posts

Posted - 2009-01-20 : 11:04:22

Sorry I have been busy making changes in the app these reports go to or I would have responded sooner.

Now, I have the body of the report, and I have a header and a footer. The header and the footer need to get their data from somewhere? But you can not directly access the data for either, you need to refer to the fields in the body of the report.

Example:

=Fields!bill_to_number.Value is valid in the report body and will hold the data for that field.

But in the Header or Footer you need to do =(ReportItems!bill_to_number.Value)to access the same value.

So if you want to have fields in the Header/Footer that are not in the body, how do you access them

Thanks for the help
CoachBarker

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-01-20 : 12:00:05

ok...that is true. but just being curious, why should you be accessing data items in header and footer? mostly its only parameter values that we display in header/footer. and even if we want to use data in header/footer,we will be doing it in table header/footer inside report body

CoachBarker
Posting Yak Master

170 Posts

Posted - 2009-01-20 : 12:42:01

Am I doing it wrong then by adding Page Footer and a Page Header? When I added the header and footer I right clicked on the table in the body and selected Table Header and Table Footer. Is that not the right way. Sorry to sound so naive, but I am self teaching this to myself at work.

Thanks for the help
CoachBarker

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-01-20 : 12:46:30

quote:
Originally posted by CoachBarker

Am I doing it wrong then by adding Page Footer and a Page Header? When I added the header and footer I right clicked on the table in the body and selected Table Header and Table Footer. Is that not the right way. Sorry to sound so naive, but I am self teaching this to myself at work.

Thanks for the help
CoachBarker

yup. thats the right way. but using dataset fields is not a problem in table header/footer.

CoachBarker
Posting Yak Master

170 Posts

Posted - 2009-01-20 : 13:12:09

Then what am I doing wrong. I add a text box to the footer textbox22 and go to properties and set the value and when I preview I get this error message

[rsFieldInPageSectionExpression] The Value expression for the textbox ‘textbox22’ refers to a field. Fields cannot be used in page headers or footers.
Build complete -- 1 errors, 0 warnings

is there another way to reference them in the Footer/Header?

Thanks for the help
CoachBarker

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-01-20 : 13:15:33

quote:
Originally posted by CoachBarker

Then what am I doing wrong. I add a text box to the footer textbox22 and go to properties and set the value and when I preview I get this error message

[rsFieldInPageSectionExpression] The Value expression for the textbox ‘textbox22’ refers to a field. Fields cannot be used in page headers or footers.
Build complete -- 1 errors, 0 warnings

is there another way to reference them in the Footer/Header?

Thanks for the help
CoachBarker

you're adding it to page footer not table footer thats the problem. for adding table footer right click on table and select table footer. not on report body which gives you report footer

CoachBarker
Posting Yak Master

170 Posts

Posted - 2009-01-20 : 13:45:21

Ahhhh OK I see now.