TSQL Convert Binary64 text to an image so it can displayed in reports

vsslasd 556 Reputation points
2023-02-03T16:42:26.8833333+00:00

We have some code, as follows which we are trying to convert Base64 string to an image so that it can be displayed in reports.

However, in SSRS, we get the following error message when trying to display the image:
User's image

What needs to be changed in this code ?

Thank you


ALTER Procedure [dbo].[usp_CON_ProcurementCover]

@SignImage varchar(max)=

'data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAfQAAACWCAYAAAAonXpvAAAAAXNSR0IArs4c6QAAHsJJREFUeF7tnWvMXVWZx59zznspLbRQ3iKXYAvDiDgWRpvhA00gXCQTtAYxU5wEkMBwEWbkUhq/GTQxMfZuoGlhNHbAICGBhAEVZ2TQmPpBDKZCAxm5juX2tgVa2r6Xc5mss7vfs84++7LWXvd9/u8ntOv6e9bZ//U861brdDodwh8IeERg3rx1ND1dm2vR+HiHpqbWCrewVlvfTVurEbXb9wjnQ0IQAAEQCJlADYIesvmq13ZVMWdE6vX1FE9TOx0IevVGCXoEAiCQRgCCjnHhFYHYu2aNkvXM446MjKyjVivy8MuW4RUUNAYEQAAEBAhA0AUgIYkdArxnrSrECLvbsRlqAQEQ8IcABN0fWwx1S3ivWsfaN8LuQz2c0HkQGEoCEPShNLt/neZD7TrWvfm1+EajQ82m+KY6/+igRSAAAiBQTACCXswIKQwTqNXWsT3p3VpUQ+18U3VPEgxjQPEgAAIgoEQAgq6ED5lVCTQa66ndjkrREWrn21Ovr6NOJ5oo6PD6VfuK/CAAAiBgkgAE3SRdlF1IwKQX/fbbH9Fppz14dLLQoXYbYfdCgyABCIBAsAQg6MGaLvyGmwq182RMThjCtwB6AAIgUCUCEPQqWTOgvvDh8Hq9Rq3WGiOt53fPr19/Ma1Zs8JIPSgUBEAABFwTgKC7tsAQ1t9/G1yHOh2zoXCcSR/CQYYug8AQEoCgD6HRXXfZdhgcZ9JdWxz1gwAI2CAAQbdBGXXMEegPtRO1WubvWseZdAxAEACBYSAAQR8GK3vSR15YdR9RK+oiwu5FhPDvIAACoROAoIduwYDabzvUzqNB2D2ggYKmggAIlCIAQS+FDZlkCfCC6uIq1scee5lWr36q2+x63U6oX5YR0oMACICACgEIugo95BUi4DLUzjfQZYRACBQSgQAIgIACAQi6AjxkFSPgi5Ai7C5mL6QCARAIkwAEPUy7BdNq/mIXF6F2HhQfKbjvvsvo9tv/PhiOaCgIgAAIFBGAoBcRwr8rEfDFO4870dvtjrvdlQyLzCAAAt4RgKB7Z5LqNMgn73xQ0InabfNn4KtjTfQEBEDAdwIQdN8tFHD7fPPOGUqsowc8oNB0EACBXAIQdAwQIwR89M5ZR/l24Y10I6ZHoSAAAo4IQNAdga96tT5658mwu+tNelUfA+gfCICAXQIQdLu8h6I2X71zrKMPxfBDJ0FgaAlA0IfW9OY67rN3jnV0c3ZHySAAAm4JQNDd8q9c7SMj66nVirrVaBA1m/7tJOdffMM6euWGIDoEAkNLAII+tKY303HfvXPW650799DKlY90AYyPd2hqaq0ZGCgVBEAABCwSgKBbhF31qkZGNlKr1T7qndep2bzb2y7jOVVvTYOGgQAIlCQAQS8JDtkGCYTgncetDqmtGGsgAAIgIEIAgi5CCWkKCTQaG6jd7nTT1es1arXWFOZxmQAXzLikj7pBAARMEICgm6A6hGWG5vHyD7Xs3n09nXPOxBBaDV0GARCoEgEIepWs6agvY2ObaHY22tpeq4VzRzoeanE0YFAtCICAEQIQdCNYh6vQ0Lzz2DrYGDdc4xS9BYGqE4CgV93ChvvHh65D8s4ZFqyjGx4cKB4EQMAqAQi6VdxRZdHFJnF4Ouwz0Lx3/sQTV9KVV57lgGi5KvFQSzluyAUCIOAnAQi6A7vUauvYajMRdajTCVfQv/Slx+npp1/rEgzNO0+G3et1olbLv1vtHAxPVAkCIBAoAQi6A8P1BJ0o5KtH+ZD1ihUn0fPPX+eAplqVWEdX44fcIAAC/hCAoDuwRVXWbkPdDMebvCq2cDCMS1XJ9lzMzNS6ER1EREohRCYQyCQAQXc0OEL3DHkhHB8nmpoKM1zdaKyndnRbbdDREkfDWKpafszwGXGfvhRGJAYBCLpvYyB07zb09sfjodXq0MjIhu7/hLCY+ZXwJyGyagB7M+zLlDo6urGbLX6Xgf03u/1xbKxBhw/fWaZI5LFEAB66JdDJavgnPJctW0Svv36To5bIV8t7Wo2G34+wiPQu9GiJSB9dpUl65fzmST46ggiJeQvdeut/049/vKtbUbMZhaXYaRuVP2bP+I+J/te+dg49/PAVKkUirwIBCLoCPNWsoQpJVbzz2H5V64/quNSRP80rT/PCIerqtE0Ida9VTPE51S7R3Fj0TznlWNqz59YSJSCLKAEIuigpA+lC3JA1b94mmp4O75rXPPPx0ZKQTx0YGKKli+QnSUVHGnn+RWlLNyjgjCec8EM6cGCWOh12zFVnRzpUq9W64fTIaxd7UOmaa35Ojzyyu5snfpBJVvQh8jrt2CsLgm6Gq1Cp/besdajd9v9MehW92Yceeomuu+4XXZv97Ger6OqrzxayHxKlE+DHiOjaOD+5rdXC+C3otv8dd/wPbdv2As3OthWFOxJqthzG/m688Vzatu0y3c3NLW/+/M00Pd3s9oNNREQEHyKvbiIIujpDpRJCEshlyx6gN9880O1v1TwpPNSiNIznMvPCLHtZD/9bkM2rp/V2S5mYuJ/27z8iId7uhVqV0GmnbaN33vlYSuRHRxs0PX2XatVDkR+C7tjMIYXd+QtxvvWt8+n737/QMT191Yc0sdLXa70l6Qidl/Hu9fbCbGlLltxHe/dOFVbCJswjI3X6xjc+R1u2XFyYPuQEMiLPdtpD3LOtDUH34JcQwua4NWueo40bnz9KK+wra9NMHtLEyoMhO9CE/s1t5cdHcjNdFfY0FIk4E+9Fi8bogw++6aNpnbSpJ/LZ1U9MzKfJyductM/XSiHoHlgmBO+QF7zQjtmJmBgPtYhQSk+jW4SrsEmxSMQnJubR5OS/loc+ZDnHxzfRzEy0GTf5B2HvEYGge/DDCME7DGHSoWrKuI/DsH6ryorPbyJMHpfZaHSo2fR/syjjARHXOaqyyxob20Szs4PiDmEngqDbGYOFtfgcdu+/5rVBU1PV3KDisw0KB5CjBLyY6xTfUGwBEXc08LoTqK20d+9heOwcAQi6u/HYV7PPHrDPbdNpvhAiJTr7q1qWyaNmPtsCIq46cvTmh7Aj5K53RGkozdcP2MjIxrk7nat2VC1pNjzUIj6QeVYmxoVvexpOOWUbvfvux5mAsCYuPnZMpcwS9ssvP4Oeeearpqr1qlx46B6Zw8cw47B452wYsPsv2MSK/ekMH3s0xLQ0RfcmuKxGub4b4Nvf3knf+97vudvQ+lsKEdcynLQXkibs/J3zrMKqPt8LQdc+nMoX6Jt4zpu3nqano/6Y8MLKkzKX08dJlbneypdsS8yjMRdNrqLJlr3neU89dSu9887g2ixrB0RcfszYzHHyyVvpvffSbZfVjipN3iHoNkdbQV2+hd1dfVBdmoS/PMemiLjss0zdJna0Z39o7b1Vn+eND8tkVmYc+Jg2+bKfbBurIOwQdFmrG07vi4f4+c//B73wwvtD5Z2zzlbhDLSpIerialbTRwmXLn2Q3nrro1RkK1eeRr/73T+bwolyNRH4xCe20vvv93vlyaOn/O+aVdto1LrXz7ajV2T7/pYuXUhvvHGzptbZLQaCbpd3YW2+eMX8bPeLXzyTnnrqqsK2VyHBH/7wLp1//sPdrog+LFKFfhf1QeWO9qKy8/7dxAR32bLt9OabB1OrhTeuYi37eZNCnWe/Sy99jJ599s25RsaPAPEbMON/POOMRfTaazfZ75BijRB0RYC6s/sQdn/ssVdo9er/nOvasIWeTYiI7nFis7z+42nsyUx769m6fg95Is5Ywhu3OaL01JUMsZ900nx67738q2AHRb03npPCHqKoQ9D1jC2tpbgWFP6HMjFxDE1O3q61f74X5kuUxAdOpo+nifSx7K1xRSK+dOlx9MYbt4g0AWk8InDSSVtpcpIPscu/HcD/xlnXYqflzDMfpNdf7y3BhCbqEHSPBmrcFNeC4rp+1ybR5RW67odq/f0Prtjdac63XWaCCxFXtbrf+ZNiHofNy7Q66eFfcslS+vWv/4lCFnUIepmRYDiPS0Hh62bvEM/MVPOa1zwT8kezHn10Fa1efbZhi/tXvM3jaUW9L/o9QMSLCFbj35Pny5csmU/vv6/22lpyDf7CC0+n3/zm6gFRD2XZEYLu6ViX8Up0dmHYvfNklETFA9BpF9tl2TyeVtQ3fnLB7FE7ektI2g7lfs++97/ii0VY/lAeeyniMmz/zo9JHWIe8xsZ2UCtVmcOZyze/Jp6KEfaIOie/ipcCGv/TuYatVprPKVjvlk9/vLrc+ZbZ7aG/sd4OjQ1JfbaGQvR83/s5r20v6z/32yvikvnbxNj/z06Kt734tKRQpWAySOMF130KP32t/83IOouvsMqnCDoKvQM5i0KM+qu+uGHX6Jrr/3FwIDWXU8o5dnm7wuXZKg9FjlfRXiQW9osoqYFb8/Lj4prtezt9tfSgYALsfF7TNsAGtr7DhB0jwe5zbA7/4NZvnyCdu263mMy5pvGC9v27V+gm28+z3ylDmpgYcV2OxI8M6I9KLBRyDzdfWf/xoRyYuJ+2rfvSCoRXbvTo77HVUQXjUR/5SYAvOBD7PUOZlvfwrT7FkxGBvRSwnvounlqLc9WuKd/jdLuOWOtwDQX5vpxEJ3dYeLV6TDRkhXuSOSSIhwLr842btr0R7rnnudSH0MZGalTsxmpr+3LX9jGKSbykeCXF/uqPgiicwyklcVvhpuYmE+Tk2ob4Yray393FywYpUOHZueynH32Ynr55RuKinD27/DQnaEvrthGmCn6QLp5BKOYgNsUIa6js8nZ7GxZ4Y7Fyu6+gfnzN9ORI80UY3do1aqz6Mknv9L9N1u/B5lRx0KysdCLCj4T9nodm/NEObuwe/Kceq+tdn8boozidBB0WWKW05sONfFrROx+42ZzeDfCJU3r4kMiM7wiMZH1uCMPl4W82+3eZjfbj9J8+ctP0FNPvZoa5p83r0FHjgwelwxtPZNNrmZmulPmzOUM29EGmfHlS1rT38C0fq5c+Qjt3LkndZLZ6YhtEnXBD4LugrpEnaa9Z9PlS3TVu6T8UsQPfnARrV37D07aGAt3V4Yzdo6nNSwW7rExyt2p3r8ZqF/odXd4dHQDNZtp6+pEGzZcTHfdtSK3ypDWM9M6kvci2LAekcwzuOtJ3IIFm+nwYT56BA9d9zdhqMoz6SWWPZ40TAawuY5efoMaO5vNwrhU6oy16UnduefuoD//eTJ12Jx44jG0d6/41cKm22prbEfee7rnjpB8zwq+2Du+gMb3SRc8dFu/YIV6TIScsBFOzCCmPijl1rqjS1V0rr+amtRt376Lbr/9v/ou7IiJsw1uLOJR5I2nWYi/7KMqr+GlvfYV952J+9jYcJ6H9+lilw8/nKaf/ORFuv76z9Lxx4+LfTwcpIKgO4AuW6UJUbG9ZirbZ1/S6wj5yYt3JNymd0XzH0xda7kLF/6QDh7sLhwP/H3qU8fTK6/8i7JpTUxwlRulqYDkVaR8sbpspKmpxosx8d0z3mjHFUDQHRtApHrdYff+D7nZNVOR/vmc5q9/PUinn76920QW0hY5Xyy3WU3M62YewpYtf6Svf/3vaNmyRVqQ6fhgPvTQbrrzzmdp//6p1DYde+woHTx4h5b2xoXo/j1obZymwvJC8qyKUK4iLYvDJ++8bB9c5IOgu6Beok6dXomOD3mJLgSbJe/4mpx4RzvMy3je9967k77znZ1dhitWnEz79h2myy5bRuvWXVQqBFg21H7zzb+in/50d2KjUL9p6/Uabd36BbrllnON2Vzn78FYIxUK5jdCxsWkbYisqrDjG1Vu8EDQy3GznkvXAOdDelX9GOg2Di9+TIxFd5qXFe+09jMPnXnCO3a8NPDPTECPOWaEbrzxs7Rly6WF3ZfZP3HWWf9Ob711gGZn565Uyyi/Q+edt4T+9Cc7NwxWxUuPPXEGVWRcsU1Z7IKg5J9vv+W4X+22/PW48M4Lf8KZCSDo5dlZzanrAxbiZSlWQR+tLN5xLvKRZVnSznabaPeuXZN0993P0V/+8gHt2fPx3O1pfF2f/vRi+tGP/pEuuODU1CYkJ4ePP/6/9N3v/r6b9pVX9tPMTJO7EjW9F2xj2yc/uZBefVV9TbwMJ35S4puYFfUnbxNcUV7272zphwl7qzUo7D5sFOzZptwRL13OiwjLqqWBoAdkUdUwY9kwa0CISjVV/px3dEyMv5ilVMWaMt100zNdzz3pRbOLgkZH63O1sKtT086AizSDRQCuueYz9MADl4skt5ImtA9/vpDnb4TkN2fGE0jm/aaVKbrXw4SR+h/3kRf0E0/cSvv3H+42LbSJmgmesmVC0GWJOUyv+gFTnRA47LqWqsvdZx6JN3/bV/xespZGaSxk58636YYbftn1ssv+sfA9u8L0hBPm0ebNl9C1136mbFHG8+k4gWC8kUSpohuJsvyG1OSVpGlvd8devMgGTp39T77Ux24jlL1VTVckUme/QioLgh6QtVQG+7AdU5PdrBYNg+wd5/zHyoewZtGwvfXWX9GOHbu5F8SIpqdbc9mWL19C9957AV111d8WFeX1v/s8Sc3yyFU9z+Rtc/F4TAqqTU897Qa8Mv302Z5e/xCONi54QWcDaZguXigz4Ps3Qcl7BT4PZNlNRXFfyqx5l2HvCzub17va7LPKJNdUO00JOd/eZAiejxrxXrzps+uDXvnRqXFHfjOcj7Y0NUZMlRu8oMeeZwhekw4jlgm7l8mjo60mypD3vKOQedF95iJtDfmDU6UxwNvKp81xWeJWxlMVGY95u8FtiHrWvfRlv8UhT5hF7GUjTWUEPVqTKkbGp7G9xlTcuuIUsqIS8hEQuRvWzN+uFlrYPR5NVd8M6cNkRVfIufgL0J8ir+/8MptOTz1r4lJmzTzuDf+dWrx4Pu3bZ/bNc1nOoaSvlKDrgi4yMZCpKy5vdFT9Tmb+xzR//ggdOnRnblN8+NiJspI5KqbzjLdo+6JJY/R2vM4PpEz9smlNXO8q2wbT6V1ujksTN1MeeRrHogl7cqKhuqEzyysvs8GP709I3ynT41ml/OAFPboopW9oqPBwkjcWfNHogaio8JfIlA2DmQQiEz735QUq2QiJSX5FZSfFRvVjXlSfy38X/U3obGPy3nVXk7wiMdQh6nlH7lS/LTiqpm9UBi/oWSiiWTtTeoE4fCFPiUeoB8rSUX+v0ORNZWwna5bnX/RDL+y2xgSy3jcL3/lyzpvHwH/Y7r//Urrtts9ppKS3KN7+qh9dvS3TX5rtiVZSJG3uKE/SE3mbIbmJTnQ85D0Ww9ohWk6exW3bTv/o86fEygp6ntCzc7Y9r15OcONQr0r4PNqZHbcwOvcb/cm1RXQYxW1m6W3tGwjR+xbn6X/YnRdzl2IjylQ1na3NcUlhVFk3Vu0zn1/kWKqMqGeF1vk6dYh596sX2DKWTrvpLmvoBD0PYE9oY5EVE1jZkLmMEW2If7L9IqLPPg7xH7/kUXxVql+3rMnYYm4KVls3N/nyMYw9bGLesws/JuWPTRWNhaTIqa4bF9Un8++i9/PnHXfLfuGtQ40GcwZ630NdYg7vXMbKxWkh6MWMqF/oBTLkJOHXyUXXzNOKy9rslOZBmPL8RUi42rwm0rayaXjGTz75FVq16m/KFqU9X/9DMn4uW2jv9NECTe0ZSNv4pkvQdLIQPc2Q7A/bxJd2L3y8JyCZXmff4Z3rHAFEEHQFnr2wsrmQedqO+2IvWKFTGrJG577Vd/RraIqxIuIPkU/h7OSrcGVeujIGzFLB/RfosPv21Tx1Xza+ieLrRWfyr10dnPj3auAjDybFHEfVRK0qng6CLs6qdEr2UYj//N2RP7jxr9adTUQbC6N1frEliDRQfFhfZf9BaSNozujThkPWNV54XO221oy4dHH8xEZlwpV1xWrphlnIKPI8ctZGt+RxO5NizlD49huyYB7jVUDQjSOWryB7AhCVxXvtaW8jszQ6w2J5Pei1tbzo82Ivsn4vT1R/Dt67sMU6qxd566L6ex5GiSo7/H3d+CZKPksoi3as85Mf02K+ePH99MEHR7pdsnluX5RhqOkg6KFa7mi7kz88n7yzspsMY5PE6+8sBNhsrvXOUqLhTZMNh5hn0xUV9bwjlT5tfBMdR8nLZtptNtlO5u7Q+DjR1NTaPk+ZTU6bTTMb4PgWYDOcqDXl0kHQ5Xh5mToWddeeogwcFbHXcXRQpq1ZaV1f3GNqE5gONj6UkTbZ5dtVtBclpN9Tkjc/meH/LWt/S1Z6UwywGc7MLwSCboYrSlUgEIXx5UP4LoTe1YfJdEhUwXxeZc2+d3ywmb7cRqgCMOvoWVHkLu3cuSkxd3lVrwrbEPJC0EOwEtpY+uig6fV5/kP49NNfpSuuOMOKtUTDyVYa43klkainNzISOv+Wc2SRZp8hj0rKEuesdXWT9ytgM5ysdcXTQ9DFWSGlhwTi0H0UPhXfhR8LverxuhdfnKTly3d0yRR5Qbrw8R9EbCjSRTXMcrLuWGdr/+zJ4Onp3m+CF+m0fPy10qbGFTbDmR1nEHSzfFG6IwLRRic6uhlITOjLhlx5L/3DD/+NFi0aN9brYb0FzhjQQAvOOkee3MSXvICKdVd0g5wJLx2b4cwOOAi6Wb4o3TMC/ZcB5Qu96C13/ddumrudDWLu2WCy3Jy8sHqeR5214Y01P5mv6DlW1S672nOi2u5Q8kPQQ7EU2mmMQG8TXn4VcZi+Xh88RifyOIZKB3ALnAq9sPPm3eomEhqPRLqfAbubPesoqKk1bmyGMz8OIejmGaOGwAjIP/Uar59HHRX5yMoggZjL0KpG2jxv3PReDVNeuqmJQjUsrqcXEHQ9HFFKhQn0Pq7i19+WXY9PYoSYV3hgpXRN1RvXRUu3+GIznC7LFEQRO73HuO3UiFpAoAIEel68mMjnheuzcOAWuAoMlIIuFB03M+2NZzVPt5eOzXB2xjI8dDucUcsQEJAJ1TMceSIPMa/ugBEZJ7qXbcrQ1OmlYzNcGQvI54GgyzNDDhDIJcB/CGPRFn2trpe+V4WJ40MwoV0CvdMV6fXqWqLR2StdXjo2w+m0CkLu9miiJhAg6t5qx1/okQyb2gjXwxDuCaRdp8q3Kutedfct77VAh5euowyfmPjcFnjoPlsHbQuaQPL8b56nXfTxTwMhek4+aIgBNb5oPTxeZmm37wmmV6peumr+YEB50lAIuieGQDOqSSAp1Mk3p2dm0p62jO7eZs9YRk9fim28iwUjEno/n5ytmpWL18M7VK/XqNUKR8STNlLxsFXyVm2s2OgPBN0GZdQx1ATyjiLJhmD7n50Vw2r6gRqxVlQjVdFaeDypSrt8KFQCZb3ssvlC5eRDuyHoPlgBbag8gbxnPHUcTZK50jaG7eK52VAMHfNk7S16Nz0WcdWHfnxmU8bTLpPHZwYhtA2CHoKV0MZKEYg89g7lXb+po8NlH6iJBSrkMLEoP1nh7pUbfihdlBFLJ+tty6aXaQvSZhOAoGN0gMCQERC9uz6JJfboQ1yfVxHuWq3WvTNgGCY4eT8FGY9bJu2Q/fyMdheCbhQvCgeBMAjIHqXjexWv0fOh/MHJgLlNeqztnU70ch4fHhcJlfMeN4Q7f6yKet28mLOnhNmTwvizQwCCboczagGBIAmUCdvr6mhyoiAn0Fmt6BCEu7yFijxv/lQHf6KjfI3IKUMAgi5DC2lBAATmCPRC9+xY3Zx/7gGhqD0Qbv2myLv1DQ8J6ectWyIEXZYY0oMACGgjEEcABguMz99zU4Wuyx6JNfP+st7z1tY4FJRKIPbSeQ+cF3odpzaAvhwBCHo5bsgFAiAAAkNJgA+7L1jQoEajQQcOzMyxwNsD7oYFBN0de9QMAiAAAsERWLBgIx0+3E5tN8TcrTkh6G75o3YQAAEQCI7AscduokOHWn3tXrhwjD766JvB9aVKDYagV8ma6AsIgAAIWCJw3HGb6eOPZ7u1HXfcGB04cIelmlFNFgEIOsYGCIAACIAACFSAAAS9AkZEF0AABEAABEAAgo4xAAIgAAIgAAIVIABBr4AR0QUQAAEQAAEQgKBjDIAACIAACIBABQhA0CtgRHQBBEAABEAABCDoGAMgAAIgAAIgUAECEPQKGBFdAAEQAAEQAAEIOsYACIAACIAACFSAAAS9AkZEF0AABEAABEAAgo4xAAIgAAIgAAIVIABBr4AR0QUQAAEQAAEQgKBjDIAACIAACIBABQhA0CtgRHQBBEAABEAABCDoGAMgAAIgAAIgUAECEPQKGBFdAAEQAAEQAAEIOsYACIAACIAACFSAAAS9AkZEF0AABEAABEAAgo4xAAIgAAIgAAIVIABBr4AR0QUQAAEQAAEQgKBjDIAACIAACIBABQhA0CtgRHQBBEAABEAABCDoGAMgAAIgAAIgUAECEPQKGBFdAAEQAAEQAAEIOsYACIAACIAACFSAAAS9AkZEF0AABEAABEAAgo4xAAIgAAIgAAIVIABBr4AR0QUQAAEQAAEQgKBjDIAACIAACIBABQj8P08DzC+hmlwsAAAAAElFTkSuQmCC'

as

DECLARE @DisplayImageinSSRS varbinary(max)

SET @DisplayImageinSSRS = CAST('' AS XML).value('xs:base64Binary(sql:variable("@SignImage"))', 'VARBINARY(MAX)');

Select

@DisplayImageinSSRS

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,777 questions
0 comments No comments
{count} votes

Accepted answer
  1. Viorel 112.5K Reputation points
    2023-02-03T17:01:59.5966667+00:00

    Try removing the unneeded part. One of the methods is:

    set @SignImage = replace(@SignImage, 'data:image/png;base64,', '')
    

    Then convert it to binary.

    Or, maybe it is possible to use the original string in reports without conversion.

    1 person found this answer helpful.
    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. vsslasd 556 Reputation points
    2023-02-03T20:49:54.9966667+00:00

    Thank you!

    0 comments No comments