Calculating Data from two different tables

[austin22]

Hello,

I am using CR 8.5 and I need some help with retrieving data from two different tables. I have a report that look something like this:

       {table1}   {table2}
CaseNo   DocID   ActionDocID
123       W1         W1
456       W2         W2
789       W2         W2
321                  W1
654       W1         W1

In my report footer I have a count of case numbers that have the DocID number in it. What is happening is that if the DocID field is missing then I get an inaccurate count. I want to be able to count the DocID in table2 to get a better if table1 DocID is blank. Please advise

 

[Tatertot45]

don't double post, it is irratating. we know you need help, but we may not always have your answers. I tried to help you in the other thread you started.