I have a report that shows panels of tests run. Each panel can have 2 tests or 20 tests.
My problem is when there are say, more than 6 tests, the crosstab runs across the page. I've been searching for a way to make the crosstab wrap and so far everything I have found seems very complicated.
Do any of you know how to make a crosstab wrap so it's something like
client ID Test 1 Test 2 Test 3 Test 4 Test 5
xxxa Pos Neg Neg Pos Neg
xxxb Neg Neg Neg Neg Neg
Then start another crosstab below this one with Test 6 and so on?
Maybe create groups where column number is in 1-6, then Group A, column number in 7-12, then Group B?
Is that even doable?