Panorama V

There’s good news for devotees of ProVue’s Panorama: Panorama V (or version 5) runs in Mac OS X. And this version adds a boat-load of enhancements – including live clairvoyance (similar to the easy search feature in OS X’s Finder), more ways to get information from the Internet, extensions to Panorama’s programming language, custom functions, and a great new way to create custom menus – to the great features Panorama has had for years, such as cross-tab reports, charts, and quick subtotalling of groups.

If you’re developing even moderately complex databases, or if you need to share your databases with many users over a network, Panorama can’t compete with FileMaker Pro 7 (mmmmh; April 2004), 4D 2004, Servoy, or other excellent client-server relational database systems. Panorama V is currently only for single users. (ProVue says that it’s working on a server version, but no release date has been announced.) Panorama does have tools for linking files using lookups, but defining these links is not as easy as defining relationships in FileMaker Pro or 4D, and Panorama provides no way to keep track of relationships after they’ve been defined. Panorama’s programming language is not as powerful as 4D’s (you can’t compile a Panorama database), not as well documented as Servoy’s (which uses standard JavaScript), and not as easy to learn as FileMaker Pro’s.

If your needs are simple, Panorama may not be as good a choice as FileMaker Pro or even Excel. After all, Excel can also do cross-tab reports, charts, and quick summaries. Panorama V’s documentation is extensive (three full volumes!), but at times it seems to be a labyrinth of cross-references.

I especially liked the new elastic-forms feature, which creates fields that get wider or narrower as a user resizes the window. With Panorama’s programming language, you can manipulate data in almost any way. And ProVue provides free online tech support.

Panorama V can’t directly import an Excel spreadsheet, and most of its import and export options are hidden in a wizard rather than readily accessible in the File menu. And its user interface is peculiar. For example, there are three different commands in three different places for deleting records. To delete one record, you use a button in the toolbar; to delete all the records in a database, you use a command in the Edit menu; and to delete the records currently displayed, you first use the Select Reverse command, which hides the records you want to delete and displays the ones you want to keep, and then use the Remove Unselected command to delete the records that are not displayed.


If you’ve used and liked previous versions of Panorama, you’ll want to upgrade to this version. Otherwise, Panorama V is best suited to people who work mainly with flat-file or only moderately complicated relational databases, who want ready-made data analysis tools, and who occasionally need a powerful programming language.

Find the best price