>>I am looking for a great report utility to incorporate into a VFP application with a dynamic data dictionary capability and source code. I have seen query maker and foxfire. Any suggestions/comments?
>
>I've seen FoxFire and I'm impressed. It took them a while to adjust to the DBC, but I understand the current version is pretty good.
>
>Also look at R&R. It's not quite as intuitive as FoxFire, but it handles calculated fields and table joins a little better.
>
>I've also heard that Crystal has it's advantages too.
>
>One last thing, this is all AFAIK and I can't endorse any of them b/c I've never actually built them into anything I've written [yet. It's only a matter of time. The premise of turning report writing/generation over to the user is scary, yet at the same time a relief.... "Matt, you remember that report you did for me about six months ago? (no) Well, could you run it again and make a few changes, I've got to do a presentation in an hour and I need the most up to date information as possible...(oh, sure, no problem...right)]

I have just finished incorporating Foxfire! into a fairly good sized app. It is very versatile as far as configuration goes. You can set security levels for different reports, data items or features of the app. In most cases you don't need the source code because of the way that it is called from your app. You write (or modify an existing) setup .prg that sets a gajillion global variables that the app looks at to configure itself. Different preference sets let you call the program in as many forms as you want. (My app calls Foxfire! from about 15 different places in some form or other) Setting up all of your data items from your existing .dbc is pretty straightforward, and creating compound and calculated data items is not much harder. It's not completely trouble free, however. I ran into a few oddities that took getting to know the tech support guy pretty well to figure out. I have heard one or two other people on this forum complain that they NEVER got Foxfire! to work as needed, but I've had a little better luck. Overall, I think that Foxfire! is a good program, but it does need some fine-tuning before it can be called great.