Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Auto Reports?
Message
From
10/02/1999 07:21:24
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
10/02/1999 07:05:35
Mark Hall
Independent Developer & Voip Specialist
Keston, Kent, United Kingdom
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Title:
Miscellaneous
Thread ID:
00185875
Message ID:
00185883
Views:
18
>>>I have data in a table and want to produce a simple report automatically. What is the best way?
>>>
>>>Is it possible to use the Report Wizard programatically?
>>>Does anyone know of a VFP code Report Generator?
>>>
>>>TIA
>>>Mark HAll
>>Mark,
>>If it's just a plain form or column style report, then you could use quick report :
use mytable
>>create report myreport from mytable column
>>*modify report myreport && If you want to play with it
>>report form myreport preview
Cetin
>
>Thanks Cetin,
>
>The simplest ideas are usually overlooked.
>OK, Now what if I need a little more control?
>
>I can set the paper orientation by using API calls to the printer driver.
>
>The only other 'Nice to have' here would be the ability to set the default fontname and fontsize.
>
>Any ideas?
Instead of default it could be set later :
use myreport.frx
replace fontface with lcMyFontName, ;
   fontsize with lnMySize ;
   for !empty(fontface)
go top
lcOrientation = "1" && 0-Portrait 1-Landscape
lcExpr = stuff(Expr,at("ORIENTATION=",Expr)+len("ORIENTATION="),1,lcOrientation)
replace expr with lcExpr
use
report form myreport prev
Also in record 1, if you blank expr,tag, tag2 fields then you could use current printer settings (or the one set via sys(1037), getprinter() etc). I think genrepox (I currently don't know where to find it) has more info about objects.
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Reply
Map
View

Click here to load this message in the networking platform