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

Lawson back Office reports in Excel ?

 4 Replies
 0 Subscribed to this topic
 22 Subscribed to this forum
Sort:
Author
Messages
Ruma Malhotra
Veteran Member
Posts: 412
Veteran Member
5/7/2009 3:53 PM

    Usually publishing back office reports allows users to download only in pdf.

     

    Has anybody found a way to download backoffice reports in excel format?

    We have a number of RW100 backoffice reports that are published that can be downloaded in pdf format.I am investigating ways of downloading in excel.

    Tia.

     

    KJBULLS
    Basic Member
    Posts: 7
    Basic Member
    3/2/2011 10:53 PM
      Hi Ruma,

      Were you ever able to figure this out? We want to publish out backoffice reports as excel drillable files in LBI. Is that even possible?

      Thanks,
      KJ
      Ruma Malhotra
      Veteran Member
      Posts: 412
      Veteran Member
      3/3/2011 1:58 PM
        If you use your back office reports as a data source for crystal and then publish the report as a crystal report, You will be able to download into excel.

        If you are directly publishing back office reports to LBI, the only option is pdf.
        Ruma Malhotra
        Veteran Member
        Posts: 412
        Veteran Member
        3/3/2011 2:09 PM
          This is also one fo the main reasons why we chose dashboard gear and are implementing it. The hospital or clinical side requires business and clinical data to be integrated and if they had results on a pdf they were unable to extract the data, manipulate it and use clinical data to combine both.

          They needed the data in excel format so it could help them in transforming the data according to the needs which had patient side mixed with business type data.
          George Graham
          Veteran Member
          Posts: 201
          Veteran Member
          3/3/2011 2:31 PM
            I know this would take extra effort and not elegant - could you set up the report to generate the csv when it runs and then have a related link to the report that points to that csv? It doesn't give you the historical instances unless you managed that in a different way, but at least you could have the csv for the report run...