RanceLab

Find answers to common RanceLab questions, browse curated FAQ sections, and search across the knowledge base.

FAQ
Sales Management
/Reports
/Sale and Sale Return Register

How to add 'day of the week' in the sale register?

Step 1: Set 'Filter Mode' to 'Value':

    1. From main menu go to the Sale Register (S > R > S)
    2. Right click on the column header "Date"
    3. Set "Filter Mode" to "Value" in the list as shown in the picture below.

Filter mode

Step 2: Add a Column:

    1. Press ALT + K or click on "-K Add Column" button in the Sale Register
    2. Then follow the steps as shown in the picture below:

Summary Type

Step 3: Add the following in expression editor:

Iif(GetDayofWeek([Date])=1,'Monday',

Iif(GetDayofWeek([Date])=2,'Tuesday',

Iif(GetDayofWeek([Date])=3,'Wednesday',

Iif(GetDayofWeek([Date])=4,'Thursday',

Iif(GetDayofWeek([Date])=5,'Friday',

Iif(GetDayofWeek([Date])=6,'Saturday','Sunday'))))))

Week Name wise report

Step 4: Save the report using "F10 Save View" button for future use.

Use following variable to see Month Name in report:

Iif(GetMonth([Date])=1,'January',
Iif(GetMonth([Date])=2,'February',
Iif(GetMonth([Date])=3,'March',
Iif(GetMonth([Date])=4,'April',
Iif(GetMonth([Date])=5,'May',
Iif(GetMonth([Date])=6,'June',
Iif(GetMonth([Date])=7,'July',
Iif(GetMonth([Date])=8,'August',
Iif(GetMonth([Date])=9,'September',
Iif(GetMonth([Date])=10,'October',
Iif(GetMonth([Date])=11,'November','December')))))))))))
...

Use following variable to see Year Name in report:

GetYear([Date])