Sort by Shipment date

Business Central/NAV Developers Forum
1

hI All…

im new to navision dynamics. i have a problem in reporting.

i have a report its already sort by posting date but now i need to sort that same report in shipment date. ???

2

the field shipment date must be a key and then you can use

setcurrentkey(shipmentdate);

Regards,

Amol

3

What did you try and what problem are you facing?

Did you try to take help from seniors in your office?

4

actually seniors are so busy with their work and they told me to find out the solution by my own. so im trying for it.

I put shipment date in ReqFilterFields property but it didnt work… posting date also in this ReqFilterFields . so when i enter shipment date only it gives error by saying posting date cannot be blank. even i remove the posting date from there it gives the same error

So still im finding for a solution

5

Sorting is based on the key selected in DataItemTableView property not on ReqFilterFields…

Check what is selected in key…if you want to sort it on Posting Date and Shipment Date then you should have a key in table with those 2 fields…

make sure the effect if you change the sorting order in report…

And regarding the error…it is coded in OnPrereport trigger…

6

[:'(] or [:@]

7

I’d say AND