在VFP下用SQL生成通用报表

The Formation of the General Statements by Using SQL under VFP

介绍了在VFP中将IIF函数和宏替换应用在SELECT-SQL语句中,生成灵活多变的汇总报表的方法,并给出了源程序代码。报表中数据项的名称和数目随应用情况而异。该报表可以在屏幕上浏览,也可以送往打印机输出,还可以转换成Excel表格文件由用户用Excel编辑后再输出。

This paper introduces the method of forming the flexible and variable the summary statements by applying IIF function and macro-alternation into SELECT-SQL sentence in VFP, and gives the codes of the source program. The names and figures of the date items in the statements are varied according to the application. The statement can be browsed on screen, can be out-put by the printer, and can also be transformed into Excel form file that is edited and then out-put by the users with Excel.