Referring to external Lookup table 1

[mgpeters]

I am working with CR/CE10 with an Oracle db (direct connect).

There is a text field in my db (FOLDERNAME) that this is a free-text field. For a given FOLDERNAME to be valid, however, it must begin with a valid folder prefix. The valid folder prefixes are NOT stored in the Oracle db but I do have them stored in an MS-Access db.

I want to report on invalid FOLDERNAMEs by using the following logic:

If FOLDERNAME starts with any value in the list of Folder Prefixes, Then OK Else Error

Does anybody have any suggestions on how to do this?

Thanks, Mark

 

[IdoMillet]

You can use a subreport to load the list of all valid folders into a shared string array. Place the subreport in the Report Header.

Then use that variable in the main report.

- Ido

view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[mgpeters]

Please forgive my ignorance, but I've never worked with shared string arrays. Can you please give me a little guidance in how I would use these?

Thanks

 

[mgpeters]

Nevermind - I poked around and figured it out.

Thanks for the help.