Linking tables in Crystal Reports for VS 2005
Posted on 2011-05-03
I have a lot of experience using Crystal in VS 2005, but this is the first time trying to link tables for a report. I have two tables, table1 has an integer field that links to an integer field in table2. These aren't set as PK/FK in the dataset, but the relationship is a one to many.
I have the join set as =, because I only want to display the items in table1 and corresponding table2 data where they are equal...there could be chances were table1 doesn't have a matching record in table2.
When I try to run the report...I get a gray screen(blank) and my cpu clocks aty about 50%. I have to right click the form with the report viewer to even close it and the main app I have to kill as well.