How to use Navision Bigtext content in Reporting Services 2005/2008

Dynamics 365 Business Central/NAV Technical Forum
1

Hi all

Does anybody know how to print an SQL-Image Field with Bigtext content filled to Navision-Blob.Field in Reporting Services 2005/2008? It looks like It needs to be decoded/transformed before it can be printed!

Sample: Blob Field was filled with the following code (lXMLText is a Var of type Bigtext)

lrecItem.“Item Property Values”.CREATEOUTSTREAM(myStream);
lXMLtxt.WRITE(myStream);

Sample content: (after Export to file and opend in Notepad)

8700c4d2.91111

and what it looks like in SQL: “Select myBlobfield from mytable”

0x01447C5A016E6397ADB6A89E060A743DA62E4192A44BF5BFCB3E56DB69FDCB4A71E41508E00D953709E393B6D896C91D1910A4A4D2DF020C00080C6E4C6FD7DDDFAB5F87D757E28C7DFBB27E7D5F7EDFB6AF74CF8392266E821B5B320C26A3DBECE9E9C7D160FE68C74BC66A3E58BE779C6F1154D47523B2F3D81F09A89EF2D2EADB1E66826A1E46D27926A3CCA60B1D0D28269C416BD92FCF71DBE84DC4EEAC1711B695F1DE16E89F326980DBBEE7250B900A07C7670DBFA56E81B8459B8C233A821FCA4CA23CDE55EF817C37BDA2997C46E1A0F65C2EFE355A3BD61C6F4D84FFA1EDA4C04DCBAE24E6DE7A5CBB3AE7C4E23CAB959EC0CD12BA4699713AD82C9B2E23D20914108CFEBECC581CB06A21EFC5D781EC7285924679F046B3C9D5678C57A39F2821E4D9F942550829F539A3CA4224E0529C9CC4DCB81CF4B1241D76D78C811921A50B2A47FE4BDDA065F0ED6F7AF4DBC52816713454074ADCF7F235CF892417FBD6E5E21B541056C4120C1807A1FA04B2D51E7ADCBDF9CC0303F445DFA23A13DBE1ABE9DDAF663F1FF400

in the following samples, the fist line is just some ASCII text and the second line the results from the SQL select

1234567890
0x01447C5A000A380A2875073C0F00D05397BF00

1
0x01447C5A00010000031000

2
0x01447C5A00010000032000

11
0x01447C5A00020000031000

111
0x01447C5A00030000031000

11122
0x01447C5A000520042330770018


0x01447C5A000F3B4E4A13C3712E8EB8010209B35CFF020A6B0BEB3B223E80

Somehow there seems to be a Prefix containing the lenght of the Blob? But I haven’t found the right sequenze to get the content out of it. I’ve tried different CAST/Convert combinations and also base64 – unicode – hex but sofar no luck.

Who can solve the puzzle?

Thanks,
YAMOD

2

Old message, but I think your problem is that Navision compresses BLOB fields so you’re seeing the results of that compression.

There’s a property against the table column that you can change to disable this from inside NAV if you have a Navision dev license.