+ Reply to Thread
Results 1 to 4 of 4

Exported Report

  1. #1
    Registered User
    Join Date
    12-02-2014
    Location
    Alameda, CA
    MS-Off Ver
    Micro Soft Office Standard 2010
    Posts
    1

    Exported Report

    Let me preface this by saying I am a complete and total rookie in excel. I have exported a crystal report with 6400 records, into an excel doc. When I open it it only has 3500 of those records. How would I go about adjusting the report to include all of those records?

    Thanks in advance

  2. #2
    Valued Forum Contributor
    Join Date
    11-22-2014
    Location
    Arizona, USA
    MS-Off Ver
    Office 365
    Posts
    973

    Re: Exported Report

    Complete and Total.. does this means you are graduating from being a rookie... haha just being literal.... To the topic -

    I think this comes down to the actual Export itself.
    Look at limitations you may have as well as file formats you are exporting to.
    While 6400 records is not an unreasonable amount of records, it seems like 3500 is a very clean round number in which I would assume this is something within the crystal report settings and not really an excel issue.
    -If you think you are done, Start over - ELeGault

  3. #3
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Exported Report

    This article may help:
    http://aspalliance.com/478_Exporting...orts.all#Page1
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,938

    Re: Exported Report

    Can you do the export in 2 stages? 1-3500, 3501-6400
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Getting blank page at the end of report in PDF exported from excel writer
    By aarti323 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-27-2013, 03:18 PM
  2. [SOLVED] Use time data from an exported report in a formula - not working!
    By psgolfer32381 in forum Excel General
    Replies: 5
    Last Post: 12-19-2012, 11:14 AM
  3. Format cells to Autosum time from exported report
    By scboyd in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-31-2012, 11:22 PM
  4. Exported Report from Quickbooks
    By crowegreg in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-17-2012, 09:39 AM
  5. Replies: 4
    Last Post: 07-26-2012, 05:49 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1