Options

Grouping a customer record on single page

mrigyamrigya Member Posts: 124
Hie All,
How can i get all the details of a single customer on single page,grouping on Pay-to Vendor No.,Order No.,No.
Thanks
Mrigya

Comments

  • Options
    garakgarak Member Posts: 3,263
    Report or form :?:
    Sometimes more informations are very helpfull ;-)

    Regards
    Do you make it right, it works too!
  • Options
    mrigyamrigya Member Posts: 124
    Its Report.
  • Options
    Sandeep_PrajapatiSandeep_Prajapati Member Posts: 151
    If I am getting u correctly, then..
    We can start a new page for a customer,but we can not gaurantee a page space to be always sufficient enough to be able to hold all information. (some customer may have more data compared to others.) :(

    If you can describe your report giving more information then may be there is somethig for u in the box. :P
    Sandeep Prajapati
    Technical Consultant, MS Dynamics NAV
  • Options
    mrigyamrigya Member Posts: 124
    Yes i want to start a new page for new customer...if records and more enough it will definitely go to the next page but that page should also include only same customer..i just want to start the new customer with new page.
  • Options
    Sandeep_PrajapatiSandeep_Prajapati Member Posts: 151
    Group by Customer No, and in OnPreSection() of Group Header of "Yourtable"
    CurrReport.SHOWOUTPUT :=   CurrReport.TOTALSCAUSEDBY = "Yourtable".FIELDNO("Customer No.");
    // If you use report wizard, the above code would be already there.
    If CurrReport.SHOWOUTPUT = TRUE then
      CurrReport.NEWPAGE;
    

    I hope it helps.. :P

    PS : This is parallel with your previous query in Mibuso. :wink:
    Sandeep Prajapati
    Technical Consultant, MS Dynamics NAV
Sign In or Register to comment.