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

LBI report information in a report

 4 Replies
 0 Subscribed to this topic
 22 Subscribed to this forum
Sort:
Author
Messages
Greg Moeller
Veteran Member
Posts: 1498
Veteran Member
1/26/2010 6:02 PM

    All:

    I have been tasked with creating a report containing the LBI report number, LBI Report name, LBI report owner, LBI report schedule, and LBI Report Users.

    I can pull the first three out of the ERS_REPORT table, but where would I find the schedule and report users?

    Thinking a Y/N flag would suffice for the schedule, but the users may want Weekly, Daily, time it runs, etc.

    The report users- ??  Where do I go for those, and how do I link the tables appropriately?

    Thanks for any help given,

    -Greg

    Greg Moeller
    Veteran Member
    Posts: 1498
    Veteran Member
    1/26/2010 6:28 PM
      More info found: I can get the schedule name from EJS_TRIGGERS or EJS_CRON_TRIGGERS, but how do I tie either of those tables back to ERS_REPORT ? The only thing I can guess (and it is strickly a guess) is via another table.

      Much appreciation for any suggestions,
      -Greg
      Chad Dirst
      Advanced Member
      Posts: 25
      Advanced Member
      1/26/2010 7:04 PM
        Greg, The ERS_REPORTACCESS table contains an ACCESS_TYPE and ACCESS_VALUE column which states the reports access rights per user or group. This information can also be mapped to the ERS_LISTUSERS table.
        Greg Moeller
        Veteran Member
        Posts: 1498
        Veteran Member
        1/26/2010 7:14 PM
          Thanks, Chad. That is very helpful. Now if I could get one of those TRIGGER tables tied to those other two, I'd be set.
          Anyone out there with help?

          Thanks again,
          -Greg
          Greg Moeller
          Veteran Member
          Posts: 1498
          Veteran Member
          1/26/2010 8:36 PM
            Got it all!! Thanks much.

            Figured out that ERS_REPORTACCESS.JOBNAME is the schedule name, so no need for the other tables.

            Thanks again!!