Prev
Next
Forums Performance Management Lawson Business Intelligence/Reporting/Crystal

Report Schedules

 4 Replies
 0 Subscribed to this topic
 22 Subscribed to this forum
Sort:
Author
Messages
Ruma Malhotra
Veteran Member
Posts: 412
Veteran Member
7/10/2009 3:02 PM
    I am wondering if anybody has found out a way to get notified whenever a report scheduled to refresh at a particular day and time fails to refresh without going through the log files.

    On reporting services for maintain schedules the status of success or waiting is not the true status of whether the report refreshed but the status which defines that the handoff for reporting services to CRAS to refresh was successful or not.

    Also we are on version 9031 in test and 9022 on prod ans was wondering where the information about a report, the schedule bname and the day and time of schedule is stored.  I am looking to create a report and I cannot see where this information is stored. But maybe I am overlooking something since there is absolute no documentation on this.

    Thanks in advance
    Greg Moeller
    Veteran Member
    Posts: 1498
    Veteran Member
    7/13/2009 2:09 PM
      I would really be interested in this capability as well. We have tons of reports that our users and Managers have come to rely on, and when they don't get them it can cause a snowball effect.
      Ruma Malhotra
      Veteran Member
      Posts: 412
      Veteran Member
      7/13/2009 2:21 PM
        I am thinking of adding an enhancement request on lawson Support site to provide us of an report that will gives us the schedule names, scheduled time and frequency, Last refresh date, next refresh date and whether the report refreshed successfully or not(status).
        Matthew Nye
        Veteran Member
        Posts: 514
        Veteran Member
        7/13/2009 2:21 PM
          it would require parsing the RS repository tables. This can be difficult because some of the fields are blob or encoded. Another way would be to create some custom server side pages to interject during the 4 accessible Events of a report run:
          - Report Request Received
          - Parameter Selection
          - Parameter Validation
          - Report Request Complete

          Using these and information included in the referring URLs you could determine which report requests were based on a user and which were based on a schedule and whether or not it completed. You could then log this in a file or custom database table and create a SmartNotification to email to the responsible parties.

          unfortunately though, there are not ou-of-box solutions for this that I know of.

          hth
          matt
          If any of my answers were helpful an endorsement on LinkedIn would be much appriciated! www.linkedin.com/pub/matthew-nye/1a/886/760/
          Ruma Malhotra
          Veteran Member
          Posts: 412
          Veteran Member
          7/13/2009 2:59 PM
            Thanks for replying. This defnitely helps. However I do not know java programming to create any server side pages and nobody on our staff knows this as well. Also if we have to interject a script during the processing of a report refreshing we are skeptical in doing this as we do not want to mess with normal processing. We also defnitely know for a fact that lawson will not support us. 

            End result is to carry on with the normal side of things but I will defnitely create an enhancement request as I have a very strong business justification need for this hoping that the request will be entertained in the near future.

            However thanks once again for the reply.