Search for content in message boards

Exporting a custom report to Excel

Replies: 45

Re: Exporting a custom report to Excel

Posted: 1303307089000
Classification: Query
Edited: 1303307195000
I've never seen a problem with the info in columns going to the wrong column. That's not to say that a certain combination of circumstances could make that happen.

The only problem I've seen is breaking down data inside the columns, but that is easily handled (usually) with the Excel "Text to Columns" capability. For example, the export puts city, county, state, and country in the same column. You have to use text-to-columns capability of your spreadsheet to break those columns down - which is a problem because that capability usually goes left to right - which means Brooklyn, New York in first two columns, while Brooklyn, Kings Co, New York will be in first three columns from left; which means New York state will be in different columns.
SubjectAuthorDate Posted
rfaulk7002 1303301641000 
silverfox3280 1303307089000 
rworthington 1303310793000 
rfaulk7002 1303330986000 
rworthington 1303343233000 
silverfox3280 1303350129000 
rfaulk7002 1303391691000 
silverfox3280 1303392848000 
rworthington 1303395592000 
rfaulk7002 1303587623000 
per page

Find a board about a specific topic