How to create a report with an undefined number of columns?

[lordhawkins]

I've got a MEMBERS table with about 30 fields. The usual: Id, First Name, Last Name, Charge, Birth date, etc.

I can select multiple fields an send them to Excel with no problem...

But if I want to keep inside the VFP7 SP1 report generator I'm limited to the width of the page.

How Could I create a VFP report that
a) Uses any number of columns sent to it. Say, the user selects the ID, Name, birth date and department for a report; inmediately request Just Name, Address, Zip and e-mail; in fact, any combination ?
2)Extends more than one page width (no matter horizontal o vertical) in a similar way than Excel does when the printing area is beyond the page boundaries?

Am I explaining myself clearly?
Is this possible?

 

[bborissov]

You can try Visual GenRepoX 3.0 from

http://www.eps-software.com/isapi/eps.dll?products

I use it to create my custom reports.

Borislav Borissov

 

[Mike Lewis]

Lordhawkins,

My suggestion was to use the generic report technique that I described in an article called "Create Generic Reports at Runtime" in Foxpro Advisor, November 2003. If you don't have back copies of the magazine, you could try searching for it at

http://foxproadvisor.com.

Mike


__________________________________
Mike Lewis (Edinburgh, Scotland)

My sites:
Visual FoxPro (www.ml-consult.demon.co.uk)
Crystal Reports (www.ml-crystal.com)

 

[TamarGranor]

You can order individual back issues or a CD containing a year's worth of the magazine from the Advisor website.

Tamar

 

[lordhawkins]

I'm goin to try the bborissov suggestion....

Keep you updated