Clarification on where crosstabs are processed
We had a situation recently where a relatively simple crosstab was not running
I don't remember the exact setup of the report but it was something like 3/4 fields with 1 in rows and the rest in columns. The query was returning about 78k rows
We got a memory sandbox error from chrome and indeed when the report was running we could see RAM usage for chrome climbing rapidly until no more memory was available. This happened on 2 machines which have 16GB of RAM, with some of course being used by the OS etc
I was under the impression that crosstabs were processed solely on the server but it appears from this situation that client memory is also used?