ReportCaster > Creating Schedules > About Tasks in the Basic Scheduling Tool

About Tasks in the Basic Scheduling Tool

Topics:

When you access the Basic Scheduling tool, the information for the Task tab options is predefined with the selected report procedure (FEX) information. You can complete the available task options, such as specifying parameter values, as well as select whether or not to burst the report.

Note:

Task Options in the Basic Scheduling Tool

The options available when you select the Task tab are:

  • Path. Shows the report path in the Repository or on the Reporting Server.
  • Procedure. The name of the procedure you are scheduling.
  • Server Name. The Reporting Server to which the report procedure (FEX) will be submitted.
  • Execution ID. The user ID running the report procedure (FEX) on the Reporting Server. Click on the Password button to the right of this field to set the password.
  • Password. Enter a password for the Execution ID.
  • Alert. Specifies how to reactivate the alert or to deactivate the alert condition when it is triggered. Click Alert to specify the alert options.

    Select one of the following options from the Alert Options dialog box.

    • Automatically Reset. After the alert is triggered, reactivate the alert when the condition is no longer true. The system will keep checking the condition after the alert has been triggered. As soon as the condition is no longer true, it will reactivate the alert. This is the default value.
    • Continue After Alert. After the alert is triggered, reactivate the alert immediately.
    • Deactivate Schedule After Alert. Deactivate the schedule after the alert is triggered.
    • Delay. Restart the alert after a specified period. You can specify to restart the alert after a maximum of 99 hour(s), day(s), week(s), month(s), or year(s).

      Caution: Be sure that you set the schedule interval to a time period greater than the time it takes to run the scheduled procedure. When the schedule interval is less than the time it takes to run the procedure and the Delay option is selected, an alert schedule will distribute (based on the distribution option that you selected) more frequently than expected. For email distribution, this can result in unnecessary distribution of emails which can impact the business or operational goals of the alert report distribution.

  • Enabled. Selected by default, this option allows you to disable a task.

Report Properties

  • Burst Report. If you want to burst the report, select the Burst Report check box. The burst feature enables you to instruct the Reporting Server to create the report in sections so that they can be distributed separately. For more information, see Bursting a Report.
  • Override the Format Specified in the Procedure. Select this check box to display the list of report formats and indicate a format other than the one specified in the procedure.
    Note:
    • If the scheduled report is a compound report that uses the stabilized SET COMPOUND OPEN syntax, you must select the Override the Format Specified in the Procedure check box and specify the format in the schedule when scheduling this report. Otherwise, the report will not be distributed. Compound reports produced by the WebFOCUS and App Studio reporting tools such as InfoAssist and the App Studio Document canvas do not require that the Override the Format Specified in the Procedure check box be checked.

    • FLEX, VISDIS, and VISDISAE report output formats are no longer supported. If you are editing a task that uses one of these formats within a schedule, you can change the output format in the dialog box that opens.

      • If you click OK, and the output format of the report is set to FLEX, the task output is saved as AHTML.
      • If you click OK, and the output format of the report is set to VISDIS or VISDISAE, the task output is saved as HTML.
      • If you click Exit, the output format will not be changed, and any changes that you made to the task will not be saved.
    • When an existing schedule is opened in the Basic Scheduling tool, if the Override the Format Specified in the Procedure check box was selected, the list of formats displays. If you clear the Override the Format Specified in the Procedure check box, the list of formats does not display.
    • When an existing schedule is opened in the Basic Scheduling tool, if the Override the Format Specified in the Procedure check box was not selected, the list of formats does not display. If you select the Override the Format Specified in the Procedure check box, the list of formats displays.
  • Save Report As. Allows you to specify a different name for the report, which defaults to the name of the report that you selected to schedule.
    Note: When the Save Report As field contains an amper variable followed by a file extension, the separating characters between the amper variable and the file extension must be either two additional period (.) characters, or a single vertical bar (|) character, as shown in the following examples.
    • The file extension is preceded by two additional period characters. For example, car_&YYMD…csv.
    • The file extension is preceded by a vertical bar character. For example, car_&YYMD|.csv.

Specifying Parameter Values

Topics:

How to:

Reference:

You can customize a report and control its execution with parameters. When scheduling a report procedure (FEX), the schedule Task Parameters section allows you to supply a value for parameters referenced in the report procedure or add a parameter to the schedule by creating a new parameter and specifying the parameter name and value.

If your Server Procedure contains Pre/Post Procedures, see How to Use the pre- or post-procedures Tab or a Web Query Report.

Procedure: How to Specify Parameter Values

If the scheduled procedure contains parameters for which values must be supplied at run time, these parameters are displayed in the parameters section of the scheduling tool.

In the Basic Scheduling tool, click the Parameters tab to open the Task Parameters dialog box, shown in the following image.

Parameters may have default values and may have values that can be selected from a static or dynamic list. For more information about selecting parameters in the Scheduling Task Parameters dialog box, see the examples provided in this chapter.

Reference: Considerations When Specifying Parameter Values

The following are considerations when specifying parameter values for a procedure:

  • The maximum number of characters for each individual parameter value is 3200. You can store multiple values for a single parameter. Multiple values for a parameter are stored as one entry, which must not exceed the 3200 maximum character limit.
  • ReportCaster displays the description for the parameter when it is specified in the procedure. Otherwise, ReportCaster displays the parameter name.
  • ReportCaster displays default variable values, as well as static or dynamic single-select and multiselect lists.

    Note:

    • The No Selection option is displayed for dynamic multiselect lists. When selected, this option does not perform any data selection test on that field.
    • ReportCaster does not support using the -HTMLFORM command to create a dynamic selectable list of parameter values.

  • ReportCaster displays global variables that are used in FILTERS defined in Master Files and referenced by a procedure. For example, if a Master File contains 

    FILENAME=CAR,SUFFIX=FOC
VARIABLE NAME=&&COUNTRY1, USAGE=A10, DEFAULT=ENGLAND,$
FILTER FILTER1=COUNTRY EQ '&&COUNTRY1'; $

    and the procedure being scheduled contains 

    WHERE FILTER1

    then ReportCaster displays COUNTRY1 in the Parameters window.

  • ReportCaster will not prompt for variables with defaults set by the -DEFAULTH command. The purpose of the -DEFAULTH command is to assign a default value to amper variables and not be dynamically prompted for that variable.
  • ReportCaster does not prompt for the value of its internal variables that are set by the Distribution Server at schedule execution time. For example, &DSTOWNER is the user ID of the schedule owner. If this parameter is referenced in a scheduled procedure, the value will be available because the Distribution Server sets the value to the owner of the schedule at schedule execution time. However, the scheduling tool will not prompt for this value in the Task Parameters dialog box.
  • When specifying parameters with special characters (for example, %, &, |):
    • If you are specifying the entire WHERE condition as the parameter value, you must enclose the value within two single quotation marks rather than a double quotation mark. For example, ''WHERE CAR NOT LIKE MOTO%''.
    • If you are only specifying a value as the parameter value, you do not need to enclose the parameter value within quotation marks. For example, O&DINFO.
  • If you want to specify parameter values in a pre-processing or post-processing procedure, these must be typed in by selecting the Pre/Post-RPC tab. See Schedule Pre-Processing and Post-Processing Procedures for information about schedule pre-processing and post-processing procedures.
  • Once a parameter is stored for a schedule, ReportCaster will continue to display that parameter in the Parameter list and submit the parameter to the Reporting Server when the schedule is run even if the parameter is removed from the underlying report. To remove the parameter from the schedule information, edit the schedule and delete the parameter. For information on how to delete a parameter from a schedule, see Deleting a Parameter.
  • A parameter value that contains special characters should not be used in a schedule setting that refers to an output file name, since file names cannot contain special characters. Examples of affected schedule settings include the Save Report As value, the Report Name value for single-file FTP distribution, and the Zip File Name.
  • A FEX can be coded to set the Display Value for any value. For example, if a value is named ENGLAND, the Display Value can be set to display as England.

Example: Specifying a Default Parameter Value in the Report Procedure (FEX)

Specifying default parameter values can be done with the -DEFAULT or -DEFAULTH command or within the WHERE statement. Default values specified with the -DEFAULTH command are not prompted for.

The following procedure sets a default value of NY for the STATE (2-3 letters for US State) parameter. 

-DEFAULT &STATE=NY 
TABLE FILE GGSALES
SUM DOLLARS UNITS
BY ST
BY CATEGORY
BY PRODUCT
ON TABLE SUBHEAD
"Product Sales Report"
WHERE ST EQ '&STATE.2-3 letters for US State.' 
END

The parameters that have default values defined in the report procedure (FEX) are listed within the Parameters tab with the default value in the Value column. When parameters are stored in a schedule, ReportCaster adds a -SET for the parameter to the schedule procedure sent to the Reporting Server to be run. A -SET command overrides a value specified in a -DEFAULT command.

The following image shows the Task Parameters dialog box displaying the STATE parameter. In the Use Default column, the State parameter shows a value of Yes. In the Parameter Properties section, NY is shown in the Value and Default Value fields. This is the default parameter value.

To use a value other than the default value at schedule execution time, so that it will be used even if the procedure is changed, click the parameter and change the parameter value within the Parameter Properties section. Values for simple parameters are specified by entering a value for the parameter in the Value field. There are also static and dynamic parameter types that allow selection of a single or multiple values, which are explained in the following examples.

When parameters are stored in a schedule, ReportCaster adds a -SET for the parameter to the schedule procedure sent to the Reporting Server to be run. A -SET command overrides a default value specified in a -DEFAULT command.

Example: Adding a Static Single-Select List of Parameter Values

The following procedure provides a list of static values that are valid for the CATEGORY (Category) parameter. 

-DEFAULT &STATE=NY
TABLE FILE GGSALES
SUM DOLLARS UNITS
BY ST
BY CATEGORY
BY PRODUCT
ON TABLE SUBHEAD
"Product Sales Report"
WHERE ST EQ '&STATE.2-3 letters for US State.'
WHERE CATEGORY EQ '&CATEGORY.(Coffee,Food,Gifts).Category.' 
END

The following image shows the Task Parameters dialog box displaying the CATEGORY parameter. In the Value column, the CATEGORY parameter has a value of Coffee. Since this CATEGORY parameter has a list of possible parameter values, there is no default value specified. Therefore, the Use Default column is blank.

To supply a value for a single select parameter, select the parameter in the Task Parameters table and enter a value in the Value field in the Parameter Properties section. From the list of the values, select a value to assign to the parameter. You can select only one value for a static single-select parameter.

Example: Adding a Dynamic Single-Select List of Parameter Values

The following procedure provides a single select list of values that are valid for the PRODUCT (Product Name) field. This list is dynamically populated with values from the GGSALES data source. 

-DEFAULT &STATE=NY;
TABLE FILE GGSALES
SUM DOLLARS UNITS
BY ST
BY CATEGORY
BY PRODUCT
ON TABLE SUBHEAD
"Product Sales Report"
WHERE ST EQ '&STATE.2-3 letters for US State.'
WHERE PRODUCT EQ '&PRODUCT.(FIND PRODUCT IN GGSALES).Product Name.' 
END

The following image shows the Task Parameters dialog box displaying the PRODUCT parameter. In the value column, the PRODUCT parameter has a value of Espresso. Since the PRODUCT parameter has a list of possible parameter values, there is no default value specified. Therefore, the Use Default column is blank.

To supply a different value, click the PRODUCT parameter in the table and change the parameter value within the Parameter Properties section. You can select only one value from the dynamic single-select list.

Example: Adding a Static Multiselect List of Parameter Values

The following procedure provides a static multiselect list of values that are valid for the CATEGORY (Category) field. 

-DEFAULT &STATE=NY
TABLE FILE GGSALES
SUM DOLLARS UNITS
BY ST
BY CATEGORY
BY PRODUCT
ON TABLE SUBHEAD
"Product Sales Report"
WHERE ST EQ '&STATE.2-3 letters for US State.'
WHERE CATEGORY EQ '&CATEGORY.(OR(Coffee,Food,Gifts)).Category.' 
END

The following image shows the Task Parameters dialog box displaying the CATEGORY parameter. The CATEGORY parameter has been encoded to only use the values Coffee, Food or Gifts. The selected values will show in the Value column. Since the CATEGORY parameter has a list of possible parameter values, there is no default value specified. Therefore, the Use Default column is blank.

When the Value button is selected in the Parameter Properties section, a list of available values displays, as shown in the following image. Using the Ctrl key, you can select more than one value from the static multiselect list.

Example: Adding a Dynamic Multiselect List of Parameter Values

The following procedure provides a dynamic multiselect list of values that are valid for the PRODUCT field. This list is dynamically populated with values from the GGSALES data source. 

-DEFAULT &STATE=NY;
TABLE FILE GGSALES
SUM DOLLARS UNITS
BY ST
BY CATEGORY
BY PRODUCT
ON TABLE SUBHEAD
"Product Sales Report"
WHERE ST EQ '&STATE.2-3 letters for US State.'
WHERE PRODUCT EQ '&PRODUCT.(OR(FIND PRODUCT IN GGSALES)).Product Name.' 
END

The following image shows the Task Parameters dialog box displaying the CATEGORY parameter. The CATEGORY parameter has been encoded to use any value found in the GGSALES data source. The selected values will show in the Value column. Since the CATEGORY parameter has a list of possible parameter values, there is no default value specified. Therefore, the Use Default column is blank.

When the Value button is selected in the Parameter Properties section, a list of available values displays, as shown in the following image. Using the Ctrl key, you can select more than one value from the dynamic multiselect list.

Using Parameter Values to Burst Active Dashboards and Compound Reports

Topics:

How to:

In addition to the ability to distribute sections of a single report to individual users using standard bursting, you can distribute sections of reports by using a filter with a static or dynamic multi-select parameter.

Active dashboards, which are compound reports that contain active reports, and reports that use an Excel format output, can be burst by using the parameter values saved in these reports. You can also burst Excel reports that contain a table of contents. You can burst these reports using a field other than the first BY field.

The Repeat Task for Each Selected Value check box must be selected in order to burst each parameter separately. In both the Basic and Advanced Scheduling tools, the Repeat Task for Each Selected Value check box is found in the Parameter Value for Amper Variable dialog box, as shown in the following image.

An image showing the Parameter Value for Amper Variable dialog box. The countries, France, Italy, and Japan are selected.
Note:
  • This check box is cleared by default.
  • The Repeat Task for Each Selected Value check box only displays for static or dynamic multiselect parameters.
  • At least one parameter value must be selected.
  • If the All Values check box is selected, the term _FOC_NULL appears in the Value field of the Task Parameters dialog box. The server then performs a WFDescribe at run time to generate the list of values for the parameter.
  • The Repeat Task for Selected Parameter Value feature can only be applied to one parameter at a time.
  • If the Burst Report check box within the Task tab is selected first, then the Repeat Task for Each Selected Value check box will be disabled and cannot be selected. The two bursting methods cannot be combined in one schedule.
  • If the Repeat Task for Each Selected Value check box is selected on the Parameter Value dialog box, then the Burst Report check box within the Task tab becomes the Burst Report by Parameterized Report Filter check box. This check box will now be automatically selected and cannot be cleared unless the Repeat Task for Each Selected Value check box is cleared.

The values you choose are shown in the Task Parameters dialog box and placed between square brackets in the Value column to indicate their selection, as shown in the following image.

An image showing the Task Parameters dialog box. The Country parameter is selected.

Once the schedule is run, the Distribution Server repeats the execution of the task for each parameter selected. For example, since the parameter values Japan, Italy, and France are selected, and the Repeat Task for Each Selected Parameter check box is selected, the schedule bursts the report information into three separate reports. Each report shows information related to one of the three selected parameters, as shown in the following image.

An image showing the burst results of a schedule that utilizes the Country parameter.

Running Pre and Post-Processing Procedures for Each Parameter Value

Selecting the Repeat Task for Each Selected Value check box allows you to select the Run Pre/Post-RPC Every Time check box, as shown in the following image.

The Parameter Value for Amper Variable dialog box. The Run Pre/Post-RPC Every Time checkbox has been selected.

The Run Pre/Post-RPC Every Time check box enables the Distribution Server to run pre-processing and post-processing procedures with each task repetition.

For example, if three parameter values are selected, and the Run Pre/Post-RPC Every Time check box is selected, pre-processing procedures run before each selected value, and post-processing procedures run after each selected value.

If you do not select this check box, pre-processing procedures execute only once before the first task is executed, and post-processing procedures execute only once after the last task is executed. This check box is cleared by default.

Note: The Run Pre/Post-RPC Every Time check box cannot be selected unless the Repeat Task for Each Selected Value check box is selected first.

Procedure: How to Burst a Filtered Active Dashboard or Excel Compound Report Using the Basic Scheduling Tool

  1. Create an active dashboard or Excel compound report that contains at least one static or dynamic multiselect parameter. For more information, see the InfoAssist User’s Guide.
  2. Right-click the report, point to Schedule, and select a distribution method to begin a new Basic Schedule.
  3. In the Options group, click Parameters.

    The Task Parameters dialog box opens.

  4. Choose the parameter you wish to edit.

    Once the parameter is chosen, the Parameter Properties section is populated with information about the selected parameter.

  5. In the Parameters Properties section, click the Value button.

    Note: For the Value button to be able to be selected, the chosen parameter must be a multiselect parameter.

    The Parameter Value for Amper Variable dialog box opens.

  6. Choose the values that you want the schedule to burst. While holding the Ctrl key, use your mouse to select more than one value. To choose all values, select the All Values check box.
  7. Select the Repeat Task for Each Selected Value check box.
  8. Optionally, select the Run Pre/Post-RPC Every Time check box. For more information, see Running Pre and Post-Processing Procedures for Each Parameter Value.
  9. Click OK.

    The selected parameter values now appear in square brackets in the Task Parameters dialog box in the Value column, as shown in the following image.

    An image showing the Task Parameters dialog box. The Country parameter is selected.
  10. Click OK.
  11. Input all other necessary options and settings for your schedule, then save the schedule. For more information, see Creating a Schedule in the Basic Scheduling Tool.
  12. Run the schedule.

    When the schedule is run, it distributes a report for every burst parameter that you selected, as shown in the following image.

    An image showing the burst results of a schedule that utilizes the Country parameter.

Procedure: How to Burst a Filtered Active Dashboard or Excel Compound Report Using the Advanced Scheduling Tool

  1. Create an active dashboard or Excel compound report that contains at least one static or dynamic multiselect parameter. For more information, see the InfoAssist User’s Guide.
  2. Right-click the folder that the report is located in to begin a new Advanced Schedule.
  3. Click the Tasks tab.
  4. Click the arrow next to the New button to select a task type and create a new task.
  5. Click the Parameters tab.

    Note: The Parameters tab is available only when WebFOCUS Server Procedure or WebFOCUS Report is selected.

  6. Choose the Parameter you wish to edit.

    Once the parameter is chosen, the Parameter Properties section is populated with information about the selected parameter.

  7. In the Parameters Properties section, click the Value button.

    Note: For the Value button to be able to be selected, the chosen parameter must be a multiselect parameter.

    The Parameter Value for Amper Variable dialog box opens.

  8. Choose the values that you want the schedule to burst. While holding the Ctrl key, use your mouse to select more than one value. To choose all values, select the All Values check box.
  9. Select the Repeat Task for Each Selected Value check box.
  10. Optionally, select the Run Pre/Post-RPC Every Time check box. For more information, see Running Pre and Post-Processing Procedures for Each Parameter Value.
  11. Click OK.

    The selected parameter values now appear in square brackets in the Task Parameters dialog box in the Value column, as shown in the following image.

    An image showing the Task Parameters dialog box. The Country parameter is selected.
  12. Click OK.
  13. Input all other necessary options and settings for your schedule, then save the schedule. For more information, see Creating a Schedule in the Basic Scheduling Tool.
  14. Run the schedule.

    When the schedule is run, it distributes a report for every burst parameter that you selected, as shown in the following image.

    An image showing the burst results of a schedule that utilizes the Country parameter.

Procedure: How to Burst a Filtered Active Dashboard or Excel Compound Report Using the Advanced Scheduling Tool

  1. Create an active dashboard or Excel compound report that contains at least one static or dynamic multiselect parameter. For more information, see the InfoAssist User’s Guide.
  2. On the WebFOCUS Home page, click the domain in which you want to create a new schedule.
  3. On the Actions bar, click Schedule, and then click the Schedule button.

    The Advanced Scheduling tool displays.

  4. Click the Tasks tab.
  5. Click the arrow next to the New button to select a task type and create a new task.
  6. Click the Parameters tab.

    Note: The Parameters tab is available only when WebFOCUS Server Procedure or WebFOCUS Report is selected.

  7. Choose the Parameter you wish to edit.

    Once the parameter is chosen, the Parameter Properties section is populated with information about the selected parameter.

  8. In the Parameters Properties section, click the Value button.

    Note: For the Value button to be able to be selected, the chosen parameter must be a multiselect parameter.

    The Parameter Value for Amper Variable dialog box opens.

  9. Choose the values that you want the schedule to burst. While holding the Ctrl key, use your mouse to select more than one value. To choose all values, select the All Values check box.
  10. Select the Repeat Task for Each Selected Value check box.
  11. Optionally, select the Run Pre/Post-RPC Every Time check box. For more information, see Running Pre and Post-Processing Procedures for Each Parameter Value.
  12. Click OK.

    The selected parameter values now appear in square brackets in the Task Parameters dialog box in the Value column, as shown in the following image.

    An image showing the Task Parameters dialog box. The Country parameter is selected.
  13. Click OK.
  14. Input all other necessary options and settings for your schedule, then save the schedule. For more information, see Creating a Schedule in the Basic Scheduling Tool.
  15. Run the schedule.

    When the schedule is run, it distributes a report for every burst parameter that you selected, as shown in the following image.

    An image showing the burst results of a schedule that utilizes the Country parameter.

Bursting an Active Dashboard or Excel Compound Report That Contains Filtered and Unfiltered Reports

When you create an active dashboard or Excel compound report that contains filtered and unfiltered reports, only the filtered reports can be configured for bursting.

The following image shows two reports created in InfoAssist on one dashboard. The report showing MODEL, CAR, COUNTRY, and DEALER COST data has a COUNTRY filter applied, which allows the user to filter report results by country. The report showing MODEL and RETAIL_COST data does not have a filter.

An image that shows two reports created in InfoAssist+ on one dashboard. The report showing MODEL, CAR, COUNTRY, and DEALER COST data has a COUNTRY filter. The report showing MODEL and RETAIL_COST data does not have a filter.

When you access Task Parameters for this compound report through the scheduling tool, any edits you make to the parameter will only apply to the filtered report. Meaning, you will only be able to assign values to a parameter in the filtered report. An example of this is shown in the following image, where you can see the values that were assigned to the COUNTRY parameter.

An image showing the Task Parameters dialog box. The COUNTRY filter is selected.

When you schedule a compound report to be burst, and the Repeat Task for Each Selected Value check box is selected, the reports that contain filters will burst based on the parameter values selected. In the following image, the compound report is distributed into three separate burst reports, which show filtered data about W GERMANY, FRANCE, and JAPAN, respectively.

An image showing the burst results of a schedule that utilizes the Country parameter.

For each burst report, the first chart shows data for the selected COUNTRY value.

The following image shows the W GERMANY burst compound report.

An image showing the West Germany burst compound report.

Because no filters have been applied to the second report, the results of the second report are the same for each burst compound report. Only the report that uses the COUNTRY filter changes.

Bursting an Active Dashboard or Excel Compound Report That Contains Only Filtered Reports

If you attempt to burst an active dashboard or Excel compound report that contains only filtered reports, all reports will be compatible with bursting.

The following images show two reports created in InfoAssist on one dashboard. Both reports use the same filter for the MODEL data.

An image showing two reports created in InfoAssist+ on one dashboard. The MODEL filter is applied for both reports.
An image showing two reports created in InfoAssist+ on one dashboard. The MODEL filter is applied for both reports.

When Task Parameters are accessed through the scheduling tool for this compound report, you can specify the MODEL values for both reports.

As shown in the following image, the MODEL parameter has the filter values 3.0 SI 4 DOOR, 100 LS 2 DOOR AUTO, XJ12L AUTO, B210 2 DOOR AUTO, and 2000 SPIDER VELOCE selected.

An image showing the Parameter Value for Amper Variable dialog box. Five values from the MODEL parameter are selected.

The selected values appear in brackets in the Task Parameters dialog box, as shown in the following image.

An image showing the Task Parameters dialog box. The MODEL parameter has been selected.

When you schedule a compound report to be burst, and the Repeat Task for Each Selected Value check box is selected, burst reports are created based on the parameter values selected. In the following image, the compound report is distributed and burst into five separate compound reports, which show filtered data about each selected car model.

An image showing the burst results of a schedule that utilizes the MODEL parameter.

For each burst compound report, both reports show data for the selected car model. In the following image, the burst compound report showing information about the 3.0 SI 4 DOOR car model is selected. Both reports in the burst compound report only show information about the selected model.

An image showing the burst compound report for the 3.0 SI 4 DOOR car model.

Deleting a Parameter

It is important to verify that the parameters you delete when scheduling a report procedure (FEX) will be handled, as follows, so that the scheduled job will run successfully:

  • A default value is specified in the report procedure (FEX) being scheduled.
  • A value will be dynamically assigned to the parameter by the report procedure (FEX) processing when the scheduled job runs on the Reporting Server.
  • The parameter will not be referenced when the report procedure (FEX) is processed by the Reporting Server.

To delete a parameter so that it is not stored with the schedule information, highlight the parameter in the parameter table you want to delete, and click the Delete button.

Creating a New Parameter

How to:

If you need to have the schedule job send a parameter and value that is not defined in the report procedure being scheduled, you can create a new parameter in the Task Parameters dialog box. Parameters referenced during processing by the Reporting Server must be assigned a value for the scheduled job to run successfully. The schedule job log report will contain information when required parameter values were not provided.

Procedure: How to Create a New Parameter

You can create parameters for a task as follows:

  1. Click Parameters on the ribbon to display the Task Parameters dialog box, which is shown in the following image.
    new parameter
  2. Click the New button located above the Parameter Properties section.

    The Task Parameter dialog box displays, as shown in the following image.

  3. Enter a value in the Name and Value boxes.
  4. Click OK.

    The Name and Value boxes are populated in the Task Parameters dialog box Parameters table.

  5. If you would like to change the parameter value, select the parameter in the Parameters table and specify the values in the Value field located in the Parameter Properties section.
  6. Click OK when you have completed entering parameter settings for the task.

Selecting a Report Format

Use the following guidelines when selecting a format:

  • The formats that support bursting are AHTML (except for FML reports), ALPHA, COM, COMMA, COMT, DHTML (except for FML reports), DFIX, DOC, EXL07, EXL2K, EXL2K FORMULA, EXL2K TEMPLATE, EXL97, GIF, HTML and HTML ODP (except for FML reports), JPEG, PDF, PNG, PPT, PS, SVG, TAB, TABT, and WP. Coordinated compound reports can only be burst with DHTML, PDF, and PPT formats.
  • When a format is selected, ReportCaster automatically adds an appropriate file extension to the output file name in the Save As field. In certain cases, you must manually change the extension added by ReportCaster. For example, if you select format DHTML in the schedule and the report output is not a web archive file, you must change the extension to .htm. If you select format HTML in the schedule and the report output is a web archive file, you must change the extension to .mht. If you select format EXL07 TEMPLATE in the schedule and the specified template is a macro-enabled template, you must change the extension to .xlsm. For more information about DHTML and EXL07 TEMPLATE formats, see ReportCasterReport Broker Formats for Scheduled Output.
  • The WP, DOC, and PS formats support printing. The PDF format supports printing when ReportCaster is configured to enable PDF to print and the printer is configured with the appropriate driver. For more information, see ReportCaster Configuration.
  • When a format is selected using the Override the Format Specified in the Procedure option, only the DHTML, DOC, GIF, HTML, JPEG, PNG, SVG, and WP formats can be distributed as an inline email message. When the Override the Format Specified in the Procedure option is not used and inline is selected, the output will be distributed as an attachment if the format does not support inline distribution. Additionally, when distributing a report inline, the appearance of the report can be affected by the email server, or potentially blocked. Review the restrictions for your mail server provider before utilizing reporting formats and options that utilize JavaScript™, embedded images, and referenced CSS.

Schedule Pre-Processing and Post-Processing Procedures

How to:

If you are scheduling a Server Procedure or report procedure (FEX), you can schedule a maximum of two pre-processing and post-processing procedures. The pre-processing and post-processing procedures that you schedule must reside on the Reporting Server.

Note: All ReportCaster internal variables, which start with &DST, are passed to pre-processing and post-processing procedures so that they are available for application specific logic. For more information, see ReportCaster Internal Variables.

Procedure: How to Use the Pre/Post-Procedures Tab

  1. Click the Pre/Post-Procedures tab.
  2. Click the First... or Second... button to open a dialog box, from which you can select a procedure.
  3. Once a procedure is selected you can click the Pre First, Pre Second, Post First, or Post Second buttons to insert the path of the procedure into the respective field.
  4. Click OK to confirm your selections.
  5. Optionally, enter the following information:

    The procedure (FEX) name can be entered with or without the application path. When an application path is not specified, the Reporting Server default search path is used to locate the specified procedure.

    One or more parameter values can be assigned using a name and value pair, and multiple pairs must be separated by commas, as follows: 

    procedurename name=value, name=value

    You do not have to enter the pairs in the order in which they are encountered in the procedure. For additional information on supplying parameter values for a procedure, see the Supplying Variable Values From Another Procedure topic in the Developing Reporting Applications manual.

  6. Click OK.

Advanced Task Settings

The Advanced Options tab provides access to the Additional FOC Errors to be Processed as Warnings dialog box, where you can specify one or more FOCUS error message numbers, separated by a comma. If one of these FOCUS error numbers is encountered during schedule execution, ReportCaster will process it as a warning rather than an error. For example, if a FOC1517 error is generated by the procedure, add 1517 to the text box to convert this error to a warning. This means that if a report is produced, it will be distributed in spite of the FOCUS error number. It also means that this FOCUS error number will not trigger error notification if the schedule is configured to notify on error.

The Advanced Task Settings dialog box is shown in the following image.

WebFOCUS

Feedback