I am trying to create a SSRS report. I am using Record Link to extract notes. The Record ID field has hexadecimal characters when you open the table from SQL server. I have tried my best to convert it to something meaning full through SQL query but field. I am not trying to replace the data in it just I want to filter data on this field but its all in hexadecimal.
Please how I can solve this problem? Any ideas? In NAV the data is meaning full but the type of this field is varbinary in SQL. I tried to convert varbinary to varchar but failed.