Changing the beginning statement date on Owner Statements
Added 2/9/2006 - Article ID#: KWin0016
Overview
The RDP Owner statements display the dates format “from 12/31/05 to 1/31/06” by default, but some properties would like
it to be formatted as “from 1/1/06 to 1/31/06”. Properties that have the “Always Process Owner
Statements on Calendar Month Only” switch set to No, prefer our default date
display. Properties with the switch set to Yes, prefer the “from 1/1/06 to
1/31/06” format.
Solution
In RDPWin 1.214 or higher, 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/06 to 1/31/06", follow
the steps below:
- Open the statement report in Crystal Designer.
- Open the OwnerRentalActivity sub-report
.
- Replace the PreviousStatementDate parameter ({?Pm-?PreviousStatementDate})
in the Report Header with the BegStatementDateDisplay formula ({@BegStatementDateDisplay}).
- Right-click on the BegStatementDateDisplay formula in the Report Header and
choose Format {@BegStatementDateDisplay}.
- Make sure the font, color, and size are the same as the rest of the text
in that textbox.
- 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.
- Click OK.
- Open the OwnerPayments sub-report.
- Replace the PreviousStatementDate parameter ({?Pm-?PreviousStatementDate})
in Report Footer a section with the BegStatementDateDisplay formula ({@BegStatementDateDisplay}).
- Right-click on the BegStatementDateDisplay formula in the Report Footer a
section and choose Format {@BegStatementDateDisplay}.
- Make sure the font, color, and size are the same as the rest of the text
in that textbox.
- 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.
- Click OK.
- Open the OwnerDirectCharges sub-report.
- Replace the PreviousStatementDate parameter ({?Pm-?PreviousStatementDate})
in Report Footer a section with the BegStatementDateDisplay formula ({@BegStatementDateDisplay}).
- Right-click on the BegStatementDateDisplay formula in the Report Footer a
section and choose Format {@BegStatementDateDisplay}.
- Make sure the font, color, and size are the same as the rest of the text
in that textbox.
- 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.
- Click OK.
- Save the report.
