Search results for query: *

Worked perfectly! Thanks!

I would like to hide a group when a field in the same group/row is zero. Any thoughts on the most efficient way to do this? Thanks, BMB

Pete: All filepaths will be as follows: Q:\PRINTS\'customername'\'customerpart' rev 'n'\'customerpart' rev 'n'.pdf All items in 'field value' are attributes from a table. Example: Q:\PRINTS\LEXICAR\00849-01 REV A\00849-01 Rev A.pdf Would you be able to assist with a formula? Thanks, BMB

Kray4660: I need this to be done automatically. We have thousands of links. So I need a formula to make the field to be an executable link to a file. I see where this can be done. I just don't know how to write the formula. Any thoughts on how to do this?

Pete: The CR formula worked perfectly, thanks! One last question. Now that the attachment paths are showing in the SubReport, I need the filepath to be an executable link. Example: Q:\PRINTS\CUSTOMER_NAME\00108-01 REV C\00108-01 REV C.pdf Do you happen to know the CR formula I can use for...

Problem: I need to convert character types and then link a SubReport via the new character type. Example: Job_Operation.Job_Operation (number) and Attachment.Owner_ID (string) I have attempted to use the SQL Expression as follows: {fn CONVERT('job_operation.job.operation',SQL_varchar)}. Then...