======7.2. Advanced printing configurations for Produmex Scan======
With the advanced printing configurations printing issues caused by incorrect server/database connection settings in Crystal Reports can be solved. 

To add the advanced printing configurations, run the following query on the database: \\
**SQL**
<code sql>INSERT INTO "VALI002"."@BXPCONFIG" ("Code", "Name", "U_BXPDescr", "U_BXPValue", "U_BXPVType", "U_BXPRowVr") 
VALUES('BXMPRAO', 'BXMPRAO', 'Crystal Reports connection parameters', '54', 1, NULL)
</code>

A new record will be inserted to the BXPCONFIG table.  With this record the following parameters can be set: 
  * PRINTERADVANCEDOPTIONS_SETTABLELOGON = 1;
  * <color orange>PRINTERADVANCEDOPTIONS_SETTABLECONNECTION = 2</color>;
  * <color orange>PRINTERADVANCEDOPTIONS_SETSUBREPORTS = 4</color>;
  * PRINTERADVANCEDOPTIONS_DISSOCIATESIZE = 8;
  * <color orange>PRINTERADVANCEDOPTIONS_USEPRINTERSETTINGS = 16</color>;
  * <color orange>PRINTERADVANCEDOPTIONS_USECONNECTIONCLONE = 32</color>;
  * PRINTERADVANCEDOPTIONS_USESETTINGWITHNAME = 64;
The value of **BXMPRAO** is the sum of the value of the enabled parameters. 

The default and recommended value is 54. It means that the Settable connection (2), the Set sub reports (4), the Use printer settings (16) and the Use connection clone (32) parameters are enabled (2+4+16+32=54) by default.

<WRAP important round>**Do not change the default value. If the issue persists, please contact Produmex support.**</WRAP>

**Enabled settings:** \\
  * //Settable connection// (2): Creates a new connection structure with the actual parameters. 
  * //Set sub reports// (4): Applies the (1) and (2) setting to the sub reports as well.
  * //Use printer settings// (16): Uses a non-standard access to printer settings. 
  * //Use connection clone// (32): Uses a clone of the connection structure. 

**Other settings that can be enabled:** \\
  * //Settable log on// (1): Resets the server/database connection to the actual in the tables of the existing structure. This setting is not taken into account if the Settable connection (2) setting is also enabled.
  * //Dissociate size// (8): Enables the ‘Dissociate Formatting Page Size and Printer Paper Size’ option. 
  * //Use setting with name// (64): Uses both the standard and non-standard access to the printer settings. 

**Known cases:** \\
* The error message 'Not supported within subreports'

Set the value to 1