Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Dataenvironment
Message
From
17/09/2002 14:52:25
 
 
To
17/09/2002 14:34:45
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Title:
Miscellaneous
Thread ID:
00701380
Message ID:
00701435
Views:
18
Assuming you have some type of primary key in the table, why not just use the 'for' clause in the report command. For instance, if on the form the record pointer is already possitioned where you want it to be, grab the unique value for that record and use something like the following in the form's print button:
LOCAL lcwkrec
* the value in the txtwkmaster_cwknumber textbox is a unique key value
* the table's name is wkmaster and the unique field is cwknumber
lcwkrec=thisform.txtwkmaster_cwknumber.value
REPORT FORM ;
wkmasterworkorderexistreport ;
FOR wkmaster.cwknumber=lcwkrec ;
NOCONSOLE ;
TO PRINT
Also, ensure you are NOT using a private datasession in the report's dataenvironment (set it to default). You do not have to have tables in the datasession at all when you run the report this way. I put NO tables in the report's dataenvironment (because they are already open in the form's dataenvironment) and set autoopentables and autoclosetables of the report's dataenvironment to .F. and then use code similar to the above to print the current record displayed on the form.

>Larry,
>
>I am having a problem getting the report writer to print the right record. On my form I migragte to the record I want press a button on the form that is Report Form my.frx Preview. For some reason the first record is in the preview.
.·*´¨)
.·`TCH
(..·*

010000110101001101101000011000010111001001110000010011110111001001000010011101010111001101110100
"When the debate is lost, slander becomes the tool of the loser." - Socrates
Vita contingit, Vive cum eo. (Life Happens, Live With it.)
"Life is not measured by the number of breaths we take, but by the moments that take our breath away." -- author unknown
"De omnibus dubitandum"
Previous
Reply
Map
View

Click here to load this message in the networking platform