Report document needs diverse signatures

[GeoCard]

I have created some reports that look like documents, ( a whole lot of them) they print the client information quite well and the client just has to read them and sign them.

These documents need signatures.

Some need the signature of the president of the company
(This was easy to do, I just created a digital bmp image of the signature and placed it in the report as an image)

however others also need the signature of the case manager of the client.

I have all the digital (BMP pictures) of the Case Mangers.

I need to find a way to include the correct signature of the Case Manger for each client.

All the information for these reports (Documents) come from a form.
and yes the form has a field that states who is the case manager for each client.

[DonRayner]

I have created some reports that look like documents, ( a whole lot of them) they print the client information quite well and the client just has to read them and sign them.

These documents need signatures.

Some need the signature of the president of the company
(This was easy to do, I just created a digital bmp image of the signature and placed it in the report as an image)

however others also need the signature of the case manager of the client.

I have all the digital (BMP pictures) of the Case Mangers.

I need to find a way to include the correct signature of the Case Manger for each client.

All the information for these reports (Documents) come from a form.
and yes the form has a field that states who is the case manager for each client.

I can't guarantee that I'm right on this because I havn't done it before but... You could look into adding the signature image as a link instead of embeding it in the report. Then using the reports on open event set the link properties based on the value for the case manager.

[missinglinq]

Moderator's Note:

GeoCard posted this by hitting "Report Post" rather than hitting "Reply."

So far I am thinking of creating a text field in the case managers table that has a link to the actual bmp image files

[Bugran]

I hope this may help you some.

Due to the large number of reports (letters) where some have signatures and some don't, I came up with the following solution:

#1 The bmp signatures are created and put into their own report (all by themselves).

#2 Each letter has a subreport - sigs - attached to it. All the subreports with the bmp signatures are included inside - sigs - (so as not to populate ALL the different letters with thier own bmps). This technic also makes it extremely easy to edit/add/delete signatures from ALL letters since a single subreport has them all. It also keeps the size of the DB at a minimum

#3 Users select a signature from the form - ReportValues - where they are running the report/letter from. The printed name of the signature along with titles are created from that selection and a number is assigned to a global variable - glSigNbr - and that is used to unhide the subreport containing the correct bmp signature. (I use an options set for signature selection and the options value becomes the glSigNbr.)

#5 When -sigs- loads, the printed signature is obtained from the originating form and the global var determines which subreport to unhide (if any).

Below is the simple code to unhide the subreport with the correct bmp:

***** BEGIN CODE

Private Sub Report_Open(Cancel As Integer)

' ** Subreports nested in the signature subreport
Me.sig_sbia.Visible = False
Me.sig_blas.Visible = False
Me.sig_nice.Visible = False
Me.sig_rlco.Visible = False
Me.sig_jgut.Visible = False

Me.SigBlock = Forms![frmReportValues]![SigBlock]

Select Case glSigNbr

Case Is = 2
Me.sig_blas.Visible = True
Case Is = 3
Me.sig_nice.Visible = True
Case Is = 7
Me.sig_rlco.Visible = True
Case Is = 8
Me.Sig_sbia.Visible = True
Case Is = 12
Me.sig_jgut.Visible = True
End Select


End Sub

*** END CODE

I'm sure that some variation of this will work for you. This actually works well without increasing the size of the DB substantially.

Gary