CHAPTER 10 MANAGING REPORTS
TODAY()), when run at 12:01 AM on November 1, would return a value of 11, when the current
accounting period is 10-October. To account for January, you add an IIF function to evaluate the
DATEPART so that when 1 is returned for January, a 12 is returned, letting the report know to process the
December accounting period. So the correct expression is as follows:=IIF(DATEPART("m", TODAY()) = 1, 12, DATEPART("m", TODAY()) -1) Note Our sample database contains only a snapshot of data taken from a previous point in time. As such, if you
are following along the examples, you will need to enter a year and month contained within the sample database.
The majority of records are between September 2009 and December 2009. However, in a real world scenario of a
report requiring an End of Month frequency, use the above expressions.Updating and Uploading the RDL File Using Report Manager
For this section, you will navigate to the AR Reconciliation report in Report Manager and modify the
RDL manually to add the AcctPeriodMonth and AcctPeriodYear default parameter values via Notepad
instead of using BIDS. This will demonstrate that you can make simple modifications to published
reports without the need for a full-blown design environment. Open Report Manager, and navigate to
the AR Reconciliation report in the End of Month Financials folder on your report server, as shown in
Figure 10-3.