Options

RTC Reports Footer

myanilkumarmyanilkumar Member Posts: 108
edited 2010-11-25 in NAV Three Tier
Hi All,

I want to Show Some Value Fields in Footer of the Report but I am getting Error Cannot add Fields in Footer Section.

Please advise any other Method for this.

Regards,
Anil

Comments

  • Options
    BeliasBelias Member Posts: 2,998
    you could search part of the error text in the search mibuso, but to make it easy, just search "reportitems", there are a lot of topics...
    -Mirko-
    "Never memorize what you can easily find in a book".....Or Mibuso
    My Blog
  • Options
    vasilis6669vasilis6669 Member Posts: 109
    Hi,

    On the header use the SetData function. See posted sales invoice report. SetData takes a textbox name in the body that has values and makes them available to the header or the footer of the report

    Then on the footer use the GetData(1,1)

    So if text box name has name MySalespersonName with values Salesperson.Name, on the header create a hidden textbox with value =SetData(MySalespersonName,1). on the footer create a textbox with value =GetData(1,1)

    Make sure that SetData and GetData function are available from Report-> Report Properties-> Code

    Regards,
    Vasilis
Sign In or Register to comment.