Formula for retrieving different data from same data field 1

[beechgirl]

I have a table that has a dump of different objects; they each start with unique description; however, I do not know how to write the formula. Example MR12345, WO12345, CN12345.

 

[lbass]

You haven't explained what you want the formula to do.

-LB

 

[Madawc]

If you want to collect a set of values and print them at the end, this can be done with variables. If that's it, say so and I'll post you a solution that you should be able to adapt.

Madawc Williams (East Anglia, UK). Using Crystal 11.5 with SQL and Windows XP

 

[beechgirl]

I would like to show all objects that begin with MR in one column, show all objects that begin with WO in second column, show all objects that begin with CN in a third column.

 

[Turkbear]

Hi,
create 3 formulas ( assuming data is in one field)

@WOStart
If left(Table.Field,2) = "WO"
Then
{Table.Field}
else
""

@MNStart
If left(Table.Field,2) = "MN"
Then
{Table.Field}
else
""

@CNstart
If left(Table.Field,2) = "CN"
Then
{Table.Field}
else
""


Place these in your report's detail section instead of the actual field from the database



To Paraphrase:"The Help you get is proportional to the Help you give.."