New Max Rows Setting In Personalization Options

Every report screen in ZP SQL has a Max Rows option that is set at 100 records by default. This means that no matter what report criteria you use, ZP will return no more than 100 records for that query. This is basically a safety feature to prevent users from accidentally requesting a huge data set over the Internet and bogging down their connection. You can manually change this value any time you run a report but some users wanted a way to avoid this limitation all together. So now there is a new setting in the SQL Tab of the Local Personalization Options screen that lets you keep the default setting at 100 or change it to 0 which effectively turns the limitation off. The new option "Set Max Rows to 100 in Report Screens" will be turned on unless you go into the Personalization screen and uncheck it. This new feature affects just about every module in ZP SQL so you will have to download a full complement of upgrades to implement it.