Combine Test Result 1, Test Result 2 from output in Crystal Reports

[CrystalUser2012]

Hi,

I have a CSV output from a bit of equipment which everytime it does the next test creates a new line for that equipment and each Test. e.g
Name Test 1 Result Test 2 Result Test Result 3 etc....

Machine 1 55 NULL
Machine 2 30 NULL
Machine 2 NULL 40
Machine 3 34 NULL
Machine 4 NULL 22
Machine 4 45 NULL

I basically want to combine the results from each test onto one line in my Crystal report. so the output looks like this:

Name Test 1 Result Test 2 Result Test Result 3 etc....

Machine 1 55 NULL
Machine 2 30 40
Machine 3 34 NULL
Machine 4 45 22


Any ideas how I can do this? Unfortunately my report shows the data just as it comes out of the CSV at the moment.

Any help would be appreciated! Thanks

 

[MCuthill]

CrystalUser2012,

At a glance, I think you could create a group and some field summarization to achieve the desired output. If you have a datafield for each "Test # Result", the report simply needs a group added for {Table.Name} and each field summarized as a "Maximum" on each Machine Name. As Nulls should be deemed the lowest of all values, they should only appear where only a Null score exists for a particular score result. You would then Suppress the Details Section of the report, leaving only the Machine Name group level visible.

If you do not have a datafield for each Test Result, please advise and I can provide an alternative solution.

Hope this helps! Cheers!

Mike
---------------------------------------------------------------
"To be alive is to revel in the moments, in the sunrise and the sunset, in the sudden and brief episodes of love and adventure,
in the hours of companionship. It is, most of all, to never be paralyzed by your fears of a future that no one can foretell."