I have a report that I would like to add every other automatically generated columns. I tried having the extra column to deal with it but I ended up getting the error "No room to insert columns".
Date
Votes
3 comments
-
Jet Reports Historic Posts Hi Noreen,
To me it's not clear what you want to do. Could you upload your report please with a description of what it should do? -
Jet Reports Historic Posts I think I have an example of what you are wanting to do. My example is using Rows instead of columns. It is designed to sum every other row - the highlighted rows. I used a little Excel magic to get this to work. In the row above my NL(Rows) function, I put a "1". Then in the row with my NL(Rows), I added "1" to the cell above. This will increment the rows by one when they are added. I could then use Excel's MOD() function to see if the number is odd or even. Instead of using a simple SUM() to get the total, I used SUMIF() based on if the number was odd or even (1 or 0). You can see that I also used Excel's Conditional Formatting to change the color of the rows with this functionality too.
I hope this is what you were looking for! -
Jet Reports Historic Posts Thanks! This one worked. I appreciate the help.
Please sign in to leave a comment.