report file is too big

[achen]

I used the report to create a HTML file, but FoxPro kept telling me that the detail band is too large. Anybody knows how to change the setting in the report so all my info can fut into one HTML file? [sig][/sig]

 

[JimmyK]

Hi Achen,
The detail band height is limited (less than a page). So, i think you'd better use low-level file functions to print output to HTLM file. Syntax of HTLM tag is fairly simple

Hope it helps

Jimmy K [sig][/sig]

 

[achen]

Hi, JimmyK

Thank you for the answer. I checked the FoxPro Help file and did find the low-level function. But it is not clear to me how to write the code. Would you be able to give me an example? Thank you. [sig][/sig]

 

[achen]

I figured it out. thank you very much.
[sig][/sig]

 

[foxdev]

Achen, you might also wish to explore SET TEXTMERGE.

As an example, an expression for low-level would be:

fputs(nHandle, LTRIM(STR(lnLineNo)) + ;
MyColumn1 + " " + MyColumn2 + ;
dtoc(MyDateColumn))

Using textmerge, it would be:

\<<lnLineNo>> <<MyColumn1>> <<MyColumn2>> Date: <<MyDateColumn>>
[sig]<p>Robert Bradley<br><a href=mailto: > </a><br><a href=

http://www.foxdev.com/>FoxDev

- Visual FoxPro Development</a><br> [/sig]

 

[TomasDill]

Achen, VFP 6 have function 'STRtoFile', that is very simple to use. However, when your HTML page large, better to use low-level file functions. [sig]<p>Vlad Grynchyshyn<br><a href=mailto:vgryn@softserve.lviv.ua>vgryn@softserve.lviv.ua</a><br><a href=

http://www.softserve.lviv.ua>Soft

Serve</a><br>The professional level of programmer could be determined by level of stupidity of his/her bugs[/sig]

 

[dgrewe]

Achen, If you want to save your self a little programming time check out

http://www.amyuni.com

they have a print driver you install that creates a HTML file from a VFP report form. (or from just about anything else for that matter.) [sig]<p>David W. Grewe<br><a href=mailtoave@internationalbid.com>Dave@internationalbid.com</a><br>ICQ VFP ActiveList #46145644[/sig]