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:
- 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.
- Starting with the IDOs form, create a new IDO to extend and replace the Parms IDO.
- Create a new property for the IDO you just created. This property must be bound to the "par.company" column you created earlier.
- 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).
- After saving the System Parameters form and exiting Design Mode, enter a value into the new field and save it.
- 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.
- Use the Sql Columns
form to add a column to the "parms" table.
- 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.