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

Scheduled Reports and Report Filters

 2 Replies
 0 Subscribed to this topic
 22 Subscribed to this forum
Sort:
Author
Messages
Charlotte Chase
Basic Member
Posts: 8
Basic Member
1/29/2010 6:52 PM

    Is there any way to have a dynamic Report Filter on a scheduled report, i.e. such that the scheduled report runs for a large dataset, but the user is prompted to supply an additional record filter parameter?

    It looks like the schedule requires a value to be supplied for the record filter, as well as the Crystal parameters. I'm trying to avoid having to create more complex bursting rights for some of our scheduled reports/or publish a million different iterations of the same report.  Thx!

    Jan
    Veteran Member
    Posts: 55
    Veteran Member
    1/29/2010 8:54 PM
      On a scheduled report there won't be any place for user intervention to select a parameter value. If you want to avoid making too many iterations of the same report, you could consider having the LBI report have a lot of data in an Excel format, then training the user to filter the larger set of data down to the particular subsets they need for particular needs.
      mark.cook
      Veteran Member
      Posts: 444
      Veteran Member
      2/2/2010 12:45 AM
        Usually the scheduled report for large datasets is run in off peak times like overnight. There is no way to prompt for user intervention while the scheduled report is updating. If you want parameters, you can add those to your report and make it on demand, you have to be careful that the large dataset will not impact performance of the system.