4 dates parameter - how to automate

[EBee]

I would like to shedule our reports to run weekly without entering 4 date parameters. and based on 5-4-4 accounting period dates.

StartDate . . . first day of each period
EndDate. . . . Current date
LY_StartDate . . first day of last year same period
Ly_EndDate . . . Same date for last year(current date)

I have a period_Dates Table populated and have the following

Calendar_Date = datefield
Period_year = number
Period = number
DayofPeriod = number

My code below seems to have the logic needed to get the dates, however, it does not work. Please help
thank you.

======================================================
//?StartDate
if {mc_period_dates.calendar_date} = today then

local numbervar period1 := {mc_period_dates.period};
local numbervar dayofperiod1 := 1;
local numbervar periodyear1 := {mc_period_dates.period_year};

if {mc_period_dates.period} = Period1 and
{mc_period_dates.day_of_period} = dayofperiod1 and
{mc_period_dates.period_year} = periodyear1 then

{mc_period_dates.calendar_date}

 

[chelseatech]

Our cViewMANAGER and cViewSERVER report schedulers include support for 4-4-5 week reporting using our Business Calendar and Dynamic Date functions.

You can load the start and end date parameter values automatically inside the scheduler

Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm