Think I have found a bug with how layouts and cross tabs interact with each other.
This was first don when I was playing around with the layouts in a much larger workflow, and it crashed the program. I loaded up the same workflow and did it again and again it crashed the program. So I have tried it in a smaller workflow with junk data;
first run it errors out, and after a few reruns I have received the same error
on some of the reruns the workflow didn't error, but I either got all fields empty, one field null and the other two empty etc (some screenshots below)
Solved! Go to Solution.
Hi Carlithian, what method of aggregation did you use for your cross tab? If I used 'first/last' rather than concatenate then I didn't get any weirdness with the cross-tab, but using concatenate I just got empty/null cells. Report/layout objects are limited in the aggregations which can apply to them (same as spatial objects)
Hi Ollie, I was using the concat which is my lazy go to. Great to know the limitations, I'll have to keep that in mind.