Results 1 to 9 of 9
  1. 07-23-2012, 06:14 PM #1
    Ray67
    Ray67 is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    338

    Exporting to excel

    Hello



    I have a report which has about 5 subreport. When i transfer the data to excel the data is all over the place. How can i organize the data???

    This is how it looks.

    Text200 Text172 Text173 Text174 Text176 Text177 Text178 Text179 Text180 Text181 Text182
    74.92
    January February March April May June July August September October November December Total
    ######## ######## $12,001.00 $37,001.00
    January February March April May June July August September October November December Total
    $7,987.00 $9,001.00 $8,001.00 $24,988.00
    January February March April May June July August September October November December Total
    $1,501.00 $1,576.00 $1,200.00 $4,277.00
    January February March April May June July August September October November December
    ######## ######## $30,800.00
    January February March April May June July August September October November December
    72.8% 76.8% 68.0% 76.4% 52.9% 44.6% 46.0% 45.6%
    Text200 Text172 Text173 Text174 Text176 Text177 Text178 Text179 Text180 Text181 Text182
    74.92
    January February March April May June July August September October November December Total
    ######## ######## $12,001.00 $37,001.00
    January February March April May June July August September October November December Total
    $7,987.00 $9,001.00 $8,001.00 $24,988.00
    January February March April May June July August September October November December Total
    $1,501.00 $1,576.00 $1,200.00 $4,277.00
    January February March April May June July August September October November December
    ######## ######## $30,800.00
    January February March April May June July August September October November December
    72.8% 76.8% 68.0% 76.4% 52.9% 44.6% 46.0% 45.6%
    Thank you
    Reply With Quote Reply With Quote
  2. 07-24-2012, 06:08 PM #2
    June7's Avatar
    June7
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,902
    Sorry, data from complex reports won't export nice. Can't do anything to make the export look better. Will have to fix it on the Excel side.

    Why do you want it in Excel?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
    Reply With Quote Reply With Quote
  3. 07-24-2012, 07:19 PM #3
    pbaldy's Avatar
    pbaldy
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521
    I agree; this is one of the reasons the ability to export a report to Excel was later removed. Either export to PDF or export the underlying query(ies) to Excel, perhaps with automation if you want a particular look.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com
    Reply With Quote Reply With Quote
  4. 07-24-2012, 07:19 PM #4
    Ray67
    Ray67 is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    338
    I was asked if it can be exported to excel. Thank you very much for your reply.
    Reply With Quote Reply With Quote
  5. 07-24-2012, 07:27 PM #5
    Ray67
    Ray67 is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    338
    pbaldy

    Thank you for your reply. The report is coming out the way i want it to but i'm having a hard time aligning all sub reports with the main report.
    Reply With Quote Reply With Quote
  6. 07-25-2012, 01:27 AM #6
    June7's Avatar
    June7
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,902
    Actually, the export of report to Excel is still possible. Just did it. Can't expect it to always look nice.

    Separate thread already started on aligning topic https://www.accessforums.net/reports...ort-26757.html
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
    Reply With Quote Reply With Quote
  7. 07-25-2012, 08:46 AM #7
    pbaldy's Avatar
    pbaldy
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521
    Interesting; I hadn't realized they put it back in. Looks like SP2 brought it back. Since I don't typically export reports to Excel anyway, I hadn't noticed.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com
    Reply With Quote Reply With Quote
  8. 07-25-2012, 02:40 PM #8
    June7's Avatar
    June7
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,902
    I didn't know it ever went away. Not something I routinely do so probably wouldn't miss it, much. I did use it on a personal file at home recently. The output was okay, did have to clean up the worksheet structure a little.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
    Reply With Quote Reply With Quote
  9. 07-26-2012, 10:24 AM #9
    pbaldy's Avatar
    pbaldy
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521
    Quote Originally Posted by June7 View Post
    I didn't know it ever went away.
    Yeah, see the 4th item in What's Gone on Allen's site:

    http://allenbrowne.com/Access2007.html#Gone
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. exporting to excel
    By akrylik in forum Access
    Replies: 3
    Last Post: 05-24-2012, 12:27 AM
  2. exporting to Excel
    By johnririe in forum Import/Export Data
    Replies: 6
    Last Post: 08-23-2011, 10:16 AM
  3. Exporting to Excel
    By TheDeceived in forum Programming
    Replies: 0
    Last Post: 11-15-2010, 08:56 AM
  4. Exporting to Excel
    By DreamOn in forum Import/Export Data
    Replies: 1
    Last Post: 05-23-2010, 10:27 PM
  5. Really Need Help With Exporting to Excel
    By graviz in forum Import/Export Data
    Replies: 0
    Last Post: 09-24-2009, 08:29 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Other Forums: Microsoft Office Forums