Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to Call FoxFire Report from Program
Message
 
To
27/08/2002 03:20:33
General information
Forum:
Visual FoxPro
Category:
Third party products
Miscellaneous
Thread ID:
00693934
Message ID:
00694279
Views:
13
>Hi All,
>
>This could be a very basic question, but I am not familiar with FoxFire report writer so I don’t know how to do it! Scenario is:
>
>1. A custom application with some data tables and FoxFire Report writer is installed and end user has designed few reports in FoxFire.
>2. Now I am writing a new program (Out side that App), which will call a report created in FoxFire, I know the name of report I just want to print the report without user intervention (Where user is required to click Run in FF).

This may be available to you if the software in question has th foxfire.app file distributed with it rather than imbedded into their app or exe. If it's imbedded, your out of luck.

If it's there, there are two methods that can be used to call a foxfire report. One is to create a cursor with the alias ff_batch with 3 fields called Action c(10), Config c(20), request c(25) and fill them.

Fill action with "RUN", Config with "FFCONFIG.PRG" typically, and request with the name of the report you want to run. You can run multle reports this way. Once the cursor is created, just call foxfire.app and away you should go.

The other is to call foxfire.app with the following syntax:

DO ("FOXFIRE") WITH exprC1 [,exprC2] [,exprC3] [,exprC4] [,exprC5] [,exprN1] [,exprL1]

These map to:

exprC1 = ff_func
exprC2 = ff_parm1
exprC3 = ff_parm2
exprC4 = pg_config
exprC5 = ff_parm3
exprN1 = ff_timeout
exprL1 = ff_macroOK

ff_func tells foxfire what to do. Make this "REQUESTS" in this case

ff_parm2 and ff_parm2 you can leave blank.

pg_config should contain "FFCONFIG.PRG"

ff_parm3 must contain the name of the report to run.

This is basically everything you need to call the foxfire report from foxpro, this assuming that you have access to foxfire.app from where you will be calling it.
Cy Welch
Senior Programmer/Analyst
MetSYS Inc
Previous
Reply
Map
View

Click here to load this message in the networking platform