Evan,

>>>I would like to give my end users the ability to run adhoc reports and to also convert my current reports so that they can be sent to HTML, word and PDF. I am a bit confused. I think I would have to buy the developer edition to integrate with VFP but do I have to get the multi-user version. I am the only developer but the end users would be doing their own queries within my application.
>>
>>IMO Crystal Reports is not quite suitable for your situation, though it is the only report generator that can acceptable convert the report to various formats (note PDF is not one of them, might be different in CR 8.0). For end-users to be able to create their own reports, they must have a license per user. It's not that easy to create reports in CR, so your users must really learn how to do this.
>
>>For you personally, you'll only need one license. You may distrubute your reports royalty free.
>
>Ohh... any other reporting options? Foxfire?

I don't know any other report write than CR and the native VFP report writer, so I can't tell. It depends on how hard are the reqiurements for exporting reports to word, HTML etc.. If they're pretty hard I'll doubt if you'll find another report engine which is suitable.

One other thing came in mind:

Seagate has released it's CR 8.0. Within this release there are more possibilities to create reports at runtime (though special licenses apply). Since I don't have the details (CR 8.0 is not yet available up here) you might check the details by contacting seagate.

Also: Seagate has another product called Crystal Info, which might be something you're looking for. Since I've got no experience with it you'll have to dig it yourself.

Good luck,

Walter,