Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV (Archived)

How to print table header hidden values in pagefooter?

Posted on by Microsoft Employee

Hi All,

i have an issue in purchase order report i calculate qty from code and i take this hidden value in table header

and i call this value in page footer but it shows empty.

how can i achieve this one....

*This post is locked for comments

  • keoma Profile Picture
    keoma 32,675 on at
    RE: How to print table header hidden values in pagefooter?

    define a global variable, set it as a new field value under the first dataitem. then use it in the page footer of the report layout with Fields!nameofthefield. compare your report with standard reports like sales quote, sales order.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How to print table header hidden values in pagefooter?

    Then take an integer data item after 2 warehouse data items for printing totals and sorting by number where number = 1 and add your control(TotalQty) and number in your integer data item and also add the number control in your group. now you can add theTotalqty in the group footer and try with my previous post.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How to print table header hidden values in pagefooter?

    here in purchase order two items are there one item from one warehouse and second item from warehouse2 based on location code but i want to print this two items total in my report i did as like you said but it prints blank in footer page

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How to print table header hidden values in pagefooter?

    First try to print the value in body and use the same texbox as report item in footer and set the hidden property to yes to body textbox.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How to print table header hidden values in pagefooter?

    yes but i have two warehouses so two purchase orders are there so i grouped as adjucent after for  purchase header 2 No. if i place in footer for every table there is only one footer so when it is print it displays extra pages

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How to print table header hidden values in pagefooter?

    Parent i mean First dataitem

  • mmv Profile Picture
    mmv 11,465 on at
    RE: How to print table header hidden values in pagefooter?

    Hi Ramesh,

    Why don't u try the DataItem directly on the Page Footer with Last(Fields!xxxxxx.Value)?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How to print table header hidden values in pagefooter?

    i tried but it's not worked.................

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How to print table header hidden values in pagefooter?

    In which data item Qty control been defined?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How to print table header hidden values in pagefooter?

    in page header it is printed but what happened to page footer

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans