Using The Same Image Field 3 Times In a Report

[mark1110]

Hi,

I am using CR 8.5. I have an existing report that has a signature image that it gets from a sybase table. The users now want three signatures across instead of one. I am not sure how to do that. The table name is signature, the image I use is s_image, the name field is s_name. I am passing a parameter to the report called signature1. In the selection formula record I have {?Pm-@SIGNATURE1} = {signature.s_name}.

I have tried several things that didn't work. I am sure this is not brain surgery. Has anyone done this before and could tell me how to do it.

Mark

 

[lbass]

Why not add the image three times in the subreport? It sounds like you want them aligned in one row.

-LB

 

[mark1110]

The problem I am having is if I put the three images side by side how do I reference them? I would like to pass 3 parameters but how can I tell CR to use param1 = image1, param2 = image2, and param3 = image3 since they are all from the same field of the same table? I tried adding the same table three times by using alias's table1, table2, and table3, but when I ran it in CR it gave me an error message saying it couldn't find table2 or table3.

I am now trying to make 3 subreports which works in CR but I am running into another problem in VB6. Here is the code I am using:

.SubreportToChange = "Signature.rpt"
DoEvents
.Connect = sConnect
DoEvents
.SubreportToChange = "Signature2"
.Formulas(7) = "SIGN2='" + sSignature2 + "'"
DoEvents
.Connect = sConnect
DoEvents
.SubreportToChange = "Signature3"
.Formulas(8) = "SIGN3='" + sSignature3 + "'"
DoEvents
.Connect = sConnect
DoEvents

When I run it, I get an error message stating that it cannot find the subreports signature2 or signature3. The report was originally done many years ago with just signature.rpt and it runs fine. It is just when I am trying to add signature2 or signature3 is where I am getting the error message.

HELP!!!!




Mark

 

[Madawc]

Just what output do you want?

If the rules is "at least one signature, but any combination of the three including all three", then I'd place the various combinations in sepatate sections and use Crystal's simple and reliable section-suppression software. (Right-click on a section and choose Section Expert. Then choose the formula icon (x+2 and a pencil) for suppression.)

Madawc Williams (East Anglia, UK). Using Crystal 10 & 11.5 with Windows XP