cancel
Showing results for 
Search instead for 
Did you mean: 

Report files saved in the database

Former Member
0 Kudos

Hello Sappers

I'm having a hard time figuring out where the Identity Mangement are saving the report files.

The reports are made with the Crystal Reports and setup to save on the database. The MX_REPORT_RESULT field there are on the MX_REPORT entry type is some kind of MD5 encryption like: does anyone have any clues i have been searching nearly every table in the database and i can't find a thing?

// Jesper

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hello once again,

I've just solved my problem. I didn't find my files in the database so i figured maybe i could get my files out via the Identity Center through the JScript.

So i made a "To Database pass" where i selected the mskey from the MX_REPORT entry.

In the destination i made a signe line $FUNCTION.writeLocalReport(%MX_REPORT_RESULT%)$$

and i added the functino writeLocalReport in this i just did:


function writeLocalReport(Par){
  var arr = Par.split(":{HEX}"),
  dir = "C:\\directory\\",
  filename = arr[0],
  file = arr[1],
  fileAddr = dir + filename,
  charset = "ISO-8859-1";
  uToBinFile(fileAddr, uFromHex(file, charset), charset);
}