Results 1 to 2 of 2

Thread: Getting a PNG file out of the database, and onto paper.

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Join Date
    Feb 2009
    Location
    Queens, NY, NY
    Posts
    7,429

    Default Getting a PNG file out of the database, and onto paper.

    Given a Binary Column in database, with an unencoded BMP file in it it is a trivial exercise to add that image to your report.
    Drag and Drop just works,
    Given a PNG file on disk, giving a function that points to the file location ALSO just works.

    Unfortunately, I have a PNG file in the database, in a MEMO field, (nVarchar(max)) and I can not see how to generate an imagein the report from these, given the way the information is stored.

    What is currently working, is before the report is printed, a function writes the image file as a PNG to disk, and sends the location to the report. It works, but it's really really hokey.

    How am I supposed to do it?

    Here is a sample PNG as text that is in the record

    data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAUQAAAB5CAYAAAB BeVgBAAAAAXNSR0IArs4c6QAAAERlWElmTU0AKgAAAAgAAYdpA AQAAAABAAAAGgAAAAAAA6ABAAMAAAABAAEAAKACAAQAAAABAAA BRKADAAQAAAABAAAAeQAAAAB2OglpAAAZVklEQVR4Ae1dCdhuV VXGMDUmSUARIa+gKJNSDGJYwAUDwUweBgUlbhiaiAbmkwndUsH kirPSo4RGMUQKOJED4EOgCZWCJiF4wQFIIYZbIhoC1Vrwr8t73 3/vfc4+w3f2+c5az3PuXvNe+z3n2985++zvv2ut5eQIOAKOgCPgC DgCjoAj4AiMCYHlUuz/yXGVHBuOqXCv1RFwBByBLhHYXpLpZGjH5V0m91yOgCPgCIwJgX dIsTYZWjum+r1WR8ARGBkCv1BwvdsVXJuX5gg4AnOIwKMKHpPe FTKVXC/X6rIj4AiMDIGS7xBHBqWX6wg4AmNHoOQJceXYwfX6HQFHYFwIl DwhfnZcUHq1joAjMHYESp4Qvzd2cL1+R8ARGBcCJU+IPx4XlDO tVl8ufVQOffH0t3L8ohxOjoAjMMcIvF7GZvsPtf35HI81Z2i3E y6GUU4O93UEHIEAAo8O6EpRbU6FfJvkKYo6+cVIbb4tKYaO6x2 BkSOgv1+2ux9rRz6kVuU/LoCH4WLtV1r14MGOgCNQLAKrpDL7oFtbbLEzKOyyAB6GC7YzKM W7cAQcgVkjgB9y42ddQyn96dKGYYCt1oey8huo0skRcATmCwH+ oKs8VTpaBs54bLoAxsvI5mutU71KfNxzjcD/0gd9yhMiT4aIhW65YfuH5/rK8ME5AhNEgD/kOAlMDY4qLI4QQNhnahj5eB2BuUaAP+A+Ia456fHJP1sUiNmR7 OByZwi8aQHrK6X1NdvOYPVEKQTww218yn+ebTZ+bEPjRbvyTt0 j8ExJiTj/e/ddeEZHYDECeNEZv9hrGhobv7X/Ghm2/ZzP/J4U8XN1cwR0r6fha23zbMNHHiIlnCfHusOX4hWkELCLDduU/zzbEAPlj40MVn+pgr67Rfxc3RwBxNf4fZqnGyRyhfRqtWN7zCD VeKeVCKwdOWGVgXPqgBet8qckxom++yb83NQMAcTX+DubpaoV1 fUfYNlberW6Q+0balXlTjNFYOfASbtiphWU1dnnCI9zEuXhRX5 Cws9NzRBAfJFvli0epRPh38uhfTwox/lydEFYc4x/excdeY7uEFguqfhk/Xl36UeX6SjC46bECBC3WxN+bmqGAH85Gd7NssWjDhKT5ca27Vo f5krxsWWZeMVu6Q2BLwQuhv166638xF8kPC5OlMwXecLVTQ0Qe I/EMMYqb9UgVyrke5F+tK+mFNrEby/eDpWkPC7/60lNke447geBk/OcjvsYUzq+UN+ZKP4awi7h6qYGCPC5MDm1jNGgm0WTk/WjrU1iuXn/SgIwj/JIbxYhZUffGP8aMdwrx4VytL2bjfUxOf1PZcR8YnT/11SJsfjDBBBfFpv5K46l01Ip8CI5TpRjDHckhm2o7RLrUH7TXd uwI4vHllOhTfkc2kKcMf7MnGD3jSOAoBrPfzA2Hj1/FsPA2tSbwP+W4ZvfSYVD8WioVWs+vvB6tTzDNtR2WX4oP+qabK nCeOXfFyiYz0nAJao6QizcR9TZDfURYFBV3rh++Nx5Mh4fSowQ fZ+R8CvBxB8+rb10QnyZ7/Ia5dwHCzCo+5NMoI6jeM2lb7JDhP3oOapLvyuOGKu8U0sElkg8 g6ry41vmHXP4/YTJpYnB3AO+Y3wETQytCFPo2jTdRR1WaDmt1cnLeG2/kdkXxhofS2F2bfUvtdel14ojxio/Kop9Qww5CN1yE6IHQsqJ6HSxG+kJKBC/HsijuyCh9rGw34JCDwC+a/YxlHBWLxnXpn5T4qYp4xhsJU6IR0WAm/KHmzfl/iSCkatnj8AVM+pyI+nnug77Sn2pYjc8EaONeX2pMmoqcUIcNaA 9FX8z5b2V5HkSnz+ywexM9Xa1TPEWyvsUkfE6+BnZU+IvB4yrA rqQasOQMqLbLKIfjXpME+KYau36AtC/Ho50NQpzxuu2oTGRbge7CQr+DeDbsGdQ8BKR8ccJB5I9JT4vZa ywPbXCjubR/9/ppU0y2yG6xOesZVDo3IkpnMY02HXHVOxCrbdTzQ+KfDboLgC+D cvLIr8myXTDs9HlxtRon17DJ+by3JghoL8hoBuVqrQJEdfKeL2 kq0eRUZ2gSLHLIvqxqV81toKl3ldQzd8VWX/OZ7SxMS3bbSheJxv8AsnZdZHzppi6XetFrEjI307YRmEqbUJ8F qD2cuCVnfJLFYJibkScSMYyKL4zu0YK/3EPxe9KOfnuK2fi5V8s6eb9upSzpntz3aSl+pU2ISJOvM9KH02 cpoFAycsjuicU6WsoLPBLA7pc1Z4UwJPNJmRPiXeQ8askdyXe2 VWiofKUNCFW1TL1CfG/hrpIBuh3qwH6bNrl6QuBH4EEXwK+Kct3iHdTopw9f7zuyZMrpW 4s9nGn3LiYJoFVk1CTnE1jDq8IfKDCPu/mI2mAOY8yFFq8uEfhFeq6IdMbWdFS1m02SPehIHxoKw25rBb5D pEnyNWOAWZlQBdT8aM5vxiKxRWjL2lCPAtQWQa8sVOfED9jQCy 0XyZ5bCJ/4LH+XVAokN+LatI/tDDrD3/Ob4x5QsS31TSUReIlizRxBW+7uSXuWqalpAkREbLJEb9x/KUKIjR+/uTEEJ6XsJVg4kfOKwNF5UxYgfC1vk7KdUjOmYD5UfZ/KFdKvCJlJBtPiLeSvXixlAmRLx7biMwXQfGA9lzgP1D+0NaLsd w5LqOxoLg9CiPifwC1vhD4JuwnKIgfkfmuj9zXEPlxO+ctM0/MayQmgZ/ifkT24sVSJsSDAanQWzswT5p9MY2ePzRq3ol8xiCO7tFKQD2Ug F1P5MNAtwL4JiwvkfBP6HImRP2vA5BYRhvzOS/zeEL8D07mcj0EbhQ3fSTWA+8OTOePy4/giJiEcNFlBvPJufAf6WE2nNWo7XFQs+lnU0W7XqxWbe3uHXVts uvNCubaleScvyC/LcVWLUlgv1tmDGID6ufzGbFFuJZyh7gVoHEt8M4uRgA3r6t1s8 UuqzWhR+rVxgEZvu52CNSSeukScB9ctX/HFdiykaVlGdfXzSfW7k6GnF+UbEyxKZGvt9FtleMLMzXYvmz6r TIU/bF0rN+GX5GDT+ZQNVX1ewM58GPJY8G+CfAlsVtTMTuSrOLoFuQ XxoB7ENcPjKupil+E8LpgKu/vkDHnMfjJFJsSn0DG+0kuXixhQjwZUPoh8H2z+qG0dR79Bv3Hv jvsMP/rKBf+VhXP6RPJrxTxJCok50NHoYOK21HvOo6rQPdS4Nuy/KY45+7rgBadPy0jlu8mcybtjG7m2xXXK/Dlio4abXjn0wUix1N+7WtMhNjgNzHqDyx0QFij8vpXp3XZhPWF lr9GWVwzr9et4ZwpYG59y4zyL2Xkwjjlqwj9P1DlDPZDhcfYc8 E2ChbvJkoo+FOJIg5L2JqY3tMkqKCYO6EW3rZkprFsWzpfCr7J ioY2tT4KboOx2wR6zlmfC4RHVfoXs5F+hkKP/K9k5Oblr9Lml8qhDF0w347za3scwAdR6Ik/tqe8faTlC/X6QCd45xgwD6IKraudtlDJmVQRy2QeXLw6UEHO299AeFT1gqil X8OGGen5rnXtjFh3FQTulQNvsRmUV1TY2T9HPoNyWx05OYb2tZ qtfRSNad+hCwz0r3eCVq+15qbbhExn7WPMWGBrNabaTVvUrS8/LLdOvsZrm0MYVycW/S/L6OgE8cXYT2bEFuE69B0iPtLpXkQmfZTqi2zfWF/5Z5H3KdQJb824newliFsmigjd0Y59Yf7UxHirTJ8Gh18FPpe9I DcA/O8BvootdVdDVd2r7UNPiKsLEWYfFBZ43moQcGmsuiESuWtEX6L 6hxVF4TpjhWsx5nUDlfDSSsClKNV3oRp9ymlKqTX1nJy6vQxpa xQq+FUVdjTzefopGp1PI6BbFvD2OuaNPl2uSeiCPeY2vs9JODb GNnrFxGrnNrRe16avtrH6Bcw17hlIyj4qd3nuA102UoXqDOkaJ Zcg3Rsbyqe6XMI8764IRt/3VviiWfeOYuz70eh8GgFcH0md4AcA5OXplFnW1ESSlagA55dID XghGh97+zxUyTsH6gzVovsqbQzW3hJyHFh3G9XJstXepkzLwW1 uzpx49H1LRkcYp/ybM2KLcB3ykVm//Yz+xZhAexTo3gZ8W7a0yaLNePTR6o5AgpzNu4HwzlWH1Myod+l Hk+/mJJcgfoSK+FOS50EMrevWHZfeMTrVRAC/TZ5cEYO+Xb111Bc6mBd5vUMZG+kbZt2bhuMobQxYm/J695+iFWK0mBLvNnTNzOrTVn88gLLxujzUlCwHt7n5dEsZ5kjF o59umq9LV4kjxi6tGzh1vx0IuCo8EOSu3jyn1mf2rypoILve0e s+t9ja4NPFhljdN1CdoW75lxZaZ52ftunvY5eEEhaiQ7y3lZpQ Nr7NjwBC25SuazB2/ZK3erRNEfpV+WKeb4iAsW2+CDDv3POXEXBVAz4r078qn9r1d5d 48pA/tU6CGfnoJIi1Gb9XpH+zW3tGxG/W6i8FxqF3tWMnw1nbc+T4uRyoU77NY6c+PXE+fmssLrUI8+h1F SP0U74unSeOGPukuoFT90PQjqkBhj4mY0wXbxyfSDkxv/Il0E5SBNdl8o8iBX4zEHNmxHeWaqsb21n231dfOB7lQxOY6tsQ 9/Gchsl0X6rlOimRw3ys5V+gxEL1RsJitK0bF8s3CT3f8dRdr0Og v9MBUhtJDszJfAddNE7xconUTdZcE8uhDu6KxJ0Zcp6Rbo9ATc fNqO++uwmdE9ap3IY4n36ZN6F9JAhzxXKgj/I7xhxJr7tAMDZ1F0qh0xWPJNDqInFBw7hY/tQaop7UZ8QCe9TvJ7nxgkrxr4zU8W8VOWLrj5F0nahD4+jiLr+ T4lomuUzicXyaLnQO2nTzW9THkhbJsNbYzwrRR/ldavb3IfHD2Jph03ZDwJTPIYz9s5zAgK9ODJgvxAfCelOF+k/pYoWE1uo4z1USPKv1O93exP2rPC+0twwEx6fjCv0mu+14sQ99e dOUME/sPLBP3S/RVVIUxjatcVJxCFjshMQA+ScCvM2HOvZBxfpidXSpj23VwDqYT/X/BcJoV5Ix171iWyJHn4T9Gf8XfXY449w8+Vn3NlZrn2+Ghq3l0f btDXNo2K/LgblCqdCufF3iuHXrBk7VT3+gjqB9sAEQGH96g3gMwVwhfh107 oHXt3ChflO6AyvqCP1VlKoXSNqfLrhvUZFbzevJoR9IrnErNQa I/VRu80UW6GJwFY5RtwkpvUYO1N/ykLbZPzzpat42hHXtQYl0EkN7Tl8cp4/6TgkEGDDd+pJLR0oA5tE7vaaEeWJ809xVcbuLQ6zPmP4vq5IGc lqITkKxvF3r9bF9g0R/VtO8tIjfEQuD4peH6tOUQrsNdOdFU8J6ua7dJGnKHuuTlw40x7 UxZ9c/jEAToEPYYZ6TQw41dZgnxtdMleWmd8ax/mL6FTV74HgO0zuAsxr0z3mr5BMjfegb9HkjxOL7MLifCI82MGW xp1EezXlxVoY1nfmJYSmY9eeVWLPydYhjTK4TO0mf0C8VmgKR8 zOkVB920lLts1MJGthiE0Wqhldn9MN5YqF6h8G+s5Bj9YxZv5K wtLEcSvqmL0Ni58X6adJyTlvGeCXVrH51iPOZXCd2kj73yKgNJ GubAsGPf7ohNJdCjzQflSRWG7a5uWP+XDf28flI37l3VJhT+Tq 0pzjV2fdoufWlyBI5lA6Tw/RV7fKHIubvn1cRBjbCtUmvL7GaUAzXzZskW4jhL8Q7FvQXSYv9 6fJHFf2+OGAM8lWxk7UjSMo/tSUSnC+2pyrWzQFi4Bz6xneTgD6WI1d/UyC31rBLRF/1xw+4/30CedgnV9YvDrt7SMU+TYyMJ8up+DHbNqSx41i6wIBzoIx95fL 8eHwwjUP7Ob5GUqyHeX08dwogwEAFXLJUuhbGOfXDW5f+Whw53 mL1mxxt7zBDizZ0R6p96DiUsD/jH7bU/9firP1E/dDWnvpyy/oNtX2/sW89gJYJcMw7QC7UK/8xsNVlOQfKOhm3oW9JMOZjfrMayTkG5Y/XiJ+cC6+lKGBdkP7hAgRf78Dq0pXiiLFYU2ibQ9sLL3RHeu5Cs S8I1KLf1rnE49FxzJK4f5PfO8siBurLxqrtN6EG1BsP5lqsxYX aG2tlSDvdJuZQbtXVIY69S4JQVyfHpHwQHOVzXhJUAcW5D6oKE Lv+fprj7qa4twV8yCVLfF8iH9eici7p4z7nyc3R1v+cQA1NxtK 2jiHiY9izXuXcu0TO8duEsz1lNB136AvZ+qzKGXo3sJTq8z/yQCgauNbWWZOiFFExNLlVrSdaHdhuH+gB7cqfEvCpq9L1QM5ns axvsuFcH+s5j+WfVfu6QA26u2AK9DUZJOJvY0Yd8rrEUJcwTnk l1OnOhTakn0fMh3wsL7+UsRhbczTZ2lieyekPDIDdNQj7BvqIr Vnpfj47SdiGato64KsTcBPCvozXPKE7uybf+JbT2hc1KbJljG7 Gvk4Oq6HOH4Bt2WUx4fxnv6www4LbK8yhRouxly74xybgVDq9d kM3I7H133dFksU23X9K/HWtXAlrVt7/NqKAoLfKDMypouuDbpWk3JfK+tvejeU4O2JXn9QtfSinhGRTLM 8LJRPbspMHcoQu/CZ5c2P0A/FMOdbLDZwDfzyPOkEqoY752Jf2w5GP/Itx9kdNFGPUn/SI+yJOt//83YL/fdI+izwwD/P6SMwvGdlH5dMoJ9enPpOnEHB9LfTrBzHUX5XubyrOUuxxoiJs kZnruHrB49XSsm1RcA1FFzlqdOMuCQTwHHxgwQ91zL8hkQtNGH cDGFCvfGyp6I/Exr5dyi+BmpDlPnRJZbIUm6D6BETfBPNJqJLr1LNNIO95dQLBh +u4fsF2OOXWDdK55N/GuYj143+hpMXzrL2grPx3SFfnTp5zaF4lXRaJ2R5ykH9CL/M4po38bOso0OrSD+euM95AqiyV9vFiOZbJUcyTyoelGAbjTaLr m2J3dFzLH2QWErr4TsjIwf2rrMQvWz79sDrrX849C5yzCpyIs6 6T4bnQYesdHeo+R7La9JE2RRivPBLbLgEj2+rKm0uOLeX4pByp GL3pqaJrxIFzVMW0setGcOzvRpFnMQlX1oxFGZ/zZq2ygxoOm4jPxXJY/8cK3wacAyCX5TxEdHXo98TJYqzVOOOt3alOMvDRtRuLtbbqAwb hznaMgJ0DbZXeLQfq+A5RbXeoY4TOFD3GW15zD63Tq4+unXNcH XkvS9xRG3th01H61Wl2FC42PlvPXe08BBMqbog6uu5Tf1vMY6v ze89jAnFaG+dSXV1aXxw5/uS6we7XCwK4L08f23R9Dc/R3SLHlpP05R+SfnljrPHoo/wyOczWpn2jJuuBzpCcXNddoku9zMwp4z8D+bG/OneyOf1l+4bWtLTAeSEE2/jbZHC6ZhIj88NWfVFWPrUmw7k5VmWnYRHQpRg8L1uRrLsdlLaQ A/2Mxz2FpsN2/4eiF/+jd5noF+IftxCmE61+RvWNs/npWmOfZP1wq0tGuS9a9Yvjn+XgXCF5hz4HVTf3+YFi31U3eCR+ IfBNp4/qSLuJYDZs1Qdl5S9XZQ1aLj4cq0sCTsMioB9uPC/bkqzrckZ7CIO+dXiLDbWx+AdDzqLTO7TflEPXDGdBl0onsRr70 Ovm8SLo41IFD1C/leaNeIw5sk1e7xRQMG5lDZB0wRtjjK8R6i4zQMDOh7Z7y4HyZ6 j/2LnEGOPtDo9SrCHuDv3p3deVcpS0Kfq1UJ+Nq8v2dslf3Fzz+s CgRTWX9FYZVZMTamDwWzHNlfq52yWR/l5mCb0dHAG8Hm6m88UTohYb+xkc5mmyHWtwICIF6B0pjq0rfkm kv8HV6wQGPHhRPRawS2C8qZOs6zdIIV+0K3+oHCE/07G/y8MhcEriXIUmRKt0RSTu66LfwJzmqN0vMl67pqva+yX+uXIUd0 cYOkc8mJDPvOkOlwHxuFH+vthDb7xSj01HV+TU/LmL0hLi1CMCj5XceN6R/2KP/c5Dal0W2FkO3X6mOM4N4UWg/FRJ34g9vsbgGa+6curNdo1u3aUnBGLn76s99edpC0eAL4jCyx2 8vA2lAsYsJX9s8Iq9gBQCsXN3fSrIbfOLAF8Q8zvS7kb2UknFu LH8/u6680w9IqCbnPncqbyqxz49dcEI6OIxXhAFl1pcaRtJRRcQfic WV6UXlEIg9pO1O1NBbptfBPRDjROi/rFVJ0dgSgislMHiZ0D506cEgI91TQTwYvAJcU1sXJp/BM6VIeJnQPkl8z9sH2EMgW3E8Fk5dOuIkyMwNQR42UgnRCdHwB FwBCaJwIUyar5DnCQQYxl0aJPwWGr3Oh2B0hHwO8LSz5DX5wg4 AjNDYH3pye8QZwa3d+QIOAKlI4AT4kGlF+v1OQKOgCPQJwK7Sn L9o7D6Z6+cHAFHwBFwBBwBR8ARcAQcAUfAEXAEHAFHwBFwBBwB R8ARcAQcAUfAEXAEHAFHwBFwBBwBR8ARcAQcAUfAEXAEHAFHwB FwBBwBR8ARcAQcAUfAEXAEHAFHwBFwBBwBR8ARcAQcAUfAEXAE HAFHwBFwBBwBR8ARcAQcAUfAEXAEHAFHwBFwBBwBR8ARcAQcAU fAEXAEHAFHwBFwBBwBR8ARSCDw/62wrqSsIOrzAAAAAElFTkSuQmCC
    and the image
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	4049840040.png 
Views:	66 
Size:	6.5 KB 
ID:	14322  
    Michael Mullan.
    Danes Bridge Enterprises.

    ++++++++++++++++++++++++++++
    There is just today. Tomorrow is a concept
    that is mostly theoretical. -- GM Wylie
    ++++++++++++++++++++++++++++

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •