Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Data loss using REPORT TO FILE ASCII
Message
From
18/01/2003 11:42:08
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
18/01/2003 10:11:38
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00741527
Message ID:
00743146
Views:
27
SET TEXTMERGE TO test.txt noshow
SET TEXTMERGE on
select test
locate
lnGroup1ID = IDField
lnGroupSum = 0 && Sample group sum
scan
if IDField # lnGroupID && New group encountered
\Group info here - Group Sum : <>
*Group operations - reset etc
lnGroupSum = 0
lnGroupID = IDField
endif
\<>
\
\
\<>
\
\<>
lnGroupSum = lnGroupSum + FieldToSum
endscan
SET TEXTMERGE to
SET TEXTMERGE off
MODIFY COMMAND test.txt
Cetin


>I have free data groups in report in which results are summed.
>How to emulate data grouping ?
>
>>>>I see now. Sorry have no idea. I never trust report when it's ASCII and roll my own text merging.
>>>
>>>Do you have some templates which drive text merging routines ?
>>
>>Nothing special. For your report it might look like :
>>
>>
>>select test
>>SET TEXTMERGE TO test.txt noshow
>>SET TEXTMERGE on
>>scan
>>  \<<f1>>
>>  \
>>  \
>>  \<<f2>>
>>  \
>>  \<<f3>>
>>endscan
>>SET TEXTMERGE to
>>SET TEXTMERGE off
>>MODIFY COMMAND test.txt
>>
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