title: flex - Methods of creating pivot or tabular reports?
body: <p>Looking for some ideas, strategies, tools, etc. on creating reports from Flash Builder / Flex 4. </p>
  
  <p>I have a flex application that allows create/read/update/delete of client information from a back-end database.  It uses web services (zend amf -> mongo db or mysql).  I already have the client data IN flex via the web service as a collection for example.</p>
  
  <p>A user requests the ability to generate a report - to display a list of clients under a certain age in a tabular excel style grid (datagrid most likely).   It will be sorted and subtotaled by a demographic such as "insurance type".  Ideally the user would like to be able to select the insurance types allowed on the report (or in the datagrid/pivot table).</p>
  
  <p>I know one option would be to present the user with a series of check boxes or a multi-select list to choose the insurance types.   Then, present them with a data grid or advanced data grid component to display the 'report'.</p>
  
  <p>What other techniques, options or components are available / have people used?</p>