Skip to Content

RDOC.Template changed format from B1 9.3 to 10

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Posted on Apr 29 at 04:45 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

    • 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

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.