Sorting records in Sales Invoice report on Item code(No. in Sales Invoice Line table)

Hi,

I have made some changes in Sales Invoice report and another thing that I want to change is that records in this report to be sorted on Item code that is “No.” in Sales Invoice line table. I have tried adding keys in Sales invoice Line table(first I added “Document No., No.” as a key and then “No.” and then I chose this key at DataitemTableView property for the sales invoice Line table at sales invoice report but the records weren’t sorted or explained better, this resulted in loss of records when I changed the key from ascending to descending order. Is there any way to solve this or I should try another way(I thought another way was to sort the records in sales invoice at posting (when pressing post button) but I don’t have any idea how this could be done) I haven’ t changed the sorting of tables in Sales Invoice report, I mean the indentation and number of tables. Can anyone help me? Thanx in advance