I would like to have a TOTALS column appear immediately to the right of the last inning runs information and the number of innings is variable. It would be the same as runs scored in different innings in a baseball game. Typically there would be 9 innings, but if the game is tied, of course there could be many innings and the very last column would be the total final score.
So, I want the ability to have runs scored columns for both teams for a 10th, 11th, 12th, etc. inning and then immediately to the right of the last inning played, have the TOTALS column. Typically it would be immediately to the right of the 9th inning.
Thank you VERY much for your help!

PS: I'm using XI, if that's important.

Edited by ChiBlackhawks - 05 May 2009 at 12:26pm

Thank you for your answer, but I don't think that will accomplish what I want to do here.
I will try to explain it in a different way.
Let's say my report consists of one line that will have from 2 to 6 columns depending on the data and after the last column I need a totals column. Getting the total amount is not my problem. My problem is how to make the individual columns disappear if I don't need them and have the totals column appear immediately to the right of the last needed column. In other words, have the totals column "slide" to the left to be adjacent the last individual column that was displayed. So it may appear as:
A     B     C     D     E     F     TOTAL
2      1     4     0     1     1      9

Or it may appear as:

A     B     C     TOTAL
1      0     2      3

Thank you!

I don't want to get too excited about this, but i think I can get this to work.
Just a note for anyone who may also need to do this, when attempting to change the X position of a field by using formulas, CR uses the measurement unit, Twips. There are 1,440 Twips in an inch. So, in your formulas.......
If Fieldx > 5 Then
formula = 3500
End If
Positive numbers to move your field to the right and negative numbers to move it to the left from it's original position.

THANK YOU DBlank!!!!