Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How can I sort data on two date basis?
If I select Calendar date then data sort by invoice date,doc date(using filter option for invoice date,doc date)
Hi narkamol,
If I understood your question correctly, your trying to sort the dates in your generated report based on the selection of the master Calender date.
To do so, you should link the tables together using Synthetic key. What I mean by these is that, whenever a selection on the Calender date is done, the report automatically generates a report based on the selection and the invoice dates.
Hope this explanation helps you out!
Best Regards,
Ram