• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1845
  • Last Modified:

Add Terms and Conditions to my Invoice

I am running SQL Reporting Services 2008.  We have created all of our GP Dynamics reports using this reporting method.  We first create a stored procedure in SQL and use this as our data source.

My management team has requested that I add Terms and Conditions that print on a separate page each time an Invoice is printed.  This is just standard text that never changes.  I thought this would be quite easy but after searching the web, I have not found a good solution.

Can someone help?
0
orther
Asked:
orther
  • 7
  • 5
4 Solutions
 
Nico BontenbalCommented:
You can put a rectangle at the bottom of your report and set the PageBreak options of the rectangle. See http://msdn.microsoft.com/en-us/library/ms156434(SQL.100).aspx
0
 
ortherAuthor Commented:
I have placed this rectangle at the bottom of my page and have set it to Add a Page Break before.  There are a couple of problems.  1, it does not seem to add the page break.  2, it seems to move the footer up on the page instead of keeping the footer at the bottom.
0
 
Nico BontenbalCommented:
If you used the property pane to set the pagebreak you need to set the 'Disabled' property of the 'PageBreak' as well. The footer is directly below the report data in preview mode. But when you create a pdf it is at the bottom again. The attached report has the layout you need.
PageBreak.rdl
0
Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

 
ortherAuthor Commented:
Thanks Nicobo.  I read this many times and do not understand.  Your code shows the page break in the body and not the footer.  I need this to print after the footer has printed.  When I move the rectangle to the body, and set page break, it does print on a new page but also prints the header and footer.

If I put the rectangle at the bottom of the footer and add a page break before it is to print, it does not add the break.  It just moves the footer information up.

I really have a difficult time understanding you statement "you need to set the 'Disabled' property of the 'PageBreak' as well."
0
 
Nico BontenbalCommented:
<<you need to set the 'Disabled' property of the 'PageBreak' as well.>>
Never mind. If the page break is working for a rectangle in the body. This remark is not for you.

Put the rectangle in the body. Then set the 'PrintOnLastPage' property of the footer to false.

If this doesn't solve your problem can you provide a sample pdf or doc file with a sample of the layout you need.
What is the output format you are using for the report, html or pdf?
0
 
ortherAuthor Commented:
Ok this works if I set the footer to print on first page,  If footer property is set to false for both print on first page and print on last page, then the footer does not print.

The problem is, when my invoice is more that one page the footer is printing on the first page instead of the last page.
0
 
ortherAuthor Commented:
I've requested that this question be closed as follows:

Accepted answer: 0 points for orther's comment #a38348843

for the following reason:

I am accepting this solution because it does work and it might help others.
0
 
ortherAuthor Commented:
You will assign the points to Nicobo, correct?  I mean this person did answer the question and those comments did work.  I do believe this answer will help others, I just need to work a bit harder to get it for work for me completely.
0
 
Nico BontenbalCommented:
After reading the last post by orther I don't think he want's to close the question.
0
 
Nico BontenbalCommented:
If I understand correctly you want 1 or more pages with invoice data, and after that 1 page with terms. At the last page with invoice data (page 1 or 2) you want the page footer. See the attached report with a template for this lay-out. It doesn't work in HTML, but it does work in PDF. To show the text box in the page footer only for the last invoice page I use this expression fot the hidden property:
=Globals.PageNumber <> (Globals.TotalPages-1)

Open in new window

PageBreak.rdl
0
 
ortherAuthor Commented:
oh this is exactly what I was going to do, but did not have the proper syntax.  I think this is going to work.  Let me check and will report back.  Thanks Nicobo.
0
 
ortherAuthor Commented:
This is excellent.  It worked perfectly.  If someone is reading this please read the entire post as Nicobo had detailed this out perfectly.  Thanks Nicobo for the extra effort.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 7
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now