I have a category report that seems to subtract a column after you select more than 6 of the categories. I’ve attached a sample. So if you open up the “frmSelectCategories” form, then select six categories, click “Next”, then select option “Category Report – Crosstab”, and click “run report”–now you can see that only five categories are listed there even though there is room on the page for another column or two. I don’t know why it’s doing this.
One other thing…is there any way to make this report continue on the next page with the columns if you select more than will fit horizontally on the page? And I guess I have one more question…can the headings be set up to print on the next line if they are longer than a certain number of characters? You should be able to see that some of the headings of the columns are cut off because the name is too long. Can you make it go down a line if the characters are longer than the field box, but have it break at a space? I hope I’m being clear enough.