>A client of mine wants to have a report where the field sizes could be changed on the fly, as field positioning can be dynamic, at least horizontally. As far as I know, this could be done if a tool builds the report from scratch each time a user requests a report. Are there tools to do this? I have looked quickly at the Crystal Reports and FoxFire! sites but cannot tell if they do this. Has anyone done this?
I've done it but not in a .frx file, at least not in VFP. Building a .frx file was easy in DOS days, with fixed lengths, but now with the weird units (check John Koziol's article here) it's a major task.
The thing I was using was a ? ?? sort of report, but that also worked based on fixed fonts. It was building an array of columns from the supplied list of fields, looking up their descriptions from a data dictionary. The better version of this was actually generating HTML tables instead. One option would be to report to Word, using merge, if you can find your way with it.
Either way, I'd stay away from fox reports for this, simply because of the amount of work involved.