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 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.