For this example:
sp_report ProfitAndLossStandard show Text, Label, Amount_1 as Amount, Amount_1_Title as "As of" parameters DateMacro = 'ThisMonthToDate', SummarizeColumnsBy = 'TotalOnly'
All the predefined DateMacro options available to you are: |All|Today|ThisWeek|ThisWeekToDate|ThisMonth|ThisMonthToDate|ThisQuarter|ThisQuarterToDate |ThisYear|ThisYearToDate|Yesterday|LastWeek|LastWeekToDate|LastMonth|LastMonthToDate|LastQuarter |LastQuarterToDate|LastYear|LastYearToDate|NextWeek|NextFourWeeks|NextMonth|NextQuarter|NextYear|
But you can you can also specify a period using the DateFrom and DateTo parameters like this:
sp_report ProfitAndLossStandard show Text, Label, Amount_1 as Amount, Amount_1_Title as "As of" parameters DateFrom = {d'2007-01-01'}, DateTo={d'2007-05-16'}, SummarizeColumnsBy = 'TotalOnly'
See: How do I run a Profit & Loss Standard Report? for more. |