Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Dez to Hex - from Database to Report

Hello everyone,

i have to do some report regarding our call manager but there is a problem getting the values from the database.

Its this format:

Database        Call Datebase Data         BI Report                       

9,48598145191013E16        94859814519101343        94859814519101300               

9,48598145191013E16        94859814519101253        94859814519101300     

I want to get the Database value into my report but when i do this the field shows me the value from column BI Report. But the correct one would be the value in the middle column. As i could see for example MS Excel also did some rounding at the end.

Then i tried the following formula

Local numberVar dez := database field;Local numberVar quot:= 0;Local numberVar rest:= 0;Local stringVar hex := "";

while (dez > 0)do (quot :=dez \ 16;rest := dez mod 16;dez  := quot;hex  := (iif(rest > 9, ChrW(55+rest), ToText(rest,"#"))) + hex;);hex;

If i try this i get the message that it is too much and cannot be done. I tried to cut the database value with the last 2 digets and then it works all fine. But as i need the full one i wanted to ask the community if someone knows this problem or has an idea for it.

Thank you

Tags:
Former Member
Not what you were looking for? View more on this topic or Ask a question