Link to home
Start Free TrialLog in
Avatar of orther
orther

asked on

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?
ASKER CERTIFIED SOLUTION
Avatar of Nico Bontenbal
Nico Bontenbal
Flag of Netherlands image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of orther
orther

ASKER

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.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of orther

ASKER

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."
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of orther

ASKER

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.
Avatar of orther

ASKER

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.
Avatar of orther

ASKER

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.
After reading the last post by orther I don't think he want's to close the question.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of orther

ASKER

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.
Avatar of orther

ASKER

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.