String variable (formula) in the Group Footer sets count in footer off

[mtrout]

Hello, I hope that you can help me. I am having a time of trying to display a name next to the number of evaluations collected in the group footer. Each time I place the name in the group footer field, the numbers go WAY UP. If I just remove the name, the numbers are perfect. Unfortunately, I am unable to find out why this is happening. Can you advise? Thank you.

 

[lbass]

Is the name field coming from a different table? It sounds like the table is only being activated when you add the name and that it is then causing your records to duplicate. Try unsuprressing or unhiding the detail section so you can see what it is going on.

-LB

 

[lbass]

Just realized you said you were using a variable. Please post the content of the formula that returns the name field.

-LB

 

[mtrout]

Hi LB, Thank you so much for your response. the name field has the FNAME and the LNAME which is from a different table. But to connect to the table, I use a key. Here is the formula: (It's simple)
{INSTR_ASSIGN.LNAME} + ", "+ {INSTR_ASSIGN.FNAME}


The items I am counting are in a table Evaluations. I am trying to count the evaluations based on a code (ID_INS)that's in an evaluations table. EVALUATIONS.ID_INS connects to INSTR_ASSIGN.PERSON_NO which has the FNAME and the LNAME

 

[lbass]

Okay, then my original suggestion stands--place the name formula in the detail section and observe what happens. I think you will see that there are multiple names, causing the results to inflate. If you only need the table for the names, you could insert a subreport in the group footer that references the name table and remove the name table from the main report. You will have to decide which of the multiple names you want to display though.

-LB

 

[mtrout]

Thanks again LB. This is all happening in the subreport, the subreport is set up to such that a Group footer is used. The other calculations are good. Just the count. I have looked at the details details section, but can't figure out why so many duplicates. I'll try looking at the data tables and see if I can figure out why it's doing what it's doing. All I know for now, remove the name all is well. Add the name, it gets crazy on the count. I have tried different running totals with no success. I even tried to over lay a sub report onto the original sub report just to get the names...no good. Didn't do what I wanted. I will re investigate further. Thank you again.

 

[lbass]

Well, you should be able to insert a running total that does the correct calculation, where it evaluates on change of some field. I'd have to see some sample data to make a recommendation about what the field would be.

-LB

 

[mtrout]

LB-
I was able to use a different table and all worked out well. I think that somehow the previous table I was using may have had a conflicting field? The new table I am using connects via the instructor number, but does not have any other relating records. All I know is that I am getting the correct numbers and why it would not work with previous table, I don't know. I'm glad that I have another table to use. Before using the new table, I at least tried different variations of the joins, but that did not help. Thanks again.