?
Solved

Add Terms and Conditions to my Invoice

Posted on 2012-08-20
12
Medium Priority
?
1,707 Views
Last Modified: 2012-08-31
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
Comment
Question by:orther
  • 7
  • 5
12 Comments
 
LVL 22

Accepted Solution

by:
Nico Bontenbal earned 2000 total points
ID: 38315208
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
 

Author Comment

by:orther
ID: 38315404
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
 
LVL 22

Assisted Solution

by:Nico Bontenbal
Nico Bontenbal earned 2000 total points
ID: 38328244
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
[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

 

Author Comment

by:orther
ID: 38339378
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
 
LVL 22

Assisted Solution

by:Nico Bontenbal
Nico Bontenbal earned 2000 total points
ID: 38345649
<<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
 

Author Comment

by:orther
ID: 38348843
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
 

Author Comment

by:orther
ID: 38353432
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
 

Author Comment

by:orther
ID: 38353274
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
 
LVL 22

Expert Comment

by:Nico Bontenbal
ID: 38353433
After reading the last post by orther I don't think he want's to close the question.
0
 
LVL 22

Assisted Solution

by:Nico Bontenbal
Nico Bontenbal earned 2000 total points
ID: 38353474
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
 

Author Comment

by:orther
ID: 38353525
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
 

Author Closing Comment

by:orther
ID: 38353535
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

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

After much searching across the internet I have found that you could not set the name of the file you were attaching to dynamic report subscriptons in Microsoft Reporting Services. I did manage to find one article showing you how your could make a s…
Time Corrections for Reports Working with a report, we made some interesting discoveries about the time corrections/updates We are using the following Parameters: Starting Entered Date (Date) formatted as Data type: "Date/Time" Ending Entered …
Integration Management Part 2
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…
Suggested Courses

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question