General information
Category:
Coding, syntax & commands
One easy way is to separate out the field when preparing your cursor into something like UserArea then group on that cursor field. The report will never know if the data is from a table or a cursor.
>I want to group items in a report by not a field but
>a part of field. For example useid is 12 digit number
>and 5th to 6th position indicate the are of this user.
>I want put sql code like Group by substr(userid,5,2).
>I tried that but VFP 6 does not seem to like it.
>Column not found error message comes on. Off cause
>this could be FoxFire's(I am beta testing Fox Fire)
> limitation that I don't know about.
>May be my approach is not permissable. If so is there
>any trick I can use to achieve this end.
>Thanks for your help always.
>
>Aiko Ichimura
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only