Search for content in message boards

Exporting a custom report to Excel

Replies: 45

Re: Exporting a custom report to Excel

Posted: 20 Apr 2011 7:44AM GMT
Classification: Query
Edited: 20 Apr 2011 7:46AM GMT
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 20 Apr 2011 12:14PM GMT 
silverfox3280 20 Apr 2011 1:44PM GMT 
rworthington 20 Apr 2011 2:46PM GMT 
rfaulk7002 20 Apr 2011 8:23PM GMT 
rworthington 20 Apr 2011 11:47PM GMT 
silverfox3280 21 Apr 2011 1:42AM GMT 
rfaulk7002 21 Apr 2011 1:14PM GMT 
silverfox3280 21 Apr 2011 1:34PM GMT 
rworthington 21 Apr 2011 2:19PM GMT 
rfaulk7002 23 Apr 2011 7:40PM GMT 
per page

Find a board about a specific topic