combine results from two fields into one

[writeright]

I have a report that shows the names of two people

person_1 and person_2.

person_1 always has a record but person_2 does not (person_2 is populated by a formula).

I am trying to create a subreport that shows a list of all of the unique people on the report (so a unique grouping of all person_1 and person_2 listings) but it must do it as one sorted list. I can't find a formula to accoomplish this.

thanks for any help

 

[dgillz]

Create a simple SQL Command:

SELECT DISTINCT {PersonField}
FROM {YourTable}

Use an appropriate WHERE clause if applicable.

Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports. Check out our Macola tools:

http://www.gainfocus.biz/exceladdin.html

 

[writeright]

that would bypass the formula i use to create the field.

 

[northw]

You can try using isnull() function.

 

[lbass]

You need to show us the exact content of the formula {@person_2}. You should also identify the table containing person_1. Right now we can't even tell whether the two are derived from the same field or from separate ones.

-LB