Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to sort items in detail2 band of a report
Message
 
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Environment versions
Visual FoxPro:
VFP 9 SP1
Miscellaneous
Thread ID:
01160809
Message ID:
01160853
Views:
13
>I have a multi-detail band report. The target alias for band 2 (child band) is using an index tag on, say ORDER_NO. This is necessary for the SET RELATION statement of the parent alias (band 1) to work. But I want the report to show the items in the band 2 in a certain order (not just random order). For example, say I want the order to be by the PK value (ORDER_PK). I thought that I could create index tag on expression STR(ORDER_NO,6) + STR(ORDER_PK,6). I am not sure this will work and if it does, will it slow down the execution?
>
>Any suggestions, please?

If the fields are integer, you can also use BINTOC function instead of STR.
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform