RDOC.Template changed format from B1 9.3 to 10

[jsveiga_sps]

Hello, I opened a ticket with support for this, but it was denied as a "how to" question, and they suggested posting here.

We have a system integrated to SAP B1 9.3 which fetches the Crystal Reports .rpt from RDOC.Template. It is a BLOB, which can be decoded from base64 into the original .rpt file.

We have noticed however that on SAP B1 10 the format in which the .rpt is stored in the BLOB column changed from base64 to something else (apparently a string of hex values).

In 9.3 the BLOB looks like this (excerpt, just a small section):

+/N4Wra7ocyhrGf3tLTB5kR4cS5JpABzttC/Qa0ru5rdKUZn/D2/Q0O7rtLTC+FU6GMFxkYBwPfD9BcHmaY9pUNcKkZRYavxq6Y43a9Si3RL0X3tfeLj+NRo8wEBRUWWbcOCZQhIRMNc65RBJiGNq5llccgvrlElX3jcU2BdOMNukkAY+7zF90mEBLmDAKyv3XbskkOiGLyybBd8EMihX1216EP5WakX

And in 10.x it looks like this:

0xD0CF11E0A1B11AE1000000000000000000000000000000003E000300FEFF090006000000000000000000000008000000AC0300000000000000100000AB03000001000000FEFFFFFF000000007F000000810000004D010000830000009E0200009F020000520200009D030000FFFFFF

Do you guys know what is this 10.x format and how to recover the .rpt from it?

Thanks,

Joao S Veiga

[former_member11696]

I don't think this is a how to question.

Issue is the Report saved in the BOE System no longer recognizes the Report.

Not sure what RDOC.Template is but I suspect it's B1 canned report templates B1 uses in their system.

[jsveiga_sps]

Thank you Don, I don't think it's a how-to question either, as it was a change in the B1 workings from 9.3 to 10, but that was the only answer I got from support.

The RDOC.Template is where crystal reports templates (.rpt) are stored when the user imports an .rpt into B1. We were able to read this field and convert it from base64 to the original .rpt in SAP B1 9.3, but in SAP B1 10.x SAP changed the BLOB format from base64 to something else, and we could not figure out what it is.

r