Forms Printer With SSRS (reporting services) report - SOP billto shipto address is blank

9 August 2010

Issue Description

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.

 

 

Solution

The SQL Query in the SSRS .rdl report must be modified to include an extra 

 

" ELSE '' " 

 for both the ShipTo and BillTo Address Blocks.

For example:

 

Current Code:

CASE WHEN SOP30200.COUNTRY <> '' THEN ' ' + RTRIM(SOP30200.COUNTRY) END AS ShipToAddressBlock,

...

CASE WHEN RM00102.COUNTRY <> '' THEN ' ' + RTRIM(RM00102.COUNTRY) END AS BillToAddressBlock

 

Correct Code:

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

Site Map