>>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

I'm creating quick reports using Stonefield Query. I'm not sure how to apply your suggestion for this tool.