Dave Stone
asked on
Crystal Reports 9 Find Bracketed Items
Hello,
I am attempting to write a report in Crystal 9 that will show all items that are enclosed in brackets, ([ ]) in a memo field. I find that when I try to use Select Expert that the field is not available. I then tried to write a formula with no success. I thought this would be simple as it is only one table that I am looking at.
Perhaps it would be helpful if I gave the purpose. We create standard work for items that we manufacture. The items call for specific specifications. We enclose these specification call outs in brackets which lets the system know to look in the specification library and automatically assign it the latest revision. I need to get a list of all these specifications that have been enclosed in brackets. ANY help with this would be most helpful.
Thank you
I am attempting to write a report in Crystal 9 that will show all items that are enclosed in brackets, ([ ]) in a memo field. I find that when I try to use Select Expert that the field is not available. I then tried to write a formula with no success. I thought this would be simple as it is only one table that I am looking at.
Perhaps it would be helpful if I gave the purpose. We create standard work for items that we manufacture. The items call for specific specifications. We enclose these specification call outs in brackets which lets the system know to look in the specification library and automatically assign it the latest revision. I need to get a list of all these specifications that have been enclosed in brackets. ANY help with this would be most helpful.
Thank you
What is the type of the field - text, memo ?
ASKER
"Show Field Type" says Memo
That is why it is not working with the formulas. Most likely the database field is of type text. I would create a view and convert the text field. The available types will depend on your database. In SQLServer the corresponding type will be varchar(max length). Then use the view in your report and the field will be available.
ASKER
The database is visual FoxPro.
Crystal cannot use memo fields in formulas.
How long can the memo fields be?
Are most less than say 1000 or 2000 characters?
You could write a view that extracts the [ ] text from the field
mlmcc
How long can the memo fields be?
Are most less than say 1000 or 2000 characters?
You could write a view that extracts the [ ] text from the field
mlmcc
ASKER
Yes, less than 1000. I don't know how to write a view.
In FoxPro view is probably named query
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You can try also to create a SQLExpression convert the field inside.