1. you can do a count on your group records and add a select statement count(table.field,groupfield)>1 ...this has to go in the group select expert section.
2. you can use an if-then -else-if statment to create single wording... Probably use an instr function but you have to have the logic work for all of your naming conventions and go thru every version if then per word you want grouped on.
it will be something like:
if instr({probsummarym1.brief.description},"Process H1 is down on qdvp14")>0 then "Process Down" else
if instr({probsummarym1.brief.description},"shine127 IS DOWN")>0 then "Server Down" else
if instr({probsummarym1.brief.description},"Instrument is down")>0 then "Instrument Issue" else ...
Edited by DBlank - 30 May 2009 at 7:50pm
IP Logged
