Table a contains customer information. Table B contains complaints submitted by customers. Table C contains positive feedback submitted by customer.
You are tasked to write a report that list all rows in Table A where, per customer, the number of rows in Table B related to Table A are greater than the number of rows in Table C related to table A.
Which method creates the report that executes with the best performance?
- Define two subreports: one that counts rows in Table B relative to Table A, and on that counts the rows in table C relative to Table Only include rows in the main. Report against table A where the table B count is greater that the Table C count.
- Join table A to Table B and C using include all rows in this class. Count the Join column from both Table B and Table C. Only include rows where the first count is greater than the second.
- Join table A to Table B and C using include all rows in join class. Count the Join column from both Table B and Table Only include rows where the first count is greater than the second.
- Define two subreports, one where table B users ''Do not Join'', and one where Table C users ''Do not Join'', In the main report count the rows from each subpreport, then only include rows where the count from the Table B subreport than the count from the Table C subreport.