Daily Works OK, Monthly No Response

pockeyfan

Hi, all

I tried CD and have no problem with reports which are exported daily. However, CD did not export reports which are defined to run once a month...

I set the "Export Interval" to "Specific Day of Month" and "value" to "last day", that is, the report will run at the last day of each month.
Besides, "Export Days" is set to "ALL days" and the "Export Time Envelope" is between "01:15 pm" to "02:15 pm"

I can view the report and export it manually, however, could not get the exported file under "Auto Mode"...
I tried several times by change the system time to the specific time on the last day of some months, but get no result...

Anyone has any idea? Thanks a lot!

pockeyfan · Posted: Tue Sep 16, 2008 8:03 pm Post subject:

Well, auto mode works fine if I select "30" as the "value" for "specific day of month", does that mean CD could not check whether the system time is the last day of the month?

From help file, "In automatic mode, all exports except Forced Export and Do Not Export use the time difference between the Run History and the current system date and time to determine if a report needs to be exported", I'd like to know how CD check whether it's the last day of every month as it differs from month to month...

As I have to print the report at the end of each month, I do need to use "last day" of each month...

Anyone has any idea?

pockeyfan · Posted: Wed Sep 17, 2008 12:01 am Post subject:

Well, I find it's OK for CD to export reports on "first day of month", so I changed the export time to the first day of each month, for the input parameter @start_date and @end_date:

@start_date = [y]-[m:-1]-[d] or [y]-[m:-1]-01
@end_date = [ymd:-1]

So the date range will be the previous month, just what I want.

Hope CD could work correctly with "last day" soon:)

Ah...There's another problem, for the [y], if I print the report at 2008-01-01, the @start_date will be "2008-12-01" and the @end_date is right "2007-12-31"...

So, I have to modify these parameter at the beginning of each year Confused

pockeyfan · Posted: Wed Sep 17, 2008 8:09 pm Post subject:

Well, to solve the [y] problem, I tried to run the same report annually at the first of each year...and try to overwrite the monthly run report whose date range is incorrect.

The configuration for annually run report:

Every Year 1

@start_date = [y:-1]-[m:-1]-[d]
@end_date = [ymd:-1]

Just to make sure the report will be exported at the first day of each year...