DOCUMENT:Q139694 20-AUG-1999 [foxpro] TITLE :Description and Availability of Wizards in Visual FoxPro PRODUCT :Microsoft FoxPro PROD/VER:3.00 OPER/SYS: KEYWORDS: ====================================================================== ------------------------------------------------------------------------------- The information in this article applies to: - Microsoft Visual FoxPro for Windows, version 3.0 ------------------------------------------------------------------------------- SUMMARY ======= This article lists the wizards that are available in Visual FoxPro along with a brief description of each. Wizards are interactive programs that help you quickly accomplish common tasks, such as creating forms, formatting reports, and setting up queries. MORE INFORMATION ================ Visual FoxPro contains the original wizards as well as new ones. Each Wizard and its associated functions are listed below. Cross-Tab Wizard ---------------- The Cross-Tab Wizard creates a cross-tab query for displaying the results of a query in a spreadsheet format. The wizard prompts you with simple questions as you go through a brief series of steps in which you specify the databases, tables, and fields that you want to use in your Cross-Tab query. Form Wizard ----------- The Form Wizard creates a form for data entry from a single table. The wizard prompts you with simple questions as you go through a brief series of steps in which you specify the table and fields you want to use to create controls that appear on your form. The size of the form is based on your Maximum Design Area setting on the Forms tab of the Options dialog box. Graph Wizard ------------ The Graph Wizard creates a graph from a Visual FoxPro table using Microsoft Graph. The wizard prompts you with simple questions as you go through a brief series of steps in which you specify the table and fields that you want to use in your graph. Group/Total Report Wizard ------------------------- The Group/Total Report Wizard creates a summary report. The wizard prompts you with simple questions and creates the expressions that group your data. Import Wizard ------------- The Import Wizard imports data into Visual FoxPro tables from other file formats. The wizard prompts you with simple questions as you go through a brief series of steps in which you specify a source file and whether you want to create a new file or append the data to an existing file. Label Wizard ------------ The Label Wizard creates labels from a table. The wizard prompts you with simple questions as you go through a brief series of steps in which you specify the table and fields that you want to use to create controls on your report. Local View Wizard ----------------- The Local View Wizard creates views using native data. The wizard prompts you with simple questions as you go through a brief series of steps in which you specify the databases, tables, and fields that you want to use in your view. You must have an existing database in which to store your view. Mail Merge Wizard ----------------- The Mail Merge Wizard creates either a data source for a Microsoft Word merged document or a text file that can be used by any word processor. The wizard prompts you with simple questions as you go through a brief series of steps in which you specify the table and fields that you want to use. One-to-Many Form Wizard ----------------------- The One-to-Many Form Wizard creates a form for data entry from two related tables. The wizard prompts you with simple questions as you go through a brief series of steps in which you specify the tables and fields that you want to use to create controls that appear on your form. The size of the form is based on your Maximum Design Area setting on the Forms tab of the Options dialog box. One-to-Many Report Wizard ------------------------- The One-to-Many Report Wizard creates a report that groups records from a parent table with records from a child table. The wizard prompts you with simple questions as you go through a brief series of steps in which you specify the table and fields that you want to use to create controls on your report. PivotTable Wizard ----------------- The PivotTable Wizard creates pivot tables. A pivot table is an interactive worksheet table that enables you to summarize and analyze data from existing tables. You can choose either to save the pivot table directly in Microsoft Excel or to add the pivot table as an embedded object on a form. Query Wizard ------------ The Query Wizard creates queries. The wizard prompts you with simple questions as you go through a brief series of steps in which you specify the databases, tables, and fields that you want to use in your query. Report Wizard ------------- The Report Wizard creates reports using a single table. The wizard prompts you with simple questions as you go through a brief series of steps in which you specify the table and fields that you want to use to create controls on your report. Remote View Wizard ------------------ The Remote View Wizard creates views using remote data (ODBC). The wizard prompts you with simple questions as you go through a brief series of steps in which you specify the databases, tables, and fields that you want to use in your view. You must have an existing database in which to store your view and an existing data source or connection. Table Wizard ------------ The Table Wizard creates tables based on typical table structures. You select a table that fits your needs from the list of sample tables. You can customize the table's structure and fields as you step through the wizard. You can also modify the table at a later time after the wizard has saved the table. The following wizards are included with the Professional version of Visual FoxPro only. Documenting Wizard ------------------ The Documenting wizard documents projects and program files. The wizard can also create an analysis of your code and clean up the formatting in your code files. The wizard prompts you with simple questions as you go through a brief series of steps. Setup Wizard ------------ The Setup Wizard creates distribution disks from the files in your distribution tree. To learn about the distribution process and how to prepare your distribution tree before running the Setup Wizard, see Chapter 10, "Creating Distribution Disks," in the Professional Features Guide. Upsizing Wizard --------------- The Upsizing Wizard creates a SQL Server database that duplicates, as much as possible, the functionality of a Visual FoxPro database. REFERENCES ========== The information in this article was taken from the Visual FoxPro Help file. For additional information about wizards, please see the following topics in the Visual FoxPro Help file: - Wizards - Wizards submenu - Wizards, using Additional query words: VFoxWin vfp list availability ====================================================================== Keywords : Technology : kbVFPsearch kbAudDeveloper kbVFP300 Version : 3.00 ============================================================================= THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY. Copyright Microsoft Corporation 1999.