Hi, Crystal Report newbie here.
I am trying to design a monthly sales analysis report for my company. They would need to enter the desired month and the report would display all sales in that month. I have used the Calendar_Date table for the month parameter. My problem now is I don't know how to select the records so that it displays all sales for the month selected. The sales date in the table is in the Julian format so I have converted it.
Can someone please tell me how to select the records? Thanks in advance.