Creating a VFP report on the fly from a web page.

I have an ASP application that uses a VFP compiled DLL to interract with our
VFP backend.

I would like the users to be able to display an invoice on the screenthat
looks exactly like their real invoices (which come out of VFP).

I am trying not to use Crystal as the users would have already customised
the invoices themselves outside of our control and I relaly dont want to
have to teach them how to redo it in crystal.

I have created a method in our DLL that generates a PDF file without any
messages, forms or other human interface features. However the one thing I
want which is to generate a report is rejected by the COM DLL.

Is there a way to get a VFP compiled DLL to generate repot using the REPORT
FORM comman or some other strategy to generate a report from an FRX file?

Cheers
David Younger

Leemi
Fri Aug 06 09:28:18 CDT 2004

Hi David:

Take a look at this article and see if it helps:

191639 PRB: Report Command Used In Visual FoxPro COM DLL Causes Error
http://support.microsoft.com/?id=191639

This article may give you some options for designing this app.

I hope this helps.

This posting is provided "AS IS" with no warranties, and confers no rights.

Sincerely,
Microsoft FoxPro Technical Support
Lee Mitchell

*-- VFP9 Public Beta Now Available!! --*
Download the VFP9 beta here: http://msdn.microsoft.com/vfoxpro/

*-- VFP8 HAS ARRIVED!! --*
Read about all the new features of VFP8 here:
http://www.universalthread.com/VisualFoxPro/News/VFP8Release.asp
Purchase VFP8 here:
http://shop.microsoft.com/Referral/Productinfo.asp?siteID=11518

Keep an eye on the product lifecycle for Visual FoxPro here:
http://support.microsoft.com/default.aspx?id=fh;[ln];lifeprodv
- VFP5 Mainstream Support retired June 30th, 2003
- VFP6 Mainstream Support retired Sept. 30th, 2003


>I have an ASP application that uses a VFP compiled DLL to interract with
our
>VFP backend.

>I would like the users to be able to display an invoice on the screenthat
>looks exactly like their real invoices (which come out of VFP).

>I am trying not to use Crystal as the users would have already customised
>the invoices themselves outside of our control and I relaly dont want to
>have to teach them how to redo it in crystal.

>I have created a method in our DLL that generates a PDF file without any
>messages, forms or other human interface features. However the one thing I
>want which is to generate a report is rejected by the COM DLL.

>Is there a way to get a VFP compiled DLL to generate repot using the REPORT
>FORM comman or some other strategy to generate a report from an FRX file?

>Cheers
>David Younger

Gerben
Fri Aug 06 09:27:34 CDT 2004

Hi David,

I know, it is impossible to do any user action from a Foxpro dll.

A strategy could be to have an other 'normal' foxpro application running
that react on an action of the dll.
Per example make a report dbf with a flag field, update the flag field from
the dll, and print all flagged record, in the other app.

Or try to fire a foxpro exe form your ASP...

<%
Set oWSH= Server.CreateObject("WScript.Shell")
oWSH.Run "c:\foxexe.exe"
set oWSH = nothing
%>.

HTH,
Gerben Kessen.



"David Younger" <davidyounger1@hotmail.com> wrote in message
news:uPWHZj4eEHA.644@tk2msftngp13.phx.gbl...
> I have an ASP application that uses a VFP compiled DLL to interract with
our
> VFP backend.
>
> I would like the users to be able to display an invoice on the screenthat
> looks exactly like their real invoices (which come out of VFP).
>
> I am trying not to use Crystal as the users would have already customised
> the invoices themselves outside of our control and I relaly dont want to
> have to teach them how to redo it in crystal.
>
> I have created a method in our DLL that generates a PDF file without any
> messages, forms or other human interface features. However the one thing I
> want which is to generate a report is rejected by the COM DLL.
>
> Is there a way to get a VFP compiled DLL to generate repot using the
REPORT
> FORM comman or some other strategy to generate a report from an FRX file?
>
> Cheers
> David Younger
>
>