Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Data loss using REPORT TO FILE ASCII
Message
From
14/01/2003 13:21:55
 
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00741527
Message ID:
00741555
Views:
17
I have a report (www.eetasoft.ee/reporttoascii.zip) containing
only three fields in detail part stating at
left side of report:

f1

f2

f3

there is a lot of space between lines.
There are no other pands, page header and page footer bands have zero lenght.

It is interesting that this problem starts if I use

FOR i=1 TO 20

If I use

FOR i=1 TO 19

or fewer records, all is ok.
It is also OK if I use only a single field

f1

in detail band.




>Not quite clear why expected value is 3*recc(). Depends on what do you have in the report form 'test'.
>
>>Report used in the followng code is available at
>>www.eetasoft.ee/reporttoascii.zip
>>This is very simple report containing only three fields
>>having plenty of empty space.
>>
>>To reproduce, run the following program:
>>
>>CREATE TABLE test ( f1 c(1), F2 C(1), F3 C(1) )
>>APPEND BLANK
>>
>>FOR i=1 TO 20
>>  COPY TO t
>>  APPEND FROM t
>>  ENDFOR
>>
>>REPLACE ALL f1 WITH TRANSFORM(RECNO()%10), ;
>>     f2 WITH TRANSFORM((RECNO()+1)%10), ;
>>   f3 WITH TRANSFORM( (RECNO()+2)%10)
>>
>>REPORT FORM test TO FILE test ASCII
>>CREATE TABLE test1 ( f1 c(10) )
>>APPEND FROM test.txt SDF FOR !EMPTY(F1)
>>
>>MESSAGEBOX( 'Expected '+TRANSFORM(3*RECCOUNT('test')) + CHR(13)+ ;
>>   'Actual ' +TRANSFORM(RECCOUNT('test1')) )
>>
>>
>>Observed result:
>>
>>Expected: 3145728
>>Actual: 2752428
>>
>>
>>Expected result:
>>
>>numbers in message box must be same.
>>
>>
>>Is it possible to fix this problem so that data loss does not occur ?
Andrus
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform