>I am trying to use Fox Pro Report Wizard in my application.
>I works fine and report is created and saved. The only catch is that I cannot see the Report Designer, or Print out the report, untill I exit application. As soon as I quit my application, Report Designer appears and/or printing begins.
>
It sounds like you have the main FoxPro window deactivated (SCREEN=OFF in CONFIG.FPW, or _Screen.Visible = .F.) - the Report Designer runs in the context of the main FoxPro Window.
As far as releasing print jobs from the spooler to the printer, it often helps to issue SET PRINTER commands to force VFP to release the current job to the spooler:
SET PRINTER TO NUL:
EJECT
SET PRINTER TO
virtually guarentees that the job will get released to the spooler for printing by starting another printer stream, which closes the current report stream.
>Is there any way to solve this problem? If not, how else I can give users fast and easy option to print out data from tables in the database?
>
You might want to look into adding FoxFire! or SFReports to your application; the both provide comprehensive query and report building capabilities to VFP applications; both have excellent query and user report design tools built in, which can be incorporated into your app to provide ad-hoc query and reporting services as part of your app. I've tried SFReports, and feel that ordinary end-users can understand and use it one their own with a little practice. At under $300 for the package, including the ability to include it in your apps and full source code, it's a great value; a demo copy, and the docs, can be downloaded from
www.stonefield.com