We are using crystal V10 running against Maximo v4.3 on an Oracle Db. We need to find out how many pieces of equipment are being maintained in our PM system. Currently we retrieve this data from two different queries that are referencing two different tables, i.e. the PM table and the Route table. The resulting data includes some duplication. In Crystal how do we do a distinct count on the resulting data.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Distinctcount on two tables
- Thread starter saltcoats
- Start date
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question