print Purchase order Terms and Conditions as a supplement to the report

(0) Share

Report

Posted on by Hdesp

We have purchase orders that are 1-3 pages long. We also have terms and conditions that run 7 pages.

The ask is to add terms and conditions at the absolute end of the report.

I tried adding it in page footer but 7 pages long page footer does not work, it does something odd.

I removed page footer and added T & C as a text at the bottom of the report. However, business is complaining that they don't wat to see PO header details on T & C pages. In effect what they want is combine regular po printout and append the T & C PDF. This looks doable for print to email, not tried it yet. Any idea how to achieve this on print to screen?

I can see that SSRS framework is writing to a file on disk and then printing that file to screen. I am a bit afraid of manipulating something on the file system on PROD. I dont even know whether it is possible.

Any suggestions?

All responses (5)

Answers (0)

Gunjan Bhattachayya 35,421 on at

Like (0)

Report

RE: print Purchase order Terms and Conditions as a supplement to the report

We were setting this property on the Text box to true.

Please give this approach a try and see if it works for you.
Hdesp 38 on at

Like (0)

Report

RE: print Purchase order Terms and Conditions as a supplement to the report

It did some weird formatting and only printed at the bottom of the report instead of filling entire page. Also I think the total number of pages concept did not work because the footer itself is long.

Out of curiosity, why rectangle? I did no use a rectangle.
Gunjan Bhattachayya 35,421 on at

Like (0)

Report

RE: print Purchase order Terms and Conditions as a supplement to the report

How did it print the footer for you when you tried it?
Hdesp 38 on at

Like (0)

Report

RE: print Purchase order Terms and Conditions as a supplement to the report

I tried that but SSRS does not like footer that is 7 pages long :(
Gunjan Bhattachayya 35,421 on at

Like (0)

Report
RE: print Purchase order Terms and Conditions as a supplement to the report

Hi,

We had such a requirement for one of our clients some time back. We added a rectangle in the footer of the report and had it print only on the last page. We changed the Hidden property of the rectangle to this expression which printed the T&Cs on multiple pages after the report was printed.

=IIF(Globals!PageNumber=Globals!TotalPages,false,true)