AnsweredAssumed Answered

Export Crosstab Reports to Excel

Question asked by mmccarty on Sep 3, 2009
Latest reply on Sep 3, 2009 by TSGal


Export Crosstab Reports to Excel



  I created a crosstab reports of my division's Staff Hours per period per year which prints to one page in PDF.  When I "save to Excel"  I get all 4,000 individual records and no summary fields.  I tried using  File> Export and Group by Fiscal Year (my sort field).  Then I get the sum for all fiscal years aka 500 instead of FY04 80, FY05 120, FY06 100, etc.


Any ideas would be very helpful.  Thanks