Hi there
I want to place, anywhere in my report, a simple statement that shows the first and last values from a particular report, based on the order they are included in the report.
I cannot use minimum/maximum for this, as the value in the fiel...
Hi there
I want to replace certain strings in a field with an italicised alternative. I've got the Italics working, but it seems that Crystal doesn't want to do it more than once per record.
I am attaching a screenshot of the formula I'm ...
Hi there
Here is an example of a line of text: Bio-synthetic valve, c. 1995-2001
In the above statement, I want to replace the short dash that appears between the years, but not the one that appears in the conjoined word. Is there a w...
Hi there
I need to extract the text from between two specific strings in a field.
For example, the field may look like this:
#Metalwork - Enamel#Cabinet 4 Shelf 2###This is the label text I want to extract.####
I want ...
Hi there
I have inserted a subreport that pulls in data from another module of the database. One of the field sets I need to include involves multi value fields and these fields are being repeated. I have linked the subreport back to the main modul...
Problem solved! I just tagged the requested strings with HTML italic tags and formatted the field as HTML.... et voila!
This is not ideal under normal circumstances, because we wouldn't want HTML tags in our normal data, but this data is for a spec...
Another note:
One thing I am about to try is to simply replace all the relevant values in the data with HTML italics tags, with the field set to HTML format... hopefully that will do away with the whole formula problem altogether.. watch this space...
Hi there Ian
An example of the entered field content is:
Bio-synthetic valve, c. 1995-2001
I need the dash between the numerical values (ie. between 1995 and 2001) to be an em dash, so I figured the simplest way to do that would be to ask Cryst...
Hi there Dell,
That is beyond my knowledge. The database is a proprietary museum collection database, so I can't change the way it is configured, I can only set up a report to extract the information I need.
Thank you so much for all your assi...