I finally got Views that are created on AS/400 to show up in Crystal Reports. It may have been a space issue. We added disk.
The issue now is when looking at the data, if you look at the view on AS/400 you will see normal data, as here:
Part# PCK 22 01 A01 CRCUP7 33.00 CRW .00 PCK 22 01 A02 CRCUP9-L 32.00 CRW .00 PCK 22 01 A03 CRCUP7-L 48.00 CRW .00 PCK 22 01 B01 SWRS2 682.00 CRW .00 PCK 22 01 B02 SWRS2-G 358.00 CRW .00 PCK - - - .00 PCK 22 01 C01 SWRS-G 3,391.00 CRW .00 PCK 22 01 C02 SWRS 408.00 CRW .00 PCK 22 01 C03 HWCR5-G 735.00 CRW .00
However, when I access this dynamic view in the Crystal Report, I have this for part# C1C1C160D7D3C4D4F5404040404040 and alot of 40's and 404040404040
WHy would this be happening?
The CCSID is set to 65535 (hex).
Add the Force Translate=0
property to your connection string.