Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Sort data report
Message
From
26/05/2004 00:17:20
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
 
To
26/05/2004 00:10:00
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00907178
Message ID:
00907179
Views:
11
Why do you use arrays? I think it is much easier to report directly from a cursor.

For example:
select * from ProductsBought where client = "joe";
  order by Description;
  into cursor temp
report form MyReport
You would put information for the products in the detail band of a report. The detail band will repeat automatically, once for each record.

>peace!!!
>im using an array in my report, and i wanted to sort my records based on the product id of the customer.
>
>for example: joe purchased 10 items. and on my report i wanted that the items will be sorted according to their product id.
>
>my code:
>
>if alen(alltrim(prod_id))>0
> n=n+1
> aPurchased[n] = prod_name
>endif
>
>
>report:
>
>aPurchased[1]
>aPurchased[2]
>...
>..
>...
>and so on...
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform