tool to generate report in code?

[jhall251]

I want to generate a report on the fly. The Create Report - quick report almost does it but I'd like to include a header and change the font etc. I've seen an article on doing this via generating an frx table in code but cant remember where. I dont want to buy a 3rd party report writer. Can anybody suggest a technique or a pd or shareware tool for vfp 7.0?

Thanks!

Joe Halloran

 

[ramani]

HI

1. One way is to generate the report and save it to a text file.

2. Accept the header or footer band info as a variable or from a stored place.

3. Take the entire text file content as if it is a memo field or as string variable, using
cString = FILETOSTR(myReportCastAsTextFile)

4. Have a generic report, with the header, footer, uniform font for the report content etc. And using this report design, output the report. This report should have the variables name you got in step3 or using the dummy cursor with a memo field holding the report generated by quick report.

5. Take acre that the quick report adhers to 80 col or 132 col.. whatever and your desined report is of suitable width.




____________________________________________
ramani - (Subramanian.G)

http://winnersoft.coolfreepages.com/

When you ask VFP questions, please add VFP version.

 

[Mike Lewis]

Joe,

I've seen an article on doing this via generating an frx table in code but cant remember where.

That might be my article "Create generic reports at run time", in the current issue (Nov 2003) of Foxpro Advisor.

Mike


Mike Lewis
Edinburgh, Scotland

http://www.ml-consult.demon.co.uk

 

[jhall251]

I just started reading the current issue and will now skip to your article when I get home tonight

Thanks to both of you.



Joe Halloran