web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Unanswered

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

(0) ShareShare
ReportReport
Posted on by 38

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?

I have the same question (0)
  • Gunjan Bhattachayya Profile Picture
    35,423 on at
    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)
     

  • Hdesp Profile Picture
    38 on at
    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 Profile Picture
    35,423 on at
    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 Profile Picture
    38 on at
    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 Profile Picture
    35,423 on at
    RE: print Purchase order Terms and Conditions as a supplement to the report

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

    pastedimage1647287209390v1.png

    Please give this approach a try and see if it works for you.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 703 Super User 2025 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 582 Most Valuable Professional

#3
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 542

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans