Prev
Next
Forums Lawson Business Intelligence/Reporting/Crystal

Max export to excel ?

Sort:
You are not authorized to post a reply.
Author
Messages
jeff-lbi
Basic Member
Posts: 21
Basic Member
2/6/2012 2:18 PM
    I recently ran a report where the result set was close to 200,000. I know this would require excel to have 4 sheets.

    Instead of finishing it prompted for a login information and asked for a refreshed data set

    Does LBI start to have a problem exporting to excel after so many records?
    Matthew Nye
    Veteran Member
    Posts: 514
    Veteran Member
    2/7/2012 8:02 PM
      im not sure but Excel 2007 supports over 1 million rows. No sure what method LBI uses to generate the excel file. try putting in a where clause to limit your records to under 63,000 and that should at least answer your question as to if the record count is the issue.

      You could export to data only (unless this is scheduled).
      If any of my answers were helpful an endorsement on LinkedIn would be much appriciated! www.linkedin.com/pub/matthew-nye/1a/886/760/
      jeff-lbi
      Basic Member
      Posts: 21
      Basic Member
      2/8/2012 7:43 PM
        Good point about the record count.

        I actually ran the report twice with a date range that would give me 150,000 for the first, and about 60,000 for the second run, and both went to excel fine, but the complete result set (a little over 210,000) won't finish.
        Matthew Nye
        Veteran Member
        Posts: 514
        Veteran Member
        2/8/2012 8:10 PM
          hmmm, i wonder if its a data issue. have you looked in your log files to see if there are any exceptions when the report doesnt export?
          If any of my answers were helpful an endorsement on LinkedIn would be much appriciated! www.linkedin.com/pub/matthew-nye/1a/886/760/
          You are not authorized to post a reply.