Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Parameter to select a OLE signature

Status
Not open for further replies.

mart10

MIS
Nov 2, 2007
394
GB
I am using CR10

I have a parameter that selects from a list of authorised signatures on a letter



eg Authorised Signatory
Joe Bloggs

It would be nice if we could scan the signatorys into an OLE object and store on the server (we cant store in the database unfortunately) How can I get the correct OLE object to appear depending upon paramater selected
 
If the list is small, then you might consider having all the OLE's on the report and just show the correct one depending on the parameter.

I hope this helps.
 
There is a list of say 6 names

by showing how would I do this? In say selection crteria and then parameter dependent? The trouble is though I have 2 sigs side by side so need 2 sigs in one detail line

There must be a better way
 
If you do not have the name (OLE's) in a DB, it makes it a lot harder. You should be able to format the OLE object (right click on the object). Put a formula in for the Suppress (remember when it evaluates to true, the object will be hidden). I would think you would have something like {?parameter} <> "Joe Bloggs". Since you need two sigs side by side, then you would have to do this for all the OLE's and overlay them.

I hope this helps.
 
You can insert additional sections, e.g., detail_a to detail_f. Position the signatures in the section as you wish, and then conditionally suppress the sections. Let's say you want the following to display:

Jane Smith John Brown

Format the section with:

not(
"Jane Smith" in {?Signatures} and
"John Brown" in {?Signatures}
)

...where {?Signatures is a multiple value string parameter that uses the signature names as the picklist.

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top