Skip to Content
avatar image
Former Member

What is the row limit (as a data source) for CSV files.

Oct 19, 2016 at 04:24 PM | 188 Views

Can CR handle writing reports off of very large CSV files?

I referring to say 30 million, or 300 million rows?

It would be smarter to import it into a SQL table and attach to that, but I still have to ask.

Thanks for any assistance.

-= Bruce

SAP Crystal Reports | csv | datasource | row limit
Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Vadim Kalinin
    Oct 21, 2016 at 11:31 AM

    There is no limit for rows in csv file it's only question of time to import!

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Abhilash Kumar
    Oct 20, 2016 at 10:24 AM

    Hi Bruce,

    That's a lot of rows for any database!

    Considering this is flat file, I believe the process would be very slow or it may even come to a point where CR crashes.

    -Abhilash

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 21, 2016 at 11:21 AM

    I agree. I just had to ask the question. I've tried it on a much smaller (but still large) file and it's pretty slow.

    Justifications etc.

    I appreciate the help folks.

    -= Bruce

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 23, 2016 at 10:06 PM

    Thank-You folks. I appreciate the great help.

    Bottom line: I'm gonna need a sql server table I think.

    :-)

    -= Bruce

    Add comment
    10|10000 characters needed characters exceeded