Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Creating Reports Programmatically
Message
 
 
To
27/07/2001 07:55:41
General information
Forum:
Visual FoxPro
Category:
Classes - VCX
Miscellaneous
Thread ID:
00535796
Message ID:
00536419
Views:
37
This message has been marked as the solution to the initial question of the thread.
>Sergey,
>
>Thanks for your advice. I tried this all day yesterday with no success. I did notice that the width column in the .frx file shows up as -1 when I create the report file with the sfrepobj.vcx and 50389.000 when I use the report wizard. I have tried changing the .frx file created with sfrepobj.vcx to match but this does not seem to work. On the bright side, I have learned quite a bit about .frx files and how they work. If you can think of anything else please let me know.
>
>Thanks again for your help,
>Russell

Here the code that'll fix your generated report to print two columns. You'll have to figure out how to calculate WIDTH (43125.000) in generic way.
select 0 
use print.frx alias old
copy to print2.frx
use
select 0
use print2.frx excl alias new

GO top 
Replace WIDTH  with 43125.000

Locate For objtype=9 and objcode = 1
insert blank 
Replace platform with "WINDOWS", ;
	uniqueid WITH SYS(2015), ;
	objtype with 9, ;
	objcode with 2, ;
	pagebreak with .t.

Locate For objtype=9 and objcode = 4
insert blank 
Replace platform with "WINDOWS", ;
	uniqueid WITH SYS(2015), ;
	objtype with 9, ;
	objcode with 6

USE
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform