I have a crystal report that I am trying to make. Data is coming from a SQL database.
I have a table for all of the tests performed on a product.
Test1 Name, Test1 Min Value, Test1 Max Value
Test2 Name, Test2 Min Value, Test2 Max Value
(repeated 25 times)
Then I have a table that outlines the Test Method information
Test Name, Reported Name, Test Method Number
I need the first table to connect to the second table for each test number so that I can pull the Reported Name, Test Method Number, Min Value and Max Value for each Test (all 25).
The Test Name in the first table is what matches the Test Name in the second table.
I have tried a left outer join but I get blank results as soon as I try to join Test2 to the TestName on the 2nd table. Do I have to do a view i SQL to achieve these results? I tried a subpreport as well and did not get that to work.
What am I missing here? I know this has to be possible somehow.