Sage 100

 View Only
  • 1.  I have created a Crystal Report for listing the sa

    Posted 09-08-2016 12:45
    I have created a Crystal Report for listing the sales orders from a salesperson. We have ScanForce Sales Automation, so we capture the signature of the customer. In the report, I am trying to print the signature....I only am able to print the path. How do I go about printing the actual jpg file....not the path???? I tried playing around with importing the item photo....not successful. Thanks, Lourdes


  • 2.  RE: I have created a Crystal Report for listing the sa

    Posted 09-08-2016 12:48
    Did Scanforce supply any report that displays the signature? If so, maybe you can take a look and reverse engineer? Sorry, but I am otherwise clueless.


  • 3.  RE: I have created a Crystal Report for listing the sa

    Posted 09-08-2016 12:50
    nope....they said the udf is in the file...good luck!!!! I have look at various crystal report forums...


  • 4.  RE: I have created a Crystal Report for listing the sa

    Posted 09-08-2016 12:50
    I will ask again....maybe since the last time I requested it...they have decipher it


  • 5.  RE: I have created a Crystal Report for listing the sa

    Posted 09-08-2016 13:09
    Googled and found this but haven't tried it: Crystal Reports XI and later If you have CR XI or above, the following steps will display a dynamic image when the database stores a reference to a separate image file: Use Insert Picture to insert a static image into the report, as described above. Select any image file. Drop it in the report at the point where you want the final image to appear. Right-click on the image, choose Format Graphic, and go to the Picture tab. Click the conditional formatting button (the ""X-2"" button) adjacent to Graphic Location label. You are now in the formula editor. Create a formula that returns the filename or URL of the image you want to display (typically, the formula will simply return the contents of the field in the database that holds the filename or URL). Come out of the formula editor. Refresh the report. You should now see all the images at the appropriate points in the report. Unfortunately, this technique won't work in earlier versions of the CR. Versions before XI don't offer a direct way of showing a picture when the database only contains the filename or URL.


  • 6.  RE: I have created a Crystal Report for listing the sa

    Posted 09-08-2016 13:16
    i believe I tried all that...but need to verify if I was using the correct version of CR


  • 7.  RE: I have created a Crystal Report for listing the sa

    Posted 09-08-2016 16:47
    I have got this to work BUT I have found that it depends on where the image is stored. I had a client using Terminal Services and I could never get it to work that way unless the image was on a local drive. Another client who does not use TS is able to use this (we print a PDF with a WO - the PDF is stored in an Item Memo code) with the PDFs stored on the server just fine.


  • 8.  RE: I have created a Crystal Report for listing the sa

    Posted 09-11-2016 06:13
    I guess I needed quiet time to get this to work...On a quiet Sunday morning... Thanks Therese....