Crystal Developer v8.5
SQL Server 2000
Windows XP
Is there a simple way of adding the number of rows in a given table to a report, where that table is linked to the main table by a single field?
Effectively i want the result of [select count(*) from table2 where table2.linkfield = table1.linkfield] in a field on each row of my report.
Let me know if this does not make sense. Basically i need the count of a number of rows in a linked table returned to my main report for every row in the main report.
Thanks in advance.
SQL Server 2000
Windows XP
Is there a simple way of adding the number of rows in a given table to a report, where that table is linked to the main table by a single field?
Effectively i want the result of [select count(*) from table2 where table2.linkfield = table1.linkfield] in a field on each row of my report.
Let me know if this does not make sense. Basically i need the count of a number of rows in a linked table returned to my main report for every row in the main report.
Thanks in advance.