Post reply

JD Edwards CCSID does not translate in Reporting Services

  • November 4, 2009 at 1:05 pm

    #213387

    I am trying to set up a query over a JD Edwards file on our AS400. The fields display properly in Visual Studio, but when I deploy to Reporting Services, I am getting #ERROR in several of the fields. I finally looked at the file definition on our AS400 and it is coded with different CCSIDs for some of the fields. It appears that Visual Studio translates the information properly and Reporting Services does not. We are running Visual Studio 2003, SQL Server 2000. Is there any way to correct this issue in Reporting Services? Thank you in advance for any help....

  • November 5, 2009 at 9:52 am

    #1075462

    Solution: The data source that was used to run the report on the server where Reporting Services runs did NOT have the CCSID translation option selected. Visual Studio was using the data source on my pc, which "did" have the translation option selected. Once I clicked on the option on the data source on the server, the problem was corrected.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply