Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Changing sort sequence of report at run-time
Message
From
03/03/2006 09:36:48
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
 
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01101024
Message ID:
01101223
Views:
10
>Hi All
>I've got a table driven Report shell form that I would like to add the capability to change a reports sort sequence at run-time (after selecting a report). Possibly click on a button to open a grid form showing all the Indexes available for the report selected. The user would click on the Index desired and click a close button. Then the form would sort the Cursor using the Index selected.
>Has anyone done this in vfp9?

No, I've done this in FPD2.6 :)

Essentially, I had three combos, where they could pick the first, second and third order field (out of four or five possible fields). The fields selected in the first would be grayed out in the second and third, and one selected in the second would also be grayed out in the third.

Then, based on the selection, I'd do a
select * from ... order by &fld1, &fld2, &fld3
and in the report itself, the outer group by expression was eval(fld1), middle eval(fld2), inner eval(fld2). The captions in group header and footer were composed using "total for "+fldname1+" "+fld1 etc.

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Previous
Reply
Map
View

Click here to load this message in the networking platform