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

I don't have a bit idea about it. Since there is 'Query' in name then probably it let's to create queries.
Cetin