<p>Hi everyone,</p><p> </p><p>I am looking for a more 'managable' solution to automatically create pivot tables when reports with crosstabs are exported.</p><p>What I am doing at the moment is this:
On page 1 of the report there is the crosstab, nicely formatted and human readable.
On page 2 there is just a plain table with the data that the crosstab on page is buid on. It is formatted in ISO formats so Excel knows how to handle the values. If this page is exported it's "just" a matter of a bit of selecting, clicking and draggin aroung to create the pivot table. 30 seconds max.</p><p> </p><p>But none the less I would like to spare myself the hassle of integrating said table and having to click around in Excel, I want the crosstab to be a pivot table automatically.
I was looking into maybe using a different emitter which might be able to do that, but that doesn't seem to solve my problem as I found no emitter being able to do that (at least no free one).
Are there other ways that are worth checking out?
Thanks in advance!</p>
