This can be done by creating a calculated field that is a string with nothing but a space. Then, place this calculation on the text shelf, as well as the columns shelf. Right click on the calculation on the columns shelf, and un-check Show Header.
Hope this helps!
1 of 1 people found this helpful
Tracy thanks for this trick! I was always always squeezing them to nothing and then setting the font color to white. Your way works a lot better!
Thanks that works
This is *so* much easier than what I've been doing. Thanks, Tracy!
Ok, this is embarassing, but I can't figure out how to create a calculated field that's a string with just a space. I tried
without success. I tried just putting a space without the STR() and that also produces an error.
LOL I would like to try this fix but am not smart enough to figure out step 1!!! Any help would be appreciated.
Have you tried enclosing the space in quotation marks? " "
Thanks Seth!!! :-)