Charliy asked for one feature (parameter value lists), and has learned that there is another feature (bursting) that works better in his situation. But there are actually 4 different similar features here that need to be clearly defined or people will be talking at cross-purposes. The terms One-Pass and Multi-Run (as related to bursting) and Parameter Value Lists are all my own terms, created and defined as part of my scheduler comparisons.
Bursting is taking single grouped report and turning it into lots of smaller pieces. Some vendors can do this in
"one-pass" to the database while others have to make repeated passes to the database, which I called
"multi-run". So the term "multi-run bursting" has nothing to do with filling in a parameter. Repeatedly filling in a parameter is a feature that I included for the first time in my most recent comparison of server-based schedulers (May 2013). It will probably also be included in the 2014 comparison of desktop-based schedulers which are the ones mentioned above. Here is how I named and defined these features:
Parameter Value Lists - Entry:
When you schedule a report with a single value parameter you are allowed to schedule it with a list of
parameter values. The values are passed to the parameter one at a time so that each value generates a
separate instance of the output.
Parameter Value Lists - Query:
When you schedule a report with a single value parameter you are allowed to schedule it with a SQL
Query. The results of the query are passed to the parameter one at a time so that each value generates
a separate instance of the output.
Because this was the first time these features were included the definitions might evolve based on feedback from different vendors.
Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guides to Formulas, Parameters, Subreports, Cross-tabs, VB, Tips and Tricks
