Skip to main content

Notifications

Dynamics 365 Community / Forums / Finance forum / print Purchase order T...
Finance forum
Unanswered

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

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?

  • Gunjan Bhattachayya Profile Picture
    Gunjan Bhattachayya 35,421 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.

  • Hdesp Profile Picture
    Hdesp 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
    Gunjan Bhattachayya 35,421 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
    Hdesp 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
    Gunjan Bhattachayya 35,421 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)
     

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,867 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,173 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans