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

How to schedule crystal reports in LBI?

 3 Replies
 1 Subscribed to this topic
 22 Subscribed to this forum
Sort:
Author
Messages
Ada
New Member
Posts: 1
New Member
1/7/2010 4:11 PM

    Hi,

    I'm having problem with my scheduling. Have no instance on server whatsoever.

    My crystal report contains subreports. In crystal designer, I can preview the report including both main report and subreport content. I can also view the latest instance or with data refresh after report published.But when I create a schedule with parameter value assigned and bursting option structure defined. There isn't any instance bursted on my server.

    Did I missing anything when schedule? Any ideas?

    Thanks a lot,

    Ada

    Matthew Nye
    Veteran Member
    Posts: 514
    Veteran Member
    1/7/2010 4:33 PM
      Have you checked your log files to see if there were any errors?
      If any of my answers were helpful an endorsement on LinkedIn would be much appriciated! www.linkedin.com/pub/matthew-nye/1a/886/760/
      mark.cook
      Veteran Member
      Posts: 444
      Veteran Member
      1/7/2010 4:35 PM
        I would check the LBI logs to see if you have any messages that you can research.

        I have never had much success in scheduling reports that have subreports. They seem to take too long to run. The ones I have with subreports, I have set to run with data refresh when the users click on the link from the dashboard.
        Ruma Malhotra
        Veteran Member
        Posts: 412
        Veteran Member
        1/7/2010 10:05 PM

          If you include the subreport in the detail section of the report, for every record processed in the detail section the subreport will also be processed. So if you have 100 records in the detail section the subreport will be executed 100 times.

          It is a good practice to include the subreport at the footer section of the report unless you absolutely have to. This reduces the time it teakes for the report to refresh.