How do I treat 2 fields as 1? 1

[9eagles]

I am creating reports for server event logs using the data source "NT Current Event Log"listed under "More Data Sources."

My problem is that I need to create a report for about 8 servers, so I will have 8 datasources. Crystal aliases the data fields after the first connection (as expected).
However, I want to treat all of the fields as if they were a single source. For example, I want to list, count, and sort all of field1 on Server A and Server B in a single report as if they were the same server. I cannot do that because on Server B it is called field1_1.

Any idea on how to combine the fields as one?
TIA

 

[lyanch]

You can create a separate subreport (that looks like your main report now) for each individual server and combine them on an essentially blank main report.

Lisa