Friday, February 21, 2014

New Local Copy Setting in Global Options

Recently I have a rash of support calls where the culprit of problems turned out to be the "Create Local Copy" button. The "Create Local Copy" option was designed to give users a way to save various Maintenance databases locally so that ZP would not need to make an Internet call to get that data. In theory this would be a time saver but in reality the feature causes more trouble than it is worth. Now there is a new Global Personalization Options on the Two Tab of that screen that says "Allow Local Copy Option in Maintenance Screens." Keeping that option checked means the button will work as it always has. Unchecking that option means the buttons will be disabled for all users. For most customers I would recommend going ahead and turning this feature off. If you have a Maintenance Screen where the "Local Copy" button reads "Delete" instead of "Create", I would go ahead and delete the local copy before disabling the feature system wide.

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.