basic theory about grouping in report

julkifli33julkifli33 Member Posts: 1,087
hi all.... i usually make report using wizard
after that i modified the report

all i want to know is basic theory how to grouping manually

for example i made report using table Sales Invoice Header
can anyone explain about these codes
thanks

1. Sales Invoice Header - OnPreDataItem()
LastFieldNo := FIELDNO("No.");

2. Sales Invoice Header, GroupHeader (3) - OnPreSection()
CurrReport.SHOWOUTPUT := FooterPrinted;
FooterPrinted := FALSE;

3. Sales Invoice Header, GroupHeader (4) - OnPreSection()
CurrReport.SHOWOUTPUT :=
CurrReport.TOTALSCAUSEDBY = "Sales Invoice Header".FIELDNO("No.");

4. Sales Invoice Header, GroupHeader (5) - OnPreSection()
CurrReport.SHOWOUTPUT :=
CurrReport.TOTALSCAUSEDBY = LastFieldNo;

5. Sales Invoice Header, GroupFooter (7) - OnPreSection()
IF NOT FooterPrinted THEN
LastFieldNo := CurrReport.TOTALSCAUSEDBY;
CurrReport.SHOWOUTPUT := NOT FooterPrinted;
FooterPrinted := TRUE;

Comments

  • rhpntrhpnt Member Posts: 688
    Instead of writing this post you should have invested the time into looking up SHOWOUTPUT and TOTALSCAUSEDBY in NAV online help.
    I suggest you read the ADG before diving into programming NAV.
  • Luc_VanDyckLuc_VanDyck Member, Moderator, Administrator Posts: 3,633
    rhpnt wrote:
    I suggest you read the ADG before diving into programming NAV.
    Did it occur to you that beginning NAV developers might not know what ADG is, and where it's located?
    No support using PM or e-mail - Please use this forum. BC TechDays 2024: 13 & 14 June 2024, Antwerp (Belgium)
  • rhpntrhpnt Member Posts: 688
    Oh, you mean like sitting behind the wheel of a car without reading the manual first or having a license?

    No, it didn't.
  • santa100santa100 Member Posts: 8
    [This text has been deleted by Administrator, because of bad words, lots of anger and malice agains other forum members.]

    But in this case rhpnt you were rigth, but you could share more.
    OP you should read ADG (aplication designer guide), this is pdf file located on navision instalation disc somewere ...\Navision\5sp1_SI\DVD_Signed\Doc\
    The file is called w1w1adg.pdf, and on the page 242 you should find what you are looking for.

    And just for the record the real man never reads a car manual. I have never ever read a car manual. That's like asking someone for directions when you are lost, you can't do that.
  • rhpntrhpnt Member Posts: 688
    [This posting has been deleted by Administrator, because of bad words, lots of anger and malice agains other forum members.]
  • matttraxmatttrax Member Posts: 2,309
    You two might want to take your differences off line...or at least through PMs. There's really no place for it here.
  • santa100santa100 Member Posts: 8
    O.k but before I end I just have to make clear that this statement:
    And just for the record the real man never reads a car manual. I have never ever read a car manual. That's like asking someone for directions when you are lost, you can't do that.

    Was meant like a joke and I forgot to put LoL at the end, my bad.
  • julkifli33julkifli33 Member Posts: 1,087
    santa100 wrote:
    But in this case rhpnt you were rigth, but you could share more.
    OP you should read ADG (aplication designer guide), this is pdf file located on navision instalation disc somewere ...\Navision\5sp1_SI\DVD_Signed\Doc\
    The file is called w1w1adg.pdf, and on the page 242 you should find what you are looking for.

    And just for the record the real man never reads a car manual. I have never ever read a car manual. That's like asking someone for directions when you are lost, you can't do that.

    thanks santa100
    your help means a lot
    (not like the other guy)
Sign In or Register to comment.