How can I count the total records for multiple tables and display the results? When I try to create a calculated field i get the count of the first table but the second one always comes out as the same number as the first table.
Any Ideas?
Printable View
How can I count the total records for multiple tables and display the results? When I try to create a calculated field i get the count of the first table but the second one always comes out as the same number as the first table.
Any Ideas?
with out having a link between two tables you cannot create a report in Crystal. So deff. it will display the count value of result set of the two tables.
I think u cannot get two valus for two diff. tables.
Cheers
Try using the recordcount property, assign it to a variable, add the two variables.