Viewing Previously Run Reports in Infor CRM Web

When you run a report in the Infor CRM Web client, the request it passed to the job server, which runs the report and saves it as a PDF. This PDF is saved in the attachment folder defined for CRM and it also creates a record in the attachment table. This information can be used to view previously run reports in CRM, who ran them, and even view the output of the file at the time it was run.

To View Previously Run Reports

You can use the following query to see the previously run reports as well as where the saved PDF files are located:

      reporthistory.pluginname as Report 
    , reporthistory.pluginfamily as ReportFamily 
    , reporthistory.createdate as RunDate 
    , userinfo.username as RunBy 
    , (
              top 1 attachmentpath  
              sitecode = (select primaryserver from sysdba.systeminfo where systeminfoid = 'PRIMARY')
      ) + '\' + attachment.filename as SavedFile 

    inner join sysdba.attachment 
    on reporthistory.attachid = attachment.attachid 
    left join sysdba.userinfo 
    on reporthistory.userid = userinfo.userid 
order by
    reporthistory.createdate desc

The results of this query will show you the following:

  1. The report that was run
  2. The date it was run
  3. Who ran the report
  4. Where you can find the PDF output of that report in the attachment folder

Note: To view this in the client, the report area does have a built-in report “History” group where you can see, and download, previously run reports as well. This data can be obtained via SData using the endpoint: /sdata/slx/dynamic/-/reportHistory

Keep in mind, this only applies to report run in the web client, not the LAN client (since the LAN client doesn’t use the job server to run reports).


Ryan Farley

Ryan Farley is the Director of Development for Customer FX and creator of He's been blogging regularly about SalesLogix, now Infor CRM, since 2001 and believes in sharing with the community. His new passion for CRM is Creatio, formerly bpm'online. He loves C#, Javascript, web development, open source, and Linux. He also loves his hobby as an amateur filmmaker.

1 Comment

  1. Hi Ryan,

    is it possible to disable this feature?

    Each time a report is run this creates a entry in the Notes/History section, this can soon build up preventing users from seeing important information regarding Accounts/Contacts.




Submit a Comment

Your email address will not be published. Required fields are marked *

Subscribe To Our Newsletter

Join our mailing list to receive the latest Infor CRM (Saleslogix) and Creatio (bpm'online) news and product updates!

You have Successfully Subscribed!