-
Mar 9th, 2004, 05:01 AM
#1
Thread Starter
Fanatic Member
crystal report question.
I really need to get the total count of records in two different database tables and display both totals on the same report.
Whenever I try to creat a calculated field to do this, the total from both tables ends up being the same, which is not true.
How do I attemt this?
-
Mar 9th, 2004, 11:04 AM
#2
Create Running Total fields, one for each database table. Since you probably have a one to many relationship, specify when to calculate the count. Most likely you will need to use the On Change of option
-
Mar 9th, 2004, 04:01 PM
#3
Thread Starter
Fanatic Member
I tried but my first running total counts 4 records in Table A, which is correct.. my second running total counts only 1 record in Table B, which is NOT correct. I removed the links between both tables and there is no record selection formula.
Am I doing something wrong?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|