I have a report which contains a field with the following type of text:
I need to link the number that appears after warehouse/ ie "800000661" to another table. Is there any way I can do this without creating a subreport?
I have thought that I could create a formula to extract the number then link via subreport, but it would be much easier if I could link this within the same report.
Any help or ideas would be much appreciated!!