Support Home New Sales Website Old Sales Website Contact Us
RDP Support  


RDPWin KB Booking Engine - IRM.Net RDPWin4 & PCI Compliance Search

Changing the Beginning Statement Date on Owner Statements

Added: 2/9/06
Updated: 6/18/12
Article ID#: KWin0016

Overview

The RDP Owner statements display the dates format “from 12/31/12 to 1/31/13” by default, but some properties would like it to be formatted as “from 1/1/13 to 1/31/13”.  Properties that have the “Always Process Owner Statements on Calendar Month Only” switch set to No, prefer the default date display.  Properties with the switch set to Yes, prefer the “from 1/1/13 to 1/31/13” format.

Solution

There is a formula called BegStatementDateDisplay in each of the OwnerRentalActivity, OwnerPayments, and OwnerDirectCharges sub-report.  In order to display the dates as "from 1/1/13 to 1/31/13", follow the steps below:


  1. Open the statement report in Crystal Designer.
  2. Open the OwnerRentalActivity sub-report.
  3. Replace the PreviousStatementDate parameter ({?Pm-?PreviousStatementDate}) in the Report Header with the BegStatementDateDisplay formula ({@BegStatementDateDisplay}).
  4. Right-click on the BegStatementDateDisplay formula in the Report Header and choose Format {@BegStatementDateDisplay}.
  5. Make sure the font, color, and size are the same as the rest of the text in that textbox.
  6. Make sure the date is formatted as just a date (not date and time) and is System Default Short Format (3/1/1999) like the rest of the dates on the report.
  7. Click OK.
  8. Open the OwnerPayments sub-report.
  9. Replace the PreviousStatementDate parameter ({?Pm-?PreviousStatementDate}) in Report Footer a section with the BegStatementDateDisplay formula ({@BegStatementDateDisplay}).
  10. Right-click on the BegStatementDateDisplay formula in the Report Footer a section and choose Format {@BegStatementDateDisplay}.
  11. Make sure the font, color, and size are the same as the rest of the text in that textbox.
  12. Make sure the date is formatted as just a date (not date and time) and is System Default Short Format (3/1/1999) like the rest of the dates on the report.
  13. Click OK.
  14. Open the OwnerDirectCharges sub-report.
  15. Replace the PreviousStatementDate parameter ({?Pm-?PreviousStatementDate}) in Report Footer a section with the BegStatementDateDisplay formula ({@BegStatementDateDisplay}).
  16. Right-click on the BegStatementDateDisplay formula in the Report Footer a section and choose Format {@BegStatementDateDisplay}.
  17. Make sure the font, color, and size are the same as the rest of the text in that textbox.
  18. Make sure the date is formatted as just a date (not date and time) and is System Default Short Format (3/1/1999) like the rest of the dates on the report.
  19. Click OK.
  20. Save the report.
Support Home  RDPWin4 & PCI Compliance Enhancement Requests Open A Web Support Ticket
Training New Sales Website Old Sales Website Contact Us

 Facebook     Twitter      LinkedIn   TODF