Using a view, based on a field's value, concatenating data from 2 separate documents
Posted on 2007-12-04
I current am in charge of maintaining an old Lotus Notes database. My clients are looking to pull data into crystal reports (which the report is already finished). However, when I use a view as the setup for crystal, I can't seem to get the information I'm looking for. Example, this database tracks testing information for various product types. With on product type, it has the possibility of 2 types of tests. TestType is Regular or is Modified. Now a Regular test with a ID# of 07125 has a Capacity of 115 or 230/208. With the Modified with a ID# of 07125 it has a capacity of 115, or 230/230 or 208/208. Now, what I would like to do is
1) combine the data from the Regular and Modified so capacities would be 115/115 for that ID# 07125
2) combine the data from the Modified so capacities would be 230/208 for that ID# 07125
Having the end result being single rows in the view instead of separated out (Regular 1st line, then Modified 2nd line for ID#07125 then Regular 3rd line, then Modified 4th line for ID#07126, and so on). I'm fairly new to this environment, and would really appreciate any help on this topic. Thank you!