PDA

View Full Version : Ink-Databound control on a report


ABC123

neissam
04-25-2017, 01:22 PM
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

Davidk
04-25-2017, 06:26 PM
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.

neissam
04-26-2017, 08:43 AM
Hi David,

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

neissam
04-26-2017, 10:48 AM
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.

4338443385

Davidk
04-26-2017, 11:24 AM
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.

neissam
04-26-2017, 12:26 PM
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.

Davidk
04-26-2017, 01:40 PM
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.

neissam
04-26-2017, 03:05 PM
Sorry Dave but I'm not seeing it. Here's a screencast https://www.screencast.com/t/b3EjIKv9B3

Davidk
04-26-2017, 04:12 PM
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.

Davidk
04-26-2017, 04:59 PM
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

neissam
04-27-2017, 07:42 AM
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.

lvasic
07-17-2017, 07:36 PM
Is there a way to Size the ink Signature? I can't seem to size it within a report.

iRadiate
07-17-2017, 10:04 PM
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.

43731

lvasic
07-18-2017, 02:09 PM
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:

437344373543736

iRadiate
07-18-2017, 02:17 PM
Did you try the size to fit option like I suggested? It worked for me.

43737

lvasic
07-18-2017, 02:27 PM
Yes. It made the textbox 8.5 wide, but still cut off the top.

iRadiate
07-18-2017, 02:45 PM
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?

lvasic
07-18-2017, 05:33 PM
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: 437394374043741

*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.

Davidk
07-18-2017, 06:34 PM
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.

iRadiate
07-19-2017, 10:56 AM
Thank you Lee .. great info!!!