title: iReport - organizing column output?
body: <p>I am working on a profit and loss report that should look like this:
  <img src="https://i.stack.imgur.com/QXhXy.png" alt="enter image description here"><br/></p>
  
  <p>And my data table looks like this: <br/>
  <img src="https://i.stack.imgur.com/s1F8C.png" alt="enter image description here"></p>
  
  <p>For this P&amp;L I have query #1 that populates the data for the current month and the 3 months prior. Then I have query #2 to calculate a 6-month rolling average, and then query #3 to calculate a year-to-date total. They're all joined with union statements. </p>
  
  <p>I can't figure out the best way to get this to render in iReport. Right now I am using a crosstab, and I was able to finagle the "measures" labels into the customer column using Bekwam's <a href="http://bekwam.blogspot.com/2011/06/expanding-crosstab-in-jaspersoft.html" rel="nofollow noreferrer">"Expanding a Crosstab" technique</a>. </p>
  
  <p>So my questions are - is there any easier way to do this? Every time I add a measure to the crosstab I have to rearrange the measures labels and fields. If I made a pivot table in Excel, I could click a drop-down box and choose to show or hide certain months - is there any way to do that in iReport? I feel like I must be missing something. If anyone else out there is displaying data in columns like this, how are you doing it? If you set up your detail band in columns, any tips for organizing output so it looks professional?</p>
  
  <p>Thanks,
  Lisa</p>