Forms Printer With SSRS (reporting services) report - SOP billto shipto address is blank
9 August 2010
On the SSRS (SQL Server Reporting Services) Template reports installed with Forms Printer 10.5x and GP2010 versions, There is a missing 'Else' in the calculation of the formula that builds the Address blocks.
This causes the Bill To and Ship To Address Blocks to show up 'blank' or NULL in the case where the COUNTRY field of the address has not been assigned a value for that Address in the GP database.
The SQL Query in the SSRS .rdl report must be modified to include an extra
" ELSE '' "
for both the ShipTo and BillTo Address Blocks.
CASE WHEN SOP30200.COUNTRY <> '' THEN ' ' + RTRIM(SOP30200.COUNTRY) END AS ShipToAddressBlock,
CASE WHEN RM00102.COUNTRY <> '' THEN ' ' + RTRIM(RM00102.COUNTRY) END AS BillToAddressBlock
CASE WHEN SOP30200.COUNTRY <> '' THEN ' ' + RTRIM(SOP30200.COUNTRY) ELSE '' END AS ShipToAddressBlock,
CASE WHEN RM00102.COUNTRY <> '' THEN ' ' + RTRIM(RM00102.COUNTRY) ELSE '' END AS BillToAddressBlock
Corrected Template .rdl files can be found here:
http:\\www.accountable.com\ResourceCenter\Resource Center Product Installs\HotFixes\FP-10.51b81\hotfix_blank_addrss_when_no_company.zip