Changing primary key from in a report

qngo
qngo Member Posts: 58
edited 2006-04-07 in NAV/Navision Classic Client
I was wonder is it posssible to change the primary key in a report. I created a report for the Sales Header, my default sort is Order Date,No.,Bill-to Customer No.,Gen. Bus. Posting Group. I would like to give the user the option to change the sort to be by Bill-to Contact No.

Is this at all possible? Would this need to be done in Report - OnPreReport() where i would set the primary key?#-o

Comments

  • Sunset
    Sunset Member Posts: 201
    Don't set a sort order in the report. Then the user can select it at runtime
    Don't just take my word for it, test it yourself
  • qngo
    qngo Member Posts: 58
    how can a user change this when they run the report?
  • Marije_Brummel
    Marije_Brummel Member, Moderators Design Patterns Posts: 4,262
    A Sorting button appears on the report window.
    Marije Brummel | Freelance Business Central Specialist
  • Sunset
    Sunset Member Posts: 201
    When there isn't a predefined sorting order a button will appear in the buttom right corner called Sort
    Don't just take my word for it, test it yourself
  • qngo
    qngo Member Posts: 58
    Silly me, I didn't even notice that. Thanks a lot.

Categories