# Default Maximum number of rows to retrieve in Report ? **URL:** \ **Category:** General\ **Tags:** reporting, 8-7\ **Created:** [March 15, 2024, 2:04pm UTC](https://forums.pega.com/t/default-maximum-number-of-rows-to-retrieve-in-report/6410 "2024-03-15T14:04:29Z")\ **Posts on this page:** 11\ **Page:** 1
**Author:** ![AbhishekC1725](https://avatars.discourse-cdn.com/v4/letter/a/9d8465/32.png) [@AbhishekC1725](https://forums.pega.com/u/AbhishekC1725)\ **Post date:** [March 15, 2024, 2:04pm UTC](https://forums.pega.com/t/default-maximum-number-of-rows-to-retrieve-in-report/6410/1 "2024-03-15T14:04:29Z")
Hi All, What is the default Maximum number of rows to retrieve in report definition rule ? I am using Pega PRPC Personal Edition 8.7 version. It is showing 500 . But in some articles it is written 10K, Which one is correct? It is different according to Pega version? Or it is different for Personal Edition? ![rep.png](https://pega1.discourse-cdn.com/pega/original/2X/6/60815e75dd0a9f48d27f1402f2e1800f150a4df9.png) ---
**Author:** ![Amar\_Deshmukh](https://avatars.discourse-cdn.com/v4/letter/a/bc79bd/32.png) [@Amar\_Deshmukh](https://forums.pega.com/u/Amar_Deshmukh)\ **Post date:** [March 15, 2024, 2:43pm UTC](https://forums.pega.com/t/default-maximum-number-of-rows-to-retrieve-in-report/6410/2 "2024-03-15T14:43:41Z")
@AbhishekC1725 The default is 10K if we leave the field under **General data access settings** for _Max no. of rows to retrieve_ empty otherwise you can put the desired value for Max no. of rows to retrieve field ---
**Author:** ![SohamM95](https://yyz2.discourse-cdn.com/pega/user_avatar/forums.pega.com/sohamm95/32/4726_2.png) [@SohamM95](https://forums.pega.com/u/SohamM95)\ **Post date:** [March 15, 2024, 3:10pm UTC](https://forums.pega.com/t/default-maximum-number-of-rows-to-retrieve-in-report/6410/3 "2024-03-15T15:10:08Z")
@AbhishekC1725 Pega enforces a limit of 10K if left blank. You can get more details here: [https://docs-previous.pega.com/sites/default/files/help\_v71/rule-/rule-obj-/rule-obj-report-/rule-obj-report-definition/dataaccess.htm#:~:text=Maximum%20number%20of%20rows%20to%20retrieve&text=As%20a%20best%20practice%20during,enforces%20a%20limit%20of%2010%2C000.](https://docs-previous.pega.com/sites/default/files/help_v71/rule-/rule-obj-/rule-obj-report-/rule-obj-report-definition/dataaccess.htm#:~:text=Maximum%20number%20of%20rows%20to%20retrieve&text=As%20a%20best%20practice%20during,enforces%20a%20limit%20of%2010%2C000.) ---
**Author:** ![AbhishekC1725](https://avatars.discourse-cdn.com/v4/letter/a/9d8465/32.png) [@AbhishekC1725](https://forums.pega.com/u/AbhishekC1725)\ **Post date:** [March 15, 2024, 11:04pm UTC](https://forums.pega.com/t/default-maximum-number-of-rows-to-retrieve-in-report/6410/4 "2024-03-15T23:04:07Z")
@Amar Deshmukh So why in above screenshot 500 is displaying? ---
**Author:** ![AbhishekC1725](https://avatars.discourse-cdn.com/v4/letter/a/9d8465/32.png) [@AbhishekC1725](https://forums.pega.com/u/AbhishekC1725)\ **Post date:** [March 15, 2024, 11:05pm UTC](https://forums.pega.com/t/default-maximum-number-of-rows-to-retrieve-in-report/6410/5 "2024-03-15T23:05:38Z")
@SohamM95 So why in above screenshot 500 is displaying. If you check your pega environment and please confirm with screenshot. Thanks. ---
**Author:** ![Amar\_Deshmukh](https://avatars.discourse-cdn.com/v4/letter/a/bc79bd/32.png) [@Amar\_Deshmukh](https://forums.pega.com/u/Amar_Deshmukh)\ **Post date:** [March 16, 2024, 3:14am UTC](https://forums.pega.com/t/default-maximum-number-of-rows-to-retrieve-in-report/6410/6 "2024-03-16T03:14:37Z")
@AbhishekC1725 Check the Application setting rule (Pega-RulesEngine • pyMaxRecords) in your Personal edition as shown below you can change the values for respective Production level ![pyMaxRecord.jpg](https://pega1.discourse-cdn.com/pega/original/2X/c/cb9873c0944262300ff2a1b3666b93ad4bfd29e7.jpeg) ---
**Author:** ![Bhumireddy](https://yyz2.discourse-cdn.com/pega/user_avatar/forums.pega.com/bhumireddy/32/23248_2.png) [@Bhumireddy](https://forums.pega.com/u/Bhumireddy)\ **Post date:** [March 16, 2024, 3:39am UTC](https://forums.pega.com/t/default-maximum-number-of-rows-to-retrieve-in-report/6410/7 "2024-03-16T03:39:57Z")
Hi @AbhishekC1725, If you are not mentioning anything: The maximum number of rows to retrieve is 500. It will fetch **500** records by default. That is placeholder message coming from the : pxRequestor.pyReportSettings.pyMaxRecords If you want change, you can define the value, e.g., 100 or 600 etc.., it will fetch 100 or 600 records only from the DB. Can you try changing the value and see? ![MaxRecords.jpg](https://pega1.discourse-cdn.com/pega/original/2X/b/bad75d35af2d2b3fb277dc6bbe55d861559570dd.jpeg) I hope this will help you. **Thanks,** **Ashok** ---
**Author:** ![AbhishekC1725](https://avatars.discourse-cdn.com/v4/letter/a/9d8465/32.png) [@AbhishekC1725](https://forums.pega.com/u/AbhishekC1725)\ **Post date:** [March 16, 2024, 6:47am UTC](https://forums.pega.com/t/default-maximum-number-of-rows-to-retrieve-in-report/6410/8 "2024-03-16T06:47:38Z")
@Amar Deshmukh Thanks , now clear ---
**Author:** ![AbhishekC1725](https://avatars.discourse-cdn.com/v4/letter/a/9d8465/32.png) [@AbhishekC1725](https://forums.pega.com/u/AbhishekC1725)\ **Post date:** [March 16, 2024, 6:47am UTC](https://forums.pega.com/t/default-maximum-number-of-rows-to-retrieve-in-report/6410/9 "2024-03-16T06:47:07Z")
@Bhumireddy Thanks , now clear ---
**Author:** ![NaveenT97](https://avatars.discourse-cdn.com/v4/letter/n/b19c9b/32.png) [@NaveenT97](https://forums.pega.com/u/NaveenT97)\ **Post date:** [August 6, 2024, 8:31am UTC](https://forums.pega.com/t/default-maximum-number-of-rows-to-retrieve-in-report/6410/10 "2024-08-06T08:31:22Z")
@Bhumireddy Thank you For Shareing Your knowledge Can you send the Ans in this Qus: Q : I want to see the genrated sql query for the Perticular report ? .naveent@turlapati ---
**Author:** ![Bhumireddy](https://yyz2.discourse-cdn.com/pega/user_avatar/forums.pega.com/bhumireddy/32/23248_2.png) [@Bhumireddy](https://forums.pega.com/u/Bhumireddy)\ **Post date:** [August 6, 2024, 10:58am UTC](https://forums.pega.com/t/default-maximum-number-of-rows-to-retrieve-in-report/6410/11 "2024-08-06T10:58:26Z")
Hi @NaveenT97 If you want to know particular SQL Query for Report Definition. You need to enable in the Tracer Settings → DB Query in Event Types to Trace, Then run the Report Definition. You can search the by Class Name in Tracer, there you will see Blue Color Lines in the Tracer, find the SQL Query in the tracer and other quires too. Recently @AbikashSharma published nice article. [Database query debugging for Pega](https://www.linkedin.com/posts/abikash-kumar-sharma-b05bb917_pega-tracer-db-query-mapper-chrome-web-activity-7221129967131119616-qLK9?utm_source=share&utm_medium=member_desktop) and [Pega Tracer DB Query Mapper](https://chromewebstore.google.com/detail/pega-tracer-db-query-mapp/oaokbpnfjjgipalphgoaelgcdedfckkb) I hope this will help you. **Thanks,** **Ashok**