I've joined two tables from SQL Server but now I only have 1 Number of Records variable for one of the tables.
Is there a way to get the other Number of Records variable for the other table or to derive a calculated field simply counting the rows in the other table?
If you joined them in SQL the result would also have one number for count of records. If they are joined, you only have one table. If there is an identifier you could count that reflects information from each table, then maybe you could count distinct this.