Troubleshooting: Report outputs do not pick up header/footer variable values

Symptoms

The report output for predefined DataView reports or reports based on a supplied SSRS template do not display the values of one or more global variables in the header or footer. Instead, they display the name of the variable (for example, BG_COMPANYNAME) or the space is blank.

Possible solutions

The system looks for the value to replace this variable from a field on the System Parameters form. If this field is null or missing, there is no value to pick up.

• If your application has a System Parameters form, check and verify that there is a Company or Company Name field and that it has a value specified. If the field is there, but there is no value, specify a value for the field. If the field is missing, perform these procedures:
  1. Use the Sql Columns form to add a column to the "parms" table.

     This column must be named company, set to the nvarchar data type, be 40 characters in length, and be nullable.

  2. Starting with the IDOs form, create a new IDO to extend and replace the Parms IDO.
  3. Create a new property for the IDO you just created. This property must be bound to the "par.company" column you created earlier.
  4. Modify the System Parameters form by adding an Edit field component bound to the "company" property.

     Make sure you also add a field label (Static component).

  5. After saving the System Parameters form and exiting Design Mode, enter a value into the new field and save it.
  6. Make sure your system is set to unload IDO metadata with global objects. Then clear the metadata cache (Ctrl+U) and restart the report form.
• If your application has a General Parameters form, check and verify that there is a value specified in the Company field on the Address tab.