I HAVE A CROSSTAB REPORT THAT I WISH TO KEEP. IN THIS CROSSTAB I NEED TO ADD A PROVINCE CODE FIELD. HOWEVER, I WISH FOR EVERYTHING ELSE TO REMAIN THE SAME. WHAT IS HAPPENING IS THAT WHEN I INSERT THE PROVINCE CODE FIELD THE ASSETS ON THE REPORT GET REPEATED IF THE DEALER REP CODE HAS TWO OR MORE LICENSED PROVINCE. FOR EXAMPLE MY ORIGINAL REPORT LOOKS AS FOLLOWS:
100% 75%
9181-0701 JOE SMITH $12000 $14000
ADDING THE PROVINCE FIELD, THE REPORT LOOKS AS FOLLOWS
100% 75%
9181-0701 JOE SMITH AB $12000 $14000
ON $12000 $14000
THE ASSETS ARE REPEATING. I DO NOT WANT TO SHOW THE ASSETS TWICE. IF A DEALER REP HAS TWO OR MORE LICENSED PROVINCES I WANT TO SHOW THE ASSETS ONLY ONCE AND SUPPRESS THE REMAINING. IS THERE ANYWAY TO DO THIS? THANKS GUYS.
100% 75%
9181-0701 JOE SMITH $12000 $14000
ADDING THE PROVINCE FIELD, THE REPORT LOOKS AS FOLLOWS
100% 75%
9181-0701 JOE SMITH AB $12000 $14000
ON $12000 $14000
THE ASSETS ARE REPEATING. I DO NOT WANT TO SHOW THE ASSETS TWICE. IF A DEALER REP HAS TWO OR MORE LICENSED PROVINCES I WANT TO SHOW THE ASSETS ONLY ONCE AND SUPPRESS THE REMAINING. IS THERE ANYWAY TO DO THIS? THANKS GUYS.