Skip to Content
avatar image
Former Member

Re: Previous month, Quarter months report.

Hi Gurus,

There is a requirement where the Audit reports(Most Accessed Documents) have to run automatically on

Monthly, Quarterly, Halfyearly basis without any prompts.

what is the solution for this requirement...

Thank you for the help !!!!!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Apr 25, 2016 at 09:57 AM

    Use predefined filters in the reports to schedule the reports without any prompt.All these conditions are based on the system date.

    All these are available in the audit universe.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      Based on the SQL the previous Month is for getting the data for previous Year and previous Month based on the current date. It is trying to fetch data for March 2015  if your current date is April 2016

      Where as your other filter conditions created at report level are fetching data for March 2016.

      So Year is different in both the conditions that is why you are not getting data.

      You can check this with custom sql by using these definitions in the where clause

      YEAR(DateAdd(yy,-1,CurrentDateTime.CurrentDate)) - YEAR(ADS_EVENT.Start_Time) ,

      MONTH(DateAdd(mm,-1,CurrentDateTime.CurrentDate)) - MONTH(ADS_EVENT.Start_Time)