Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Cross-tabular report - how to show fields in order
Message
De
03/11/2008 06:05:47
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Stonefield
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP
Network:
Windows 2003 Server
Database:
MS SQL Server
Divers
Thread ID:
01358996
Message ID:
01359101
Vues:
29
This message has been marked as a message which has helped to the initial question of the thread.
>Hi everybody,
>
>In our data file we have events such as "DN006", "DIN06", "DIN07". I want to create a cross-tabular report to show information for these events. We want DIN07, then DN006, then DIN06. However, I can not figure out how to place these fields in that particular order. I chose Cross-tabular report from New report menu, added filter for these 3 event types and the output looks like
>
>Name       DIN06     DIN07     DN006   Total
>
>How can I specify in my report that I want to show these fields in the particular order?
>
>Thanks a lot in advance.

If you don't want to roll your own cross tabber then selecting from its result cursor would do. ie:
select Name, DIN07,DN006, DIN06, ... from xtab ... into cursor myXTab nofilter
PS: OTOH I don't think physical layout has an importance unlees you are creating quick reports.
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform