Results 1 to 3 of 3

Thread: crystal report question.

  1. Mar 9th, 2004, 05:01 AM #1
    nkad
    nkad is offline

    Thread Starter
    Fanatic Member
    Join Date
    Sep 2000
    Posts
    770

    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?
    Reply With Quote Reply With Quote
  2. Mar 9th, 2004, 11:04 AM #2
    brucevde
    brucevde is offline
    PowerPoster
    Join Date
    Oct 2002
    Location
    British Columbia
    Posts
    9,758
    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
    Reply With Quote Reply With Quote
  3. Mar 9th, 2004, 04:01 PM #3
    nkad
    nkad is offline

    Thread Starter
    Fanatic Member
    Join Date
    Sep 2000
    Posts
    770
    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?
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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