Specify fonts for BIRT PDF report

Assume you have used the Calibri font at design-time.

Extract the fontsConfig file. The actual version number of the birt runtime will be different for you installation.

cd /var/lib/tomcat7/webapps/birt/WEB-INF/lib
jar xf org.eclipse.birt.runtime_3.7.2.v20120214-1408.jar fontsConfig.xml

Assume under Ubuntu linux you have added the Calibri fonts to the folder /usr/share/fonts/truetype/calibri. The permissions of this folder should look like

Style content in ckeditor

To see your content in the ckeditor the same way, or close to it, that it appears when viewed, you need to add your custom styles to one of the CSS files loaded by the editor.

The ckeditor.css file is loaded. It is located in modules/ckeditor/css/ckeditor.css. You could place your custom css there.

However, your default theme’s style.css is also loaded. It is better to place it there since you already have to have it there to show up when viewed.

Run chrome in insecure mode

If, while developing, you need to work around Chrome’s security features that prevent you from retrieving http content while on a https page, then you can do so using a shortcut like so:

"C:\Program Files (x86)\Google\Chrome\Application\chrome.exe" --user-data-dir=c:\temp-chrome --disable-web-security --allow-running-insecure-content

Specify MySQL column collation in a view to overcome mismatched collations in comparison

In my budget changes history table, my key is using collation utf8mb4_unicode_ci

show full columns from budgetchangeshistory

rsskey            varchar(500)  utf8mb4_unicode_ci YES      NULL                      select,insert,update,references 

However, when I compare my budget changes view to history, I get a collation mismatch


Subscribe to Blogs