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

Anyone Using non-Lawson scheduler to schedule, run, and distribute reports published in LBI

 3 Replies
 0 Subscribed to this topic
 22 Subscribed to this forum
Sort:
Author
Messages
Tim
Basic Member
Posts: 12
Basic Member
3/8/2011 9:24 PM
    Hi,

    We have a company standard enterprise job scheduler.  This product has the ability to run scripts, call URLs, call command-line commands, etc. 

     

    We would like to use this enterprise scheduler to schedule, run, and distribute LBI Crystal Reports to users.

    1.  Is it possible to schedule, run, and distribute reports that are published in LBI with non-Lawson scheduling tool?

    2.  How would this be accomplished?  Would we call something like the following URL to execute the report?

    http://ourLBIserverName:p...eportingServices:999

    3.  What would be the syntax to pass in parameters?

    4.  How do we get the output of the report and distribute via hyperlink or attachment?

    5.  Is it possible to use our own enterprise scheduler to schedule and run the LBI report and then use an Lawsons LBI Report Distribution mechanism (if any) to distribute the report?  If so, how do we call that?

    Thanks,

    Tim
    Matthew Nye
    Veteran Member
    Posts: 514
    Veteran Member
    3/9/2011 5:50 AM
      Tim,

      Ill keep it short but can elaborate after your reply:

      1. Yes
      2&3 Yes but check out the Reporting Services User guide Chapter 8 Scripting Reports. Theres some good info on parameters, usernames and passwords, etc from a URL.
      4. thats the difficult part. The only reliable way to do that is with a 3rd party tool to open the reports, search from a static string in a specific position, then rename the file.
      5. If you set up bursting on your reports they SHOULD be fired off when you call the URL to generate a historical instance. I say "should" because Ive never actually tried it but in theory it would work.


      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/
      Tim
      Basic Member
      Posts: 12
      Basic Member
      3/9/2011 1:29 PM
        Matt,

        Thanks for your reply.  I will take a look at the user guide and follow up if I have more questions.

        Thanks,

        Tim
        Tim
        Basic Member
        Posts: 12
        Basic Member
        3/9/2011 8:59 PM
          Matt,

          Thanks for your help. I think I have the URLs figured out to generate the report and save to disk and then another URL to put in an email and send to the user to retrieve the "Latest Instance"

          These URLs work great when I paste them into a browser session that is connected to LBI.

          When I open a new browser and paste the URL to generate the report, I am prompted by SSO for credentials.

          Now our scheduling tool will be submitting this URL to generate the report, but I have a gut feeling it will have the same sort of issue.

          Is there anyway to automate the SSO authentication for this scheduling tool? Not sure of the best way to have an outside process run the report without having to login. Any ideas?

          Thanks,
          Tim