Get a Jumpstart with our Sample Apps
Results 1 to 20 of 20

Thread: Ink-Databound control on a report

  1. #1
    Member
    Real Name
    Alan M Neiss
    Join Date
    Jun 2016
    Posts
    28

    Default Ink-Databound control on a report

    Is it possible to use an formview Ink-Databound control with it's data stored in a sql server varchar(MAX) field and use it on a report to be displayed as HTML-Paged? I'm not seeing data in the report.

    Thanks

  2. #2
    "Certified" Alphaholic
    Real Name
    David Kates
    Join Date
    Apr 2008
    Location
    Unionville, ON
    Posts
    6,178

    Default Re: Ink-Databound control on a report

    You need to "convert" the table "Ink" data in the Report Source. Right-click your report and choose DataSource, Edit DataSource definition. Then click Ok and Next.

    You should now see an option named "Advanced Options"... click this and turn on Override field definitions of selected fields and then click the button that appears... "Field Definitions".

    Find your Ink field and double-click it. Change it's Data type to Ink Image.

    That should be it... but... you'll have to report back about what you see.

  3. #3
    Member
    Real Name
    Alan M Neiss
    Join Date
    Jun 2016
    Posts
    28

    Default Re: Ink-Databound control on a report

    Hi David,

    I did as suggested but I'm still am not able to see the signatures on the reports.
    InkCapture.PNG

  4. #4
    Member
    Real Name
    Alan M Neiss
    Join Date
    Jun 2016
    Posts
    28

    Default Re: Ink-Databound control on a report

    I created a new report that should display a single signature field. As you can see from the attached images for some reason converting to an Ink Image is not working for me.

    MemoCapture.PNGInkImageCapture.PNG

  5. #5
    "Certified" Alphaholic
    Real Name
    David Kates
    Join Date
    Apr 2008
    Location
    Unionville, ON
    Posts
    6,178

    Default Re: Ink-Databound control on a report

    My Ink Image data is being converted. What Alpha version/build are you working with? If you could post your Test report and a sample table I'd have a look.

  6. #6
    Member
    Real Name
    Alan M Neiss
    Join Date
    Jun 2016
    Posts
    28

    Default Re: Ink-Databound control on a report

    Hi David,

    I'm using Build 4246 4859. I've attached the report and a txt file to create the table. I'm not sure if this is exactly what's need so please let me know.
    Attached Files Attached Files

  7. #7
    "Certified" Alphaholic
    Real Name
    David Kates
    Join Date
    Apr 2008
    Location
    Unionville, ON
    Posts
    6,178

    Default Re: Ink-Databound control on a report

    I see that you're using a Table Layout Report. I wouldn't... they're way too hard to work with... designed more for working with Excel. Try the attached Free-Form report.

    You can confirm what I'm seeing. Under Print Preview the signature is cut-off most of the time. And, when run as an HTML-Paged report the Ink actually changes... with a straight line drawn from the beginning of the ink... to the end... or something like that.
    Attached Files Attached Files

  8. #8
    Member
    Real Name
    Alan M Neiss
    Join Date
    Jun 2016
    Posts
    28

    Default Re: Ink-Databound control on a report

    Sorry Dave but I'm not seeing it. Here's a screencast https://www.screencast.com/t/b3EjIKv9B3

  9. #9
    "Certified" Alphaholic
    Real Name
    David Kates
    Join Date
    Apr 2008
    Location
    Unionville, ON
    Posts
    6,178

    Default Re: Ink-Databound control on a report

    Sorry... I forgot to say I changed the Alpha DAO Connection string... to mine. Did you change it back to yours?

    I see... now that I've watched your screencast.
    Last edited by Davidk; 04-26-2017 at 04:55 PM.

  10. #10
    "Certified" Alphaholic
    Real Name
    David Kates
    Join Date
    Apr 2008
    Location
    Unionville, ON
    Posts
    6,178

    Default Re: Ink-Databound control on a report

    I wonder if it's a control size thing. Here's my screencast...

    https://youtu.be/M2fmnoAa7rA

    I've done this in 4119, 4254, and 4292

  11. #11
    Member
    Real Name
    Alan M Neiss
    Join Date
    Jun 2016
    Posts
    28

    Default Re: Ink-Databound control on a report

    Yes I did change it back to the sql server database. I'm going to test it with an access db just to see if it works.

  12. #12
    Member
    Real Name
    Lee Vasic
    Join Date
    May 2010
    Location
    Salt Lake City
    Posts
    984

    Default Re: Ink-Databound control on a report

    Is there a way to Size the ink Signature? I can't seem to size it within a report.

  13. #13
    "Certified" Alphaholic iRadiate's Avatar
    Real Name
    Stephen
    Join Date
    Jan 2011
    Location
    London, ON
    Posts
    1,364

    Default Re: Ink-Databound control on a report

    Quote Originally Posted by lvasic View Post
    Is there a way to Size the ink Signature? I can't seem to size it within a report.
    Lee, try manually setting the size of the control to what you want on the report, then right-click on the control and select size to fit. This seemed to work for me.

    SizeToFit.jpg
    Alpha Anywhere v4.5.1 Build 4642-4981 IIS v8.5

  14. #14
    Member
    Real Name
    Lee Vasic
    Join Date
    May 2010
    Location
    Salt Lake City
    Posts
    984

    Default Re: Ink-Databound control on a report

    In the list control, we can size the ink signature. I don't know how in the report. Nothing I've tried seems to work. If anyone has any ideas of what I'm doing wrong...
    See pics:

    ipad.PNGList.PNGReport.PNG

  15. #15
    "Certified" Alphaholic iRadiate's Avatar
    Real Name
    Stephen
    Join Date
    Jan 2011
    Location
    London, ON
    Posts
    1,364

    Default Re: Ink-Databound control on a report

    Did you try the size to fit option like I suggested? It worked for me.

    Signature.png
    Alpha Anywhere v4.5.1 Build 4642-4981 IIS v8.5

  16. #16
    Member
    Real Name
    Lee Vasic
    Join Date
    May 2010
    Location
    Salt Lake City
    Posts
    984

    Default Re: Ink-Databound control on a report

    Yes. It made the textbox 8.5 wide, but still cut off the top.

  17. #17
    "Certified" Alphaholic iRadiate's Avatar
    Real Name
    Stephen
    Join Date
    Jan 2011
    Location
    London, ON
    Posts
    1,364

    Default Re: Ink-Databound control on a report

    For me, the ink was initially cutoff when I first placed the control. I had to make the control huge to see the ink. But after using the size to fit I could at least see it when I resized it to something more reasonable.
    Like you, I'm not seeing a better way to control the size.

    Anyone else?
    Alpha Anywhere v4.5.1 Build 4642-4981 IIS v8.5

  18. #18
    Member
    Real Name
    Lee Vasic
    Join Date
    May 2010
    Location
    Salt Lake City
    Posts
    984

    Default Re: Ink-Databound control on a report

    Ok. I changed a couple of settings in the ink control. I set the ink control to scale by width. In the report, the width of the text box controls the size. I made the text box very narrow and it made it the correct size. I also turned off the Grow and Shrink flags.

    Pics: InkControl.PNGListBuilderFields.PNGReportSample.PNG

    *Edit - I've had this working for several years using the png file. However, in the long run, I think this is the better option.

  19. #19
    "Certified" Alphaholic
    Real Name
    David Kates
    Join Date
    Apr 2008
    Location
    Unionville, ON
    Posts
    6,178

    Default Re: Ink-Databound control on a report

    Thanks for posting your solution. I sometimes feel the solution lies in a mix and max settings scenario. You need to have the right combination of several settings to get the effect you want.

    This is great.

  20. #20
    "Certified" Alphaholic iRadiate's Avatar
    Real Name
    Stephen
    Join Date
    Jan 2011
    Location
    London, ON
    Posts
    1,364

    Default Re: Ink-Databound control on a report

    Thank you Lee .. great info!!!
    Alpha Anywhere v4.5.1 Build 4642-4981 IIS v8.5

Similar Threads

  1. Viewbox Image-Databound
    By jhaytko in forum Mobile & Browser Applications
    Replies: 0
    Last Post: 03-09-2017, 05:01 PM
  2. List Detail view - How to remove databound image(blob)
    By davidhs in forum Mobile & Browser Applications
    Replies: 2
    Last Post: 01-31-2017, 12:18 PM
  3. databound Dialog: GetValue showing value of last edited record instead of new one
    By jhguru in forum Application Server Version 11 - Web/Browser Applications
    Replies: 3
    Last Post: 06-20-2014, 06:21 AM
  4. List Control Databound Checkbox
    By Davidk in forum Mobile & Browser Applications
    Replies: 0
    Last Post: 01-28-2014, 12:07 PM
  5. REPORT/CONTROL PANEL
    By deputy956 in forum Alpha Five Version 4
    Replies: 1
    Last Post: 01-01-2003, 05:28 PM

Posting Permissions

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