¿ªÔÆÌåÓý

ctrl + shift + ? for shortcuts
© 2025 Groups.io

Re: Reports 101


 

Greetings! I¡¯d like to extend my thanks to Eric for always being here to help. I read your email, and I can sense your determination to push forward¡ªsomething that resonates deeply, as many of us are also VFP programmers in our 40s, grappling with the challenges of learning new tools and technologies. I remember feeling similarly lost, like being caught in a ¡°rabbit hole¡± (think The Matrix, 1999).

In terms of reporting for the web, I wanted to share a bit of my own experience. As we all know, the VFP reporting engine offers unmatched precision with its ability to position objects down to the millimeter. Out of all available tools, only Crystal Reports can truly match that level of accuracy.

Could you tell me a bit more about your web environment setup? Are you working with a Windows + XAMPP + PHP + MySQL stack, or is it a Windows + + MSSQL Server setup? Understanding your stack could help us troubleshoot better together. Just know, you¡¯re not alone in this (as they say at SETI.org).

One approach I¡¯ve used is to design reports in VFP, save them as HTML, and then integrate that HTML into my PHP setup. By replacing tags with field names, I¡¯ve found it works seamlessly.

Looking forward to hearing more about your setup and seeing how we can work through this together.

image.png
This is designed in vfp then saved in html to replace the tag.?
as Eric mentioned, you have to use select queries before calling report no table save in the report data environment.
regards?
rizwan hassan?


On Mon, 28 Oct 2024 at 10:15, Stein Goering via <sgoering=[email protected]> wrote:

The web app I worked on over the past several years did not directly use VFP reports, so my skills in that area have been seriously neglected.

?

I¡¯m now in the process of porting an old desktop app to the web, but for this one I want to leverage my existing reports.? When the user requests a report, I use FoxyPreviewer to send output to a PDF, which I then open in a new tab.?? This is working quite well, but it¡¯s meant having to relearn some pretty basic stuff.

?

I just spent well over an hour trying to figure out how to edit a report data environment.? I kept thinking I was missing something on the Report menu.? Initial Google attempts kept pointing to sources that would start out with ¡°Open the Data Environment¡­¡±?

?

For the record (and in the hope that if I write it down I¡¯ll remember it next time), it¡¯s under the View menu when the report designer is in scope.?

?

--sg

?

Steven (Stein) Goering

?



--
?????? ?????

Regards
Rizwan Hassan

Join [email protected] to automatically receive all group messages.