none
Is there rows limit for the table? Which is the max rows best practice? SSRS 2012

    Question

  • Hi people,

    While building a table in the SSRS, is there rows limit to be rendered ?

    What´s the best practice for it? If we expect 5 Millions of rows for example, could the table render it without to be paged?

    Even paged, is it fine to the SSRS render to the end user?

    Thanks,

    Alex Berenguer

    Wednesday, September 25, 2013 8:29 PM

Answers

  • Theoretically a table is limited by available client and server memory (or browser page size constraints) That said I would say the row limit is what can be visibly processed by the person running the report, this is normally less than a page of data. More than that implies that data is to be exported and then with the volumes you are talking about I would suggest using ssis or ssms instead to export directly to a file.
    Wednesday, September 25, 2013 9:14 PM

All replies

  • Theoretically a table is limited by available client and server memory (or browser page size constraints) That said I would say the row limit is what can be visibly processed by the person running the report, this is normally less than a page of data. More than that implies that data is to be exported and then with the volumes you are talking about I would suggest using ssis or ssms instead to export directly to a file.
    Wednesday, September 25, 2013 9:14 PM
  • Mike, thank you so much for your answer.

    Best Regards,

    AB

    Thursday, September 26, 2013 4:14 PM