AX 2009 SSRS Report deploy language

Reduce the number of Reports Libraries and Reports per Language. By default, reports from all languages that are enabled in the LANGUAGETABLE of the AX
database are deployed (this can be over 40+ languages). Prior to the reports deployment you can change the LANGUAGETABLE so that it only deploys Reports
for the languages (cultures) that you want deployed.

To do this set the value 0 in the LabelFile column of the LANGUAGETABLE table for languages (LANGUAGEID column) you dont want to deploy reports for.

IMPORTANT NOTE: Make a backup of the table and/or database before changing the values. Also be aware that if you have any AX clients that has references
to those languages that are disabled then they won't be able to log into AX.

Here is a sample SQL update statement to set the value zero in the LabelFile column for all languages except the ones specified in the WHERE clause:

e.g. The following statement will NOT update the values for LANGUAGEID en-us or zh-hans, but set the Value 0 for all other LANGUAGEID values

UPDATE LANGUAGETABLE SET LabelFile=0 where LANGUAGEID <> 'EN-US' and LANGUAGEID <> 'ZH-HANS'