Changing primary key from in a report

qngo

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

Sunset

Don't set a sort order in the report. Then the user can select it at runtime

qngo

how can a user change this when they run the report?

Marije_Brummel

A Sorting button appears on the report window.

Sunset

When there isn't a predefined sorting order a button will appear in the buttom right corner called Sort

qngo

Silly me, I didn't even notice that. Thanks a lot.