MyWraps MaxRows

Note: This page has been replaced. Please continue to the updated and extended help page at https://help.excelwraps.com/support/online-help/xlw-help-mywraps-reports/.

*** NOTE: MyWraps is capped at MaxRows = 500 *** - what does this mean?

The cloud database can hold a virtually limitless amount of data in many wrap instances. Our MyWraps reporting tool is used to pull data from the cloud database into a report on the client device. Normally sensible use of data filters restricts the amount of data in a MyWraps report. However if your request happens to pull all the available data and the data set is enormous it will take some time arrive. A data limit called MaxRows is used to limit the maximum number of rows in a MyWraps table. It is included a MyWraps URL by "...&Options.MaxRows=100..." i.e. data will be limited to the most recently modified 100 rows in a MyWraps table. If it is not explicitly defined then its default is "&Options.MaxRows=500". When you hit the MaxRows data limit you will see the following warning at the top of a MyWraps report *** NOTE: MyWraps is capped at MaxRows = 500 ***. When you hit the limit you should consider:

  1. Set better primary filters to limit the amount of data retrieved - Primary filtering takes place on the database to extracting wrap instances based on their state (live or frozen), their unique keys, their creation properties (date and user) and their last modified properties (date and user). The maxrows limit applies to primary filters only. Once a subset of wrap instances have been extracted secondary filtering takes place on individual cell values. This is done in memory on the server and is not as efficient or as fast as primary filtering.
  2. Increase the value of MaxRows as appropriate - Do this if you anticipate more than 500 wrap instances just be prepared to wait a little longer than usual for your MyWraps report.
  3. Switch off MaxRows - If you need all available data to be included then MaxRows can be switched off by setting it to -1 or 0 ("...&Options.MaxRows=-1..." or "...&Options.MaxRows=0..."). If you have a vast amounts of data (tens of thousands of wrapinstances, say), take a coffee break after executing the MyWraps report.