MS Excel - Sort pivottable column headings by datehttp://mail.joellipman.com/articles/microsoft/excel/sort-pivottable-column-headings-by-date.html

12 April 2013 This is a quick note to myself so that I never use parentheses in the column headings again. Basically I have a pivot table in Microsoft Excel 2010 with the projects down the left (in the first column) and the days of the week along the top. Why? The...

• Type: Article
• Author: Joel Lipman
• Category: Excel
• Language: en-GB

Crystal Reports: Exporting to Excel omits column headershttp://mail.joellipman.com/articles/microsoft/excel/crystal-reports-exporting-to-excel-omits-column-headers.html

03 June 2010 on the exported report when we followed that suggestion. Consider the following report in design view, only the circled headings would appear on the exported report: The solution I found that worked for me, was to make all the heading boxes the same...

• Type: Article
• Author: Joel Lipman
• Category: Excel
• Language: en-GB

Include a carriage return in a column headinghttp://mail.joellipman.com/articles/microsoft/sql-server/include-a-carriage-return-in-a-column-heading.html

07 July 2014 Text". The difference the above does, is that when you refresh the data, it will retain the carriage return in the column headings. Additional: Only appears obvious in SQL Server Management Studio resultset. Remember to format the cells (column...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server
• Language: *

ZohoCRM: Import Attachmentshttp://mail.joellipman.com/articles/crm/zoho/zohocrm-import-attachments.html

16 January 2023 GuiControlGet, v_FolderToSearch, , MySelectedFolder v_FilesCopied := 0 v_FilesTotal := 0 ; attachments csv headings v_CsvLine := "Attachment Id,Attachment Owner Id,Modified By Id,Created By Id,Created Time,Modified Time,File Name,Parent Id`r`n"...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

SSIS Skip Rows in Excel Source filehttp://mail.joellipman.com/articles/microsoft/ssis/ssis-skip-rows-in-excel-source-file.html

04 April 2013 row unspecified - used if I don't know how many rows there will be and if I want them all. NOTE: If you don't use column headings, F1 is the first column of the data range and NOT the first column of the data sheet (eg. F1 = B11) !!! Additional We add a...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Integration Services
• Language: en-GB

Joes Quicklist Weblinks (JQW) Downloadshttp://mail.joellipman.com/component/content/article/joes-quicklist-weblinks-jqw-downloads.html?catid=92

07 September 2015 and auto-scroll - Date Uploaded: Sat, 3rd Sep 2011 2.0.5 beta- Parameters: Grid Mode - sortable, column details, headings, text width. - Date Uploaded: Sat, 3rd Sep 2011 2.0.4 beta- Parameter: Slideshow Mode (by Ryan Florence v2.1) or Grid Mode. -...

• Type: Article
• Author: Joel Lipman
• Category: Downloads
• Language: *

MacOs: Transcribe Training Video using OpenAI Whisperhttp://mail.joellipman.com/articles/apple/macos-transcribe-training-video-using-openai-whisper.html

23 June 2025 it the following prompt: Attached is a transcript from a training session on [Topic] - Day 3. Can you rewrite this using headings and punctuation so that it makes sense to other trainees reading it? Rephrase where necessary and include details from the...

• Type: Article
• Author: Joel Lipman
• Category: Apple
• Language: *