Hi All,
I've made a report to display open orders from the Sales Header table sorted by Order Date.
But, I want to sort and do the group totals by the week number of the order date on the report.
The week number is not a field in the table but Iam using the function DATE2DWY("Order Date",2) to display the week number.
Can anyone please guide ?
Thanx a lot in advance.
Thanks & Best Regards,
Ram.
0
Answers
Use this table as dataitem and filter it to show week number only. Then use the Start and EndDate field to filter your open orders to print underneath it.
Independent Consultant/Developer
blog: https://dynamicsuser.net/nav/b/ara3n
be smart before being a clever.
Thanx a lot for your advise.
I dont have week number as a field on the Sales Header table.
Please confirm if Iam on the same page as you.
Dear sendoh,
Thanx a lot to u too for your advise.
Can you please explain in detail ?
Thanx again to both of u.
Ram.
The date table has also start and end date that you will use to filter on posting date.
Then use the Start and EndDate field to filter your open orders
Independent Consultant/Developer
blog: https://dynamicsuser.net/nav/b/ara3n
Thanx again.
I would like to know how to view the Date table like you have displayed in your previous reply. Because I cannot find the Date table or table id 2000000007 in my Object list of tables ?
Ram.
just create a form based on this table.