KB485537: Dossier PDF output slight visual difference in M2021 update 5

Product Owner, Principal • MicroStrategy

Starting with the release of Strategy ONE (March 2024), dossiers are also known as dashboards.

Symptom

After upgrading Strategy products to the versions Strategy 2021 Update 5, we see some visual differences in exported PDF files.

If the problem persists, log a support ticket regarding this logical defect to Strategy Support team and attach the DSSErrors.log file.
OperationNew Instance CreatedExecute dossierYesSwitch bookmarkYesReset dossierYesRepromptingYesRefresh (with Web Preference > Project Defaults > History List > Duplicate Message on Repromt or Refresh setting on)YesRefresh (with Web Preference > Project Defaults > History List > Duplicate Message on Repromt or Refresh setting off)NoExporting a dossierNoUndo or redoNoSortingNoDrillingNoSwitching pagesNoSwitching chaptersNoChanging FiltersNoAdding a datasetNoEditing a datasetNoDeleting a datasetNoDatabaseQuoting Character for Namespaces, Tables, Column IdentifiersRelevant Formats if Using Default Mapping Type as VarCharTeradata" (quote)Date

"yyyy-mm-dd"

Oracle Database" (quote)Date

"dd-mm-yyyy"

Time

"yyyy-mm-dd hh:nn:ss"

Microsoft SQL Server[ ] (square bracket)
Note: if the identifier uses character

, you can escape by using

]]

in your SQL statement.Date

"yyyy-mm-dd"

Time

"hh:nn:ss.0000000"

TimeStamp

"yyyy-mm-dd hh:nn:ss.0000000"

Amazon Redshift" (quote)Date

“yyyy-mm-dd"

IBM DB2" (quote) PosgreSQL" (quote)Date

"yyyy-mm-dd"

Azure Synapse Analytics[ ] (square bracket)Date

"yyyy-mm-dd"

Exasol" (quote)Date

"yyyy-mm-dd"

Oracle MySQL` (backtick)Date

"yyyy-mm-dd"

SAP HANA" (quote)Date

"yyyy-mm-dd"

Time

"yyyy-mm-dd hh:nn:ss"

Google BigQuery` (backtick)Date

"yyyy-mm-dd"

Snowflake" (quote) Use AppLocker to create a Windows 10 kiosk that runs multiple apps (Windows 10) | Microsoft Docs
Use AppLocker to create a Windows 10 kiosk that runs multiple apps. 07/30/2018; 4 minutes to read; Contributors. In this article. Applies to. Windows 10; Learn how to configure a device running Windows 10 Enterprise or Windows 10 Education, version 1703 and earlier, so that users can only run a few specific apps.

Source: docs.microsoft.comStrategy 2021 Update 4Strategy 2021 Update 5Google Chrome 90Google Chrome 98Strategy Export ServicepuppeteerChromium

11.1.x

11.2.0

11.2.4

11.3.0

11.3.1

1.0.0

65.0.3312

11.2.5

11.2.x

11.3.2

11.3.4

7.1.0

90.0.4403

11.3.5

11.3.x

13.1.2

98.0.4758

"yyyy-mm-dd"

Oracle Database" (quote)Date

"dd-mm-yyyy"

Time

"yyyy-mm-dd hh:nn:ss"

Microsoft SQL Server[ ] (square bracket)
Note: if the identifier uses character

, you can escape by using

]]

in your SQL statement.Date

"yyyy-mm-dd"

Time

"hh:nn:ss.0000000"

TimeStamp

"yyyy-mm-dd hh:nn:ss.0000000"

Amazon Redshift" (quote)Date

“yyyy-mm-dd"

IBM DB2" (quote) PosgreSQL" (quote)Date

"yyyy-mm-dd"

Azure Synapse Analytics[ ] (square bracket)Date

"yyyy-mm-dd"

Exasol" (quote)Date

"yyyy-mm-dd"

Oracle MySQL` (backtick)Date

"yyyy-mm-dd"

SAP HANA" (quote)Date

"yyyy-mm-dd"

Time

"yyyy-mm-dd hh:nn:ss"

Google BigQuery` (backtick)Date

"yyyy-mm-dd"

11.1.x

11.2.0

11.2.4

11.3.0

11.3.1

1.0.0

65.0.3312

11.2.5

11.2.x

11.3.2

11.3.4

7.1.0

90.0.4403

11.3.5

11.3.x

13.1.2

98.0.4758

"yyyy-mm-dd"

Oracle Database" (quote)Date

"dd-mm-yyyy"

Time

"yyyy-mm-dd hh:nn:ss"

Microsoft SQL Server[ ] (square bracket)
Note: if the identifier uses character

, you can escape by using

]]

in your SQL statement.Date

"yyyy-mm-dd"

Time

"hh:nn:ss.0000000"

TimeStamp

"yyyy-mm-dd hh:nn:ss.0000000"

Amazon Redshift" (quote)Date

“yyyy-mm-dd"

IBM DB2" (quote) PosgreSQL" (quote)Date

"yyyy-mm-dd"

Azure Synapse Analytics[ ] (square bracket)Date

"yyyy-mm-dd"

Exasol" (quote)Date

"yyyy-mm-dd"

Oracle MySQL` (backtick)Date

"yyyy-mm-dd"

SAP HANA" (quote)Date

"yyyy-mm-dd"

Time

"yyyy-mm-dd hh:nn:ss"

Google BigQuery` (backtick)Date

"yyyy-mm-dd"

11.1.x

11.2.0

11.2.4

11.3.0

11.3.1

1.0.0

65.0.3312

11.2.5

11.2.x

11.3.2

11.3.4

7.1.0

90.0.4403

11.3.5

11.3.x

13.1.2

98.0.4758

"yyyy-mm-dd"

Oracle Database" (quote)Date

"dd-mm-yyyy"

Time

"yyyy-mm-dd hh:nn:ss"

Microsoft SQL Server[ ] (square bracket)
Note: if the identifier uses character

, you can escape by using

]]

in your SQL statement.Date

"yyyy-mm-dd"

Time

"hh:nn:ss.0000000"

TimeStamp

"yyyy-mm-dd hh:nn:ss.0000000"

Amazon Redshift" (quote)Date

“yyyy-mm-dd"

IBM DB2" (quote) PosgreSQL" (quote)Date

"yyyy-mm-dd"

Azure Synapse Analytics[ ] (square bracket)Date

"yyyy-mm-dd"

Exasol" (quote)Date

"yyyy-mm-dd"

Oracle MySQL` (backtick)Date

"yyyy-mm-dd"

SAP HANA" (quote)Date

"yyyy-mm-dd"

Time

"yyyy-mm-dd hh:nn:ss"

Google BigQuery` (backtick)Date

"yyyy-mm-dd"

11.1.x

11.2.0

11.2.4

11.3.0

11.3.1

1.0.0

65.0.3312

11.2.5

11.2.x

11.3.2

11.3.4

7.1.0

90.0.4403

11.3.5

11.3.x

13.1.2

98.0.4758

Visual Differences

Root Cause

The visual changes were caused by Google Chrome.
This is not specific to exporting. See the 2 screenshots from the same dossier in different versions of Google Chrome.

"yyyy-mm-dd"

Oracle Database" (quote)Date

"dd-mm-yyyy"

Time

"yyyy-mm-dd hh:nn:ss"

Microsoft SQL Server[ ] (square bracket)
Note: if the identifier uses character

, you can escape by using

]]

in your SQL statement.Date

"yyyy-mm-dd"

Time

"hh:nn:ss.0000000"

TimeStamp

"yyyy-mm-dd hh:nn:ss.0000000"

Amazon Redshift" (quote)Date

“yyyy-mm-dd"

IBM DB2" (quote) PosgreSQL" (quote)Date

"yyyy-mm-dd"

Azure Synapse Analytics[ ] (square bracket)Date

"yyyy-mm-dd"

Exasol" (quote)Date

"yyyy-mm-dd"

Oracle MySQL` (backtick)Date

"yyyy-mm-dd"

SAP HANA" (quote)Date

"yyyy-mm-dd"

Time

"yyyy-mm-dd hh:nn:ss"

Google BigQuery` (backtick)Date

"yyyy-mm-dd"

11.1.x

11.2.0

11.2.4

11.3.0

11.3.1

1.0.0

65.0.3312

11.2.5

11.2.x

11.3.2

11.3.4

7.1.0

90.0.4403

11.3.5

11.3.x

13.1.2

98.0.4758

"yyyy-mm-dd"

Oracle Database" (quote)Date

"dd-mm-yyyy"

Time

"yyyy-mm-dd hh:nn:ss"

Microsoft SQL Server[ ] (square bracket)
Note: if the identifier uses character

, you can escape by using

]]

in your SQL statement.Date

"yyyy-mm-dd"

Time

"hh:nn:ss.0000000"

TimeStamp

"yyyy-mm-dd hh:nn:ss.0000000"

Amazon Redshift" (quote)Date

“yyyy-mm-dd"

IBM DB2" (quote) PosgreSQL" (quote)Date

"yyyy-mm-dd"

Azure Synapse Analytics[ ] (square bracket)Date

"yyyy-mm-dd"

Exasol" (quote)Date

"yyyy-mm-dd"

Oracle MySQL` (backtick)Date

"yyyy-mm-dd"

SAP HANA" (quote)Date

"yyyy-mm-dd"

Time

"yyyy-mm-dd hh:nn:ss"

Google BigQuery` (backtick)Date

"yyyy-mm-dd"

11.1.x

11.2.0

11.2.4

11.3.0

11.3.1

1.0.0

65.0.3312

11.2.5

11.2.x

11.3.2

11.3.4

7.1.0

90.0.4403

11.3.5

11.3.x

13.1.2

98.0.4758

"yyyy-mm-dd"

Oracle Database" (quote)Date

"dd-mm-yyyy"

Time

"yyyy-mm-dd hh:nn:ss"

Microsoft SQL Server[ ] (square bracket)
Note: if the identifier uses character

, you can escape by using

]]

in your SQL statement.Date

"yyyy-mm-dd"

Time

"hh:nn:ss.0000000"

TimeStamp

"yyyy-mm-dd hh:nn:ss.0000000"

Amazon Redshift" (quote)Date

“yyyy-mm-dd"

IBM DB2" (quote) PosgreSQL" (quote)Date

"yyyy-mm-dd"

Azure Synapse Analytics[ ] (square bracket)Date

"yyyy-mm-dd"

Exasol" (quote)Date

"yyyy-mm-dd"

Oracle MySQL` (backtick)Date

"yyyy-mm-dd"

SAP HANA" (quote)Date

"yyyy-mm-dd"

Time

"yyyy-mm-dd hh:nn:ss"

Google BigQuery` (backtick)Date

"yyyy-mm-dd"

11.1.x

11.2.0

11.2.4

11.3.0

11.3.1

1.0.0

65.0.3312

11.2.5

11.2.x

11.3.2

11.3.4

7.1.0

90.0.4403

11.3.5

11.3.x

13.1.2

98.0.4758

"yyyy-mm-dd"

Oracle Database" (quote)Date

"dd-mm-yyyy"

Time

"yyyy-mm-dd hh:nn:ss"

Microsoft SQL Server[ ] (square bracket)
Note: if the identifier uses character

, you can escape by using

]]

in your SQL statement.Date

"yyyy-mm-dd"

Time

"hh:nn:ss.0000000"

TimeStamp

"yyyy-mm-dd hh:nn:ss.0000000"

Amazon Redshift" (quote)Date

“yyyy-mm-dd"

IBM DB2" (quote) PosgreSQL" (quote)Date

"yyyy-mm-dd"

Azure Synapse Analytics[ ] (square bracket)Date

"yyyy-mm-dd"

Exasol" (quote)Date

"yyyy-mm-dd"

Oracle MySQL` (backtick)Date

"yyyy-mm-dd"

SAP HANA" (quote)Date

"yyyy-mm-dd"

Time

"yyyy-mm-dd hh:nn:ss"

Google BigQuery` (backtick)Date

"yyyy-mm-dd"

11.1.x

11.2.0

11.2.4

11.3.0

11.3.1

1.0.0

65.0.3312

11.2.5

11.2.x

11.3.2

11.3.4

7.1.0

90.0.4403

11.3.5

11.3.x

13.1.2

98.0.4758

We can see visual differences between Chrome 90.0.4403.0 and Chrome 98.0.4758.0.

Why would Google Chrome have impact on PDF files?

To keep What-You-See-Is-What-You-Get, we expect an exported PDF should look the same as the original dossier in a browser. So the back-end Export Service runs its own bundled version of

Chromium

(

puppeteer

, a software developed by Google Chrome team) to render and export dossiers to PDF.
It makes puppeteer a key 3rd-party component in Export Service. With a built-in Google Chrome, Export Service can render dossier contents like Strategy Web, Library and Workstation. To eliminate security risks, it is necessary to upgrade puppeteer (as well as its built-in Chrome) regularly in release cycles.

"yyyy-mm-dd"

Oracle Database" (quote)Date

"dd-mm-yyyy"

Time

"yyyy-mm-dd hh:nn:ss"

Microsoft SQL Server[ ] (square bracket)
Note: if the identifier uses character

, you can escape by using

]]

in your SQL statement.Date

"yyyy-mm-dd"

Time

"hh:nn:ss.0000000"

TimeStamp

"yyyy-mm-dd hh:nn:ss.0000000"

Amazon Redshift" (quote)Date

“yyyy-mm-dd"

IBM DB2" (quote) PosgreSQL" (quote)Date

"yyyy-mm-dd"

Azure Synapse Analytics[ ] (square bracket)Date

"yyyy-mm-dd"

Exasol" (quote)Date

"yyyy-mm-dd"

Oracle MySQL` (backtick)Date

"yyyy-mm-dd"

SAP HANA" (quote)Date

"yyyy-mm-dd"

Time

"yyyy-mm-dd hh:nn:ss"

Google BigQuery` (backtick)Date

"yyyy-mm-dd"

11.1.x

11.2.0

11.2.4

11.3.0

11.3.1

1.0.0

65.0.3312

11.2.5

11.2.x

11.3.2

11.3.4

7.1.0

90.0.4403

11.3.5

11.3.x

13.1.2

98.0.4758

"yyyy-mm-dd"

Oracle Database" (quote)Date

"dd-mm-yyyy"

Time

"yyyy-mm-dd hh:nn:ss"

Microsoft SQL Server[ ] (square bracket)
Note: if the identifier uses character

, you can escape by using

]]

in your SQL statement.Date

"yyyy-mm-dd"

Time

"hh:nn:ss.0000000"

TimeStamp

"yyyy-mm-dd hh:nn:ss.0000000"

Amazon Redshift" (quote)Date

“yyyy-mm-dd"

IBM DB2" (quote) PosgreSQL" (quote)Date

"yyyy-mm-dd"

Azure Synapse Analytics[ ] (square bracket)Date

"yyyy-mm-dd"

Exasol" (quote)Date

"yyyy-mm-dd"

Oracle MySQL` (backtick)Date

"yyyy-mm-dd"

SAP HANA" (quote)Date

"yyyy-mm-dd"

Time

"yyyy-mm-dd hh:nn:ss"

Google BigQuery` (backtick)Date

"yyyy-mm-dd"

11.1.x

11.2.0

11.2.4

11.3.0

11.3.1

1.0.0

65.0.3312

11.2.5

11.2.x

11.3.2

11.3.4

7.1.0

90.0.4403

11.3.5

11.3.x

13.1.2

98.0.4758

"yyyy-mm-dd"

Oracle Database" (quote)Date

"dd-mm-yyyy"

Time

"yyyy-mm-dd hh:nn:ss"

Microsoft SQL Server[ ] (square bracket)
Note: if the identifier uses character

, you can escape by using

]]

in your SQL statement.Date

"yyyy-mm-dd"

Time

"hh:nn:ss.0000000"

TimeStamp

"yyyy-mm-dd hh:nn:ss.0000000"

Amazon Redshift" (quote)Date

“yyyy-mm-dd"

IBM DB2" (quote) PosgreSQL" (quote)Date

"yyyy-mm-dd"

Azure Synapse Analytics[ ] (square bracket)Date

"yyyy-mm-dd"

Exasol" (quote)Date

"yyyy-mm-dd"

Oracle MySQL` (backtick)Date

"yyyy-mm-dd"

SAP HANA" (quote)Date

"yyyy-mm-dd"

Time

"yyyy-mm-dd hh:nn:ss"

Google BigQuery` (backtick)Date

"yyyy-mm-dd"

11.1.x

11.2.0

11.2.4

11.3.0

11.3.1

1.0.0

65.0.3312

11.2.5

11.2.x

11.3.2

11.3.4

7.1.0

90.0.4403

11.3.5

11.3.x

13.1.2

98.0.4758

"yyyy-mm-dd"

Oracle Database" (quote)Date

"dd-mm-yyyy"

Time

"yyyy-mm-dd hh:nn:ss"

Microsoft SQL Server[ ] (square bracket)
Note: if the identifier uses character

, you can escape by using

]]

in your SQL statement.Date

"yyyy-mm-dd"

Time

"hh:nn:ss.0000000"

TimeStamp

"yyyy-mm-dd hh:nn:ss.0000000"

Amazon Redshift" (quote)Date

“yyyy-mm-dd"

IBM DB2" (quote) PosgreSQL" (quote)Date

"yyyy-mm-dd"

Azure Synapse Analytics[ ] (square bracket)Date

"yyyy-mm-dd"

Exasol" (quote)Date

"yyyy-mm-dd"

Oracle MySQL` (backtick)Date

"yyyy-mm-dd"

SAP HANA" (quote)Date

"yyyy-mm-dd"

Time

"yyyy-mm-dd hh:nn:ss"

Google BigQuery` (backtick)Date

"yyyy-mm-dd"

11.1.x

11.2.0

11.2.4

11.3.0

11.3.1

1.0.0

65.0.3312

11.2.5

11.2.x

11.3.2

11.3.4

7.1.0

90.0.4403

11.3.5

11.3.x

13.1.2

98.0.4758

"yyyy-mm-dd"

Oracle Database" (quote)Date

"dd-mm-yyyy"

Time

"yyyy-mm-dd hh:nn:ss"

Microsoft SQL Server[ ] (square bracket)
Note: if the identifier uses character

, you can escape by using

]]

in your SQL statement.Date

"yyyy-mm-dd"

Time

"hh:nn:ss.0000000"

TimeStamp

"yyyy-mm-dd hh:nn:ss.0000000"

Amazon Redshift" (quote)Date

“yyyy-mm-dd"

IBM DB2" (quote) PosgreSQL" (quote)Date

"yyyy-mm-dd"

Azure Synapse Analytics[ ] (square bracket)Date

"yyyy-mm-dd"

Exasol" (quote)Date

"yyyy-mm-dd"

Oracle MySQL` (backtick)Date

"yyyy-mm-dd"

SAP HANA" (quote)Date

"yyyy-mm-dd"

Time

"yyyy-mm-dd hh:nn:ss"

Google BigQuery` (backtick)Date

"yyyy-mm-dd"

11.1.x

11.2.0

11.2.4

11.3.0

11.3.1

1.0.0

65.0.3312

11.2.5

11.2.x

11.3.2

11.3.4

7.1.0

90.0.4403

11.3.5

11.3.x

13.1.2

98.0.4758

"yyyy-mm-dd"

Oracle Database" (quote)Date

"dd-mm-yyyy"

Time

"yyyy-mm-dd hh:nn:ss"

Microsoft SQL Server[ ] (square bracket)
Note: if the identifier uses character

, you can escape by using

]]

in your SQL statement.Date

"yyyy-mm-dd"

Time

"hh:nn:ss.0000000"

TimeStamp

"yyyy-mm-dd hh:nn:ss.0000000"

Amazon Redshift" (quote)Date

“yyyy-mm-dd"

IBM DB2" (quote) PosgreSQL" (quote)Date

"yyyy-mm-dd"

Azure Synapse Analytics[ ] (square bracket)Date

"yyyy-mm-dd"

Exasol" (quote)Date

"yyyy-mm-dd"

Oracle MySQL` (backtick)Date

"yyyy-mm-dd"

SAP HANA" (quote)Date

"yyyy-mm-dd"

Time

"yyyy-mm-dd hh:nn:ss"

Google BigQuery` (backtick)Date

"yyyy-mm-dd"

11.1.x

11.2.0

11.2.4

11.3.0

11.3.1

1.0.0

65.0.3312

11.2.5

11.2.x

11.3.2

11.3.4

7.1.0

90.0.4403

11.3.5

11.3.x

13.1.2

98.0.4758

"yyyy-mm-dd"

Oracle Database" (quote)Date

"dd-mm-yyyy"

Time

"yyyy-mm-dd hh:nn:ss"

Microsoft SQL Server[ ] (square bracket)
Note: if the identifier uses character

, you can escape by using

]]

in your SQL statement.Date

"yyyy-mm-dd"

Time

"hh:nn:ss.0000000"

TimeStamp

"yyyy-mm-dd hh:nn:ss.0000000"

Amazon Redshift" (quote)Date

“yyyy-mm-dd"

IBM DB2" (quote) PosgreSQL" (quote)Date

"yyyy-mm-dd"

Azure Synapse Analytics[ ] (square bracket)Date

"yyyy-mm-dd"

Exasol" (quote)Date

"yyyy-mm-dd"

Oracle MySQL` (backtick)Date

"yyyy-mm-dd"

SAP HANA" (quote)Date

"yyyy-mm-dd"

Time

"yyyy-mm-dd hh:nn:ss"

Google BigQuery` (backtick)Date

"yyyy-mm-dd"

11.1.x

11.2.0

11.2.4

11.3.0

11.3.1

1.0.0

65.0.3312

11.2.5

11.2.x

11.3.2

11.3.4

7.1.0

90.0.4403

11.3.5

11.3.x

13.1.2

98.0.4758

"yyyy-mm-dd"

Oracle Database" (quote)Date

"dd-mm-yyyy"

Time

"yyyy-mm-dd hh:nn:ss"

Microsoft SQL Server[ ] (square bracket)
Note: if the identifier uses character

, you can escape by using

]]

in your SQL statement.Date

"yyyy-mm-dd"

Time

"hh:nn:ss.0000000"

TimeStamp

"yyyy-mm-dd hh:nn:ss.0000000"

Amazon Redshift" (quote)Date

“yyyy-mm-dd"

IBM DB2" (quote) PosgreSQL" (quote)Date

"yyyy-mm-dd"

Azure Synapse Analytics[ ] (square bracket)Date

"yyyy-mm-dd"

Exasol" (quote)Date

"yyyy-mm-dd"

Oracle MySQL` (backtick)Date

"yyyy-mm-dd"

SAP HANA" (quote)Date

"yyyy-mm-dd"

Time

"yyyy-mm-dd hh:nn:ss"

Google BigQuery` (backtick)Date

"yyyy-mm-dd"

11.1.x

11.2.0

11.2.4

11.3.0

11.3.1

1.0.0

65.0.3312

11.2.5

11.2.x

11.3.2

11.3.4

7.1.0

90.0.4403

11.3.5

11.3.x

13.1.2

98.0.4758

"yyyy-mm-dd"

Oracle Database" (quote)Date

"dd-mm-yyyy"

Time

"yyyy-mm-dd hh:nn:ss"

Microsoft SQL Server[ ] (square bracket)
Note: if the identifier uses character

, you can escape by using

]]

in your SQL statement.Date

"yyyy-mm-dd"

Time

"hh:nn:ss.0000000"

TimeStamp

"yyyy-mm-dd hh:nn:ss.0000000"

Amazon Redshift" (quote)Date

“yyyy-mm-dd"

IBM DB2" (quote) PosgreSQL" (quote)Date

"yyyy-mm-dd"

Azure Synapse Analytics[ ] (square bracket)Date

"yyyy-mm-dd"

Exasol" (quote)Date

"yyyy-mm-dd"

Oracle MySQL` (backtick)Date

"yyyy-mm-dd"

SAP HANA" (quote)Date

"yyyy-mm-dd"

Time

"yyyy-mm-dd hh:nn:ss"

Google BigQuery` (backtick)Date

"yyyy-mm-dd"

11.1.x

11.2.0

11.2.4

11.3.0

11.3.1

1.0.0

65.0.3312

11.2.5

11.2.x

11.3.2

11.3.4

7.1.0

90.0.4403

11.3.5

11.3.x

13.1.2

98.0.4758

"yyyy-mm-dd"

Oracle Database" (quote)Date

"dd-mm-yyyy"

Time

"yyyy-mm-dd hh:nn:ss"

Microsoft SQL Server[ ] (square bracket)
Note: if the identifier uses character

, you can escape by using

]]

in your SQL statement.Date

"yyyy-mm-dd"

Time

"hh:nn:ss.0000000"

TimeStamp

"yyyy-mm-dd hh:nn:ss.0000000"

Amazon Redshift" (quote)Date

“yyyy-mm-dd"

IBM DB2" (quote) PosgreSQL" (quote)Date

"yyyy-mm-dd"

Azure Synapse Analytics[ ] (square bracket)Date

"yyyy-mm-dd"

Exasol" (quote)Date

"yyyy-mm-dd"

Oracle MySQL` (backtick)Date

"yyyy-mm-dd"

SAP HANA" (quote)Date

"yyyy-mm-dd"

Time

"yyyy-mm-dd hh:nn:ss"

Google BigQuery` (backtick)Date

"yyyy-mm-dd"

11.1.x

11.2.0

11.2.4

11.3.0

11.3.1

1.0.0

65.0.3312

11.2.5

11.2.x

11.3.2

11.3.4

7.1.0

90.0.4403

11.3.5

11.3.x

13.1.2

98.0.4758

"yyyy-mm-dd"

Oracle Database" (quote)Date

"dd-mm-yyyy"

Time

"yyyy-mm-dd hh:nn:ss"

Microsoft SQL Server[ ] (square bracket)
Note: if the identifier uses character

, you can escape by using

]]

in your SQL statement.Date

"yyyy-mm-dd"

Time

"hh:nn:ss.0000000"

TimeStamp

"yyyy-mm-dd hh:nn:ss.0000000"

Amazon Redshift" (quote)Date

“yyyy-mm-dd"

IBM DB2" (quote) PosgreSQL" (quote)Date

"yyyy-mm-dd"

Azure Synapse Analytics[ ] (square bracket)Date

"yyyy-mm-dd"

Exasol" (quote)Date

"yyyy-mm-dd"

Oracle MySQL` (backtick)Date

"yyyy-mm-dd"

SAP HANA" (quote)Date

"yyyy-mm-dd"

Time

"yyyy-mm-dd hh:nn:ss"

Google BigQuery` (backtick)Date

"yyyy-mm-dd"

11.1.x

11.2.0

11.2.4

11.3.0

11.3.1

1.0.0

65.0.3312

11.2.5

11.2.x

11.3.2

11.3.4

7.1.0

90.0.4403

11.3.5

11.3.x

13.1.2

98.0.4758

"yyyy-mm-dd"

Oracle Database" (quote)Date

"dd-mm-yyyy"

Time

"yyyy-mm-dd hh:nn:ss"

Microsoft SQL Server[ ] (square bracket)
Note: if the identifier uses character

, you can escape by using

]]

in your SQL statement.Date

"yyyy-mm-dd"

Time

"hh:nn:ss.0000000"

TimeStamp

"yyyy-mm-dd hh:nn:ss.0000000"

Amazon Redshift" (quote)Date

“yyyy-mm-dd"

IBM DB2" (quote) PosgreSQL" (quote)Date

"yyyy-mm-dd"

Azure Synapse Analytics[ ] (square bracket)Date

"yyyy-mm-dd"

Exasol" (quote)Date

"yyyy-mm-dd"

Oracle MySQL` (backtick)Date

"yyyy-mm-dd"

SAP HANA" (quote)Date

"yyyy-mm-dd"

Time

"yyyy-mm-dd hh:nn:ss"

Google BigQuery` (backtick)Date

"yyyy-mm-dd"

11.1.x

11.2.0

11.2.4

11.3.0

11.3.1

1.0.0

65.0.3312

11.2.5

11.2.x

11.3.2

11.3.4

7.1.0

90.0.4403

11.3.5

11.3.x

13.1.2

98.0.4758

Therefore, new versions of Google Chrome has impact on PDF files. Although it is not the Chrome installed on your machines, but the Chrome bundled in Export Service.

Why would Google Chrome change its behavior?

Developers have been devoted to making a better browser.
To improve performance, the team planned to refactor the layout engine used in Chromium and the new one is called

LayoutNG

(i.e. layout of new generation).
It is a long plan. LayoutNG is launched in stages. Layout primitives (such as table, flexbox, grid, and block fragmentation) are replaced in subsequent releases.

In Chrome 77,
```
LayoutNG
```
is used for inline and block layout.
In Chrome 90,
```
LayoutNG
```
is used for table layout.
…

Some of the old behaviors are even issues, according to the official documentation of LayoutNG. See Developer Visible Changes.
In addiction to LayoutNG, there are more sub-projects. In older versions, sub-pixels are not supported in various layouts. Now, TablesNG helps to resolve many bugs.
Developers are re-architecting the web, and improvements bring behavior changes.

More Impacts

Upgrading has more impacts. Some commonly seen differences are listed below.

Grid

The same grid is rendered with different column widths and row heights in new versions of Google Chrome. It may result in more pages of PDF.

Graph

The same graph is rendered with different row heights.

Bullet Chart

The same Bullet Chart is rendered with different row heights. It may result in more pages of PDF.

Text

The newer font engine in Chromium has a different algorithm to calculate letter spacing.

Comment

0 comments

Details

Knowledge Article

Published:

June 14, 2022

Last Updated:

March 21, 2024

Symptom

After upgrading Strategy products to the versions Strategy 2021 Update 5, we see some visual differences in exported PDF files.

"yyyy-mm-dd"

Oracle Database" (quote)Date

"dd-mm-yyyy"

Time

"yyyy-mm-dd hh:nn:ss"

Microsoft SQL Server[ ] (square bracket)
Note: if the identifier uses character

, you can escape by using

]]

in your SQL statement.Date

"yyyy-mm-dd"

Time

"hh:nn:ss.0000000"

TimeStamp

"yyyy-mm-dd hh:nn:ss.0000000"

Amazon Redshift" (quote)Date

“yyyy-mm-dd"

IBM DB2" (quote) PosgreSQL" (quote)Date

"yyyy-mm-dd"

Azure Synapse Analytics[ ] (square bracket)Date

"yyyy-mm-dd"

Exasol" (quote)Date

"yyyy-mm-dd"

Oracle MySQL` (backtick)Date

"yyyy-mm-dd"

SAP HANA" (quote)Date

"yyyy-mm-dd"

Time

"yyyy-mm-dd hh:nn:ss"

Google BigQuery` (backtick)Date

"yyyy-mm-dd"

11.1.x

11.2.0

11.2.4

11.3.0

11.3.1

1.0.0

65.0.3312

11.2.5

11.2.x

11.3.2

11.3.4

7.1.0

90.0.4403

11.3.5

11.3.x

13.1.2

98.0.4758

"yyyy-mm-dd"

Oracle Database" (quote)Date

"dd-mm-yyyy"

Time

"yyyy-mm-dd hh:nn:ss"

Microsoft SQL Server[ ] (square bracket)
Note: if the identifier uses character

, you can escape by using

]]

in your SQL statement.Date

"yyyy-mm-dd"

Time

"hh:nn:ss.0000000"

TimeStamp

"yyyy-mm-dd hh:nn:ss.0000000"

Amazon Redshift" (quote)Date

“yyyy-mm-dd"

IBM DB2" (quote) PosgreSQL" (quote)Date

"yyyy-mm-dd"

Azure Synapse Analytics[ ] (square bracket)Date

"yyyy-mm-dd"

Exasol" (quote)Date

"yyyy-mm-dd"

Oracle MySQL` (backtick)Date

"yyyy-mm-dd"

SAP HANA" (quote)Date

"yyyy-mm-dd"

Time

"yyyy-mm-dd hh:nn:ss"

Google BigQuery` (backtick)Date

"yyyy-mm-dd"

11.1.x

11.2.0

11.2.4

11.3.0

11.3.1

1.0.0

65.0.3312

11.2.5

11.2.x

11.3.2

11.3.4

7.1.0

90.0.4403

11.3.5

11.3.x

13.1.2

98.0.4758

"yyyy-mm-dd"

Oracle Database" (quote)Date

"dd-mm-yyyy"

Time

"yyyy-mm-dd hh:nn:ss"

Microsoft SQL Server[ ] (square bracket)
Note: if the identifier uses character

, you can escape by using

]]

in your SQL statement.Date

"yyyy-mm-dd"

Time

"hh:nn:ss.0000000"

TimeStamp

"yyyy-mm-dd hh:nn:ss.0000000"

Amazon Redshift" (quote)Date

“yyyy-mm-dd"

IBM DB2" (quote) PosgreSQL" (quote)Date

"yyyy-mm-dd"

Azure Synapse Analytics[ ] (square bracket)Date

"yyyy-mm-dd"

Exasol" (quote)Date

"yyyy-mm-dd"

Oracle MySQL` (backtick)Date

"yyyy-mm-dd"

SAP HANA" (quote)Date

"yyyy-mm-dd"

Time

"yyyy-mm-dd hh:nn:ss"

Google BigQuery` (backtick)Date

"yyyy-mm-dd"

11.1.x

11.2.0

11.2.4

11.3.0

11.3.1

1.0.0

65.0.3312

11.2.5

11.2.x

11.3.2

11.3.4

7.1.0

90.0.4403

11.3.5

11.3.x

13.1.2

98.0.4758

"yyyy-mm-dd"

Oracle Database" (quote)Date

"dd-mm-yyyy"

Time

"yyyy-mm-dd hh:nn:ss"

Microsoft SQL Server[ ] (square bracket)
Note: if the identifier uses character

, you can escape by using

]]

in your SQL statement.Date

"yyyy-mm-dd"

Time

"hh:nn:ss.0000000"

TimeStamp

"yyyy-mm-dd hh:nn:ss.0000000"

Amazon Redshift" (quote)Date

“yyyy-mm-dd"

IBM DB2" (quote) PosgreSQL" (quote)Date

"yyyy-mm-dd"

Azure Synapse Analytics[ ] (square bracket)Date

"yyyy-mm-dd"

Exasol" (quote)Date

"yyyy-mm-dd"

Oracle MySQL` (backtick)Date

"yyyy-mm-dd"

SAP HANA" (quote)Date

"yyyy-mm-dd"

Time

"yyyy-mm-dd hh:nn:ss"

Google BigQuery` (backtick)Date

"yyyy-mm-dd"

11.1.x

11.2.0

11.2.4

11.3.0

11.3.1

1.0.0

65.0.3312

11.2.5

11.2.x

11.3.2

11.3.4

7.1.0

90.0.4403

11.3.5

11.3.x

13.1.2

98.0.4758

Visual Differences

Root Cause

The visual changes were caused by Google Chrome.
This is not specific to exporting. See the 2 screenshots from the same dossier in different versions of Google Chrome.

"yyyy-mm-dd"

Oracle Database" (quote)Date

"dd-mm-yyyy"

Time

"yyyy-mm-dd hh:nn:ss"

Microsoft SQL Server[ ] (square bracket)
Note: if the identifier uses character

, you can escape by using

]]

in your SQL statement.Date

"yyyy-mm-dd"

Time

"hh:nn:ss.0000000"

TimeStamp

"yyyy-mm-dd hh:nn:ss.0000000"

Amazon Redshift" (quote)Date

“yyyy-mm-dd"

IBM DB2" (quote) PosgreSQL" (quote)Date

"yyyy-mm-dd"

Azure Synapse Analytics[ ] (square bracket)Date

"yyyy-mm-dd"

Exasol" (quote)Date

"yyyy-mm-dd"

Oracle MySQL` (backtick)Date

"yyyy-mm-dd"

SAP HANA" (quote)Date

"yyyy-mm-dd"

Time

"yyyy-mm-dd hh:nn:ss"

Google BigQuery` (backtick)Date

"yyyy-mm-dd"

11.1.x

11.2.0

11.2.4

11.3.0

11.3.1

1.0.0

65.0.3312

11.2.5

11.2.x

11.3.2

11.3.4

7.1.0

90.0.4403

11.3.5

11.3.x

13.1.2

98.0.4758

"yyyy-mm-dd"

Oracle Database" (quote)Date

"dd-mm-yyyy"

Time

"yyyy-mm-dd hh:nn:ss"

Microsoft SQL Server[ ] (square bracket)
Note: if the identifier uses character

, you can escape by using

]]

in your SQL statement.Date

"yyyy-mm-dd"

Time

"hh:nn:ss.0000000"

TimeStamp

"yyyy-mm-dd hh:nn:ss.0000000"

Amazon Redshift" (quote)Date

“yyyy-mm-dd"

IBM DB2" (quote) PosgreSQL" (quote)Date

"yyyy-mm-dd"

Azure Synapse Analytics[ ] (square bracket)Date

"yyyy-mm-dd"

Exasol" (quote)Date

"yyyy-mm-dd"

Oracle MySQL` (backtick)Date

"yyyy-mm-dd"

SAP HANA" (quote)Date

"yyyy-mm-dd"

Time

"yyyy-mm-dd hh:nn:ss"

Google BigQuery` (backtick)Date

"yyyy-mm-dd"

11.1.x

11.2.0

11.2.4

11.3.0

11.3.1

1.0.0

65.0.3312

11.2.5

11.2.x

11.3.2

11.3.4

7.1.0

90.0.4403

11.3.5

11.3.x

13.1.2

98.0.4758

"yyyy-mm-dd"

Oracle Database" (quote)Date

"dd-mm-yyyy"

Time

"yyyy-mm-dd hh:nn:ss"

Microsoft SQL Server[ ] (square bracket)
Note: if the identifier uses character

, you can escape by using

]]

in your SQL statement.Date

"yyyy-mm-dd"

Time

"hh:nn:ss.0000000"

TimeStamp

"yyyy-mm-dd hh:nn:ss.0000000"

Amazon Redshift" (quote)Date

“yyyy-mm-dd"

IBM DB2" (quote) PosgreSQL" (quote)Date

"yyyy-mm-dd"

Azure Synapse Analytics[ ] (square bracket)Date

"yyyy-mm-dd"

Exasol" (quote)Date

"yyyy-mm-dd"

Oracle MySQL` (backtick)Date

"yyyy-mm-dd"

SAP HANA" (quote)Date

"yyyy-mm-dd"

Time

"yyyy-mm-dd hh:nn:ss"

Google BigQuery` (backtick)Date

"yyyy-mm-dd"

11.1.x

11.2.0

11.2.4

11.3.0

11.3.1

1.0.0

65.0.3312

11.2.5

11.2.x

11.3.2

11.3.4

7.1.0

90.0.4403

11.3.5

11.3.x

13.1.2

98.0.4758

"yyyy-mm-dd"

Oracle Database" (quote)Date

"dd-mm-yyyy"

Time

"yyyy-mm-dd hh:nn:ss"

Microsoft SQL Server[ ] (square bracket)
Note: if the identifier uses character

, you can escape by using

]]

in your SQL statement.Date

"yyyy-mm-dd"

Time

"hh:nn:ss.0000000"

TimeStamp

"yyyy-mm-dd hh:nn:ss.0000000"

Amazon Redshift" (quote)Date

“yyyy-mm-dd"

IBM DB2" (quote) PosgreSQL" (quote)Date

"yyyy-mm-dd"

Azure Synapse Analytics[ ] (square bracket)Date

"yyyy-mm-dd"

Exasol" (quote)Date

"yyyy-mm-dd"

Oracle MySQL` (backtick)Date

"yyyy-mm-dd"

SAP HANA" (quote)Date

"yyyy-mm-dd"

Time

"yyyy-mm-dd hh:nn:ss"

Google BigQuery` (backtick)Date

"yyyy-mm-dd"

11.1.x

11.2.0

11.2.4

11.3.0

11.3.1

1.0.0

65.0.3312

11.2.5

11.2.x

11.3.2

11.3.4

7.1.0

90.0.4403

11.3.5

11.3.x

13.1.2

98.0.4758

We can see visual differences between Chrome 90.0.4403.0 and Chrome 98.0.4758.0.