> I guess I tend to use SQL Server, so this is less of an issue for me. Also, Randy McAtee wrote
> a great addon for VFE to use Crystal, and it creates an ADO record set and sends that to the report.
> That seems like a better way to do it than exporting to fox26 tables.

> You report tool sounds interesting. I wish you good luck with it.

Thanks Bob I'm working hard to make sure that EVERY VFPer will want it!

> I also remember a product called Bull's Eye reports. Any relation? It never seemed to get
> off the ground, but was supposed to be fully oop. I think it actually used an FRX in the background.

> BOb

No Relation to them at all. I did talk to them at the one and only Devcon that they attended though. I remember them having to use a Bull's Eye Report Metatable for their reports though. They allowed you to import in a VFP FRX Report into that and then you could edit it within their tool. I remember thinking that won't be the best thing for anyone who has a lot of reports that they will have to convert. That is why I've been working hard to make sure that I can run any off the shelf VFP Report without code changes. I even support running code from within the INIT of the DE just as you can do in a standard VFP Report. That is where I place a lot of my code to actually run my queries etc. so that I can just send out FRX updates to my customers and have it run without having to recompile a whole new EXE for a new Report.

I am providing the Source Code FREE of charge for the VFP part of my engine so that way other developers can see how to use my ActiveX Control and may want to enhance it to do all kinds of things with my ActiveX control such as Subreports etc. There really isn't much code left in the VFP Class Library for running a VFP Report because I moved most of it into Delphi so it would run faster. All of the calculations of when to automatically add a new page and Stretch With Overflow, etc is built in Delphi now so it is Real Fast as compared to other ALL VFP Solutions. VFP could never add up the width of EVERY Character in a String that has to be Underlined in a PDF Document using FontMetric information as fast as I can do it in Delphi. That is why my PDF Output is so Fast.

I just added Compression to my PDF Output over the weekend and it only produced about a 10-20% hit in performace. So I was already 5 to 10 times faster at saving to a PDF than Adobe's PDF Writer was when printing from the Preview so now I'm still at least 4 to 8 times faster! <bg>

Mostly, I wanted a decent Report Preview and an easier way to do Rotated Text and Watermarks as well as a whole bunch of other goodies that I always wanted. If you do it yourself, you can have anything you want! <bg> And if other people like what your doing than that's even better especially when they are willing to pay you for it! <bg>

Now I just need to get some of my other ActiveX components and software available for online purchase. The sky is the limit when you combine VFP and DELPHI!! Just think there will soon be a Delphi that can compile to .NET. Then I will be able to ship 22MB Runtimes with my Products!! I would definitely prefer to write my Report Engine code in Delphi than C# although C# isn't that big of a deal. Just another Name and another Syntax for the same old stuff.