Counting Records in Crystal Reports 1

[chrissypchy]

Hello Everyone,
I need to run a query against all tables in this one database (a lot of tables)that end with "_UPDATE". I need this query to count the records in all of the tables. I know the SQL query would look something like SELECT COUNT(*) from database.table_UPDATE. How can I do this in Crystal Reports? Any help would be appreciated.
-Chrissy

 

[pgtek]

hi

just insert a record count

from insert -> field Object -> Special Field
and pic record number and place it in the detail

cheers

pgtek

 

[chrissypchy]

It worked!! Thanks so much! I cant believe it was sitting there in front of me the entire time!!