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

07 July 2014 16-Jul-2014 17-Jul-2014 18-Jul-2014 2 21-Jul-2014 22-Jul-2014 23-Jul-2014 24-Jul-2014 25-Jul-2014... How? To do this in a select query resultset, you insert the special character references "CHAR(10)" [line feed] and "CHAR(13)" [carriage return] but to...

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

AutoHotkey: Check Windows Folder Sizeshttps://www.joellipman.com/articles/automation/autohotkey/autohotkey-check-windows-folder-sizes.html

28 January 2019 ; Subroutine: ButtonBrowse: Onclick allows user to select a folder to scan ButtonBrowse: FileSelectFolder, vSelectedFolder, 3, , Select a folder if vSelectedFolder = MsgBox, You didn't select a folder. else { vSelectedFolder :=...

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

Zoho Deluge: Setup an API Connection for InvokeURLhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-setup-an-api-connection-for-invokeurl.html

12 August 2020 EU datacenter: https://api-console.zoho.eu/ If this is your first app, then click on "Get Started" and select "Server-based Applications" by clicking on "Create Now" on the appropriate box. If this is not your first app, just select "Server-based...

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

Zoho CRM & Zoho Writer: Button to Merge Template, Send, and Attachhttps://www.joellipman.com/articles/crm/zoho/zoho-crm-zoho-writer-button-to-merge-template,-send,-and-attach.html

21 October 2021 then has to click on various settings and run the Mail Merge; then has to click on "execute function after merge" and select the function to run (this would initially attach the file to the CRM record). This wasn't working really as there are issues...

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

Zoho Creator/Deluge: UnPredictable exception, Invalid statement foundhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-deluge-unpredictable-exception,-invalid-statement-found.html

17 November 2021 the following code which loops through some Creator records, then loops through one of the subforms in each record: // select a bunch of creator records (ok all of them) l_AllRecords = myForm[ ID != 0 ]; // // loop through these for each r_Record in...

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

ZohoCRM & Xero Real-Time Invoices: Receive Webhookhttps://www.joellipman.com/articles/crm/zoho/zohocrm-xero-real-time-invoices-receive-webhook.html

10 January 2022 Save this and return to the list of functions Hover over the function you just created, click on the 3 dots/ellipsis and select "REST API" Switch on the API Key and copy the URL to clipboard or a text editor Click on "Save" Setup a Xero webhook: Login...

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

GoDaddy Apache cPanel: Install SSL Certificatehttps://www.joellipman.com/articles/linux/cpanel/godaddy-apache-cpanel-install-ssl-certificate.html

07 April 2022 down to SSL Certificates and click on the "Manage" button alongside the domain you want to install the SSL certificate for Select the Server Type and then click on "Download Zip File" button Decompress the ZIP and find the CRT file Return to your...

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

Amazon Kindle: Send PDFs to your Kindlehttps://www.joellipman.com/amazon/kindle/amazon-kindle-send-pdfs-to-your-kindle.html

29 June 2022 under Finding your Kindle email address. However, click on Preferences this time, instead of Devices. Scroll down and select the Personal Document Settings Scroll down again and select the Approved Personal Document E-mail List. This is the list...

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

ZohoAnalytics: Pivot Campaigns vs Contactshttps://www.joellipman.com/articles/crm/zoho/zohoanalytics-pivot-campaigns-vs-contacts.html

20 March 2023 join this to the contacts data table. So I'm going to make this first query and save it as "Contacts vs Campaigns Pivot": SELECT * FROM ( SELECT "Contact Id", "Contact Name", "Campaign Name", "Member Status" FROM "Campaign Members - Contacts" ) t1 PIVOT...

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

Reminder on SSRS row separatorhttps://www.joellipman.com/articles/microsoft/ssrs/reminder-on-ssrs-row-seperator.html

26 October 2011 level solution and can follow these quick steps: Right-click the grey header of the tablix row (left-most grey part) Select "Add Group" then "Parent Group..." Specify the "Group by" (in my case "Day"), the grey part will display a grouping icon Now...

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

SSIS: Add Reference Microsoft.SqlServer.TxScripthttps://www.joellipman.com/articles/microsoft/ssis/ssis-add-reference-microsoft-sqlserver-txscript.html

03 June 2014 so why should their documentation include it? Workaround (applies for any dll) You right-click on the "references" folder, Select "Add Reference..." Click on "Browse..." Navigate to C:\Windows\assembly Select the TxScript one in...

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

Zoho Deluge: Push Multi-Select Picklist containing Commas from CRM to Creatorhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-push-multi-select-picklist-containing-commas-from-crm-to-creator.html

20 April 2020 A very quick article on how to push a multi-select picklist from CRM to Creator. Why? We're trying to create a record in Creator off a button on the CRM Potential/Deal record. The CRM module has a multi-select picklist which will use commas to delimit...

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

View your available module positionshttps://www.joellipman.com/articles/cms/joomla/view-your-available-module-positions.html

15 September 2009 for you try this: Log in to the backend of your website (into the Joomla Admin Panel) Go to Extensions > Template Manager > select your template Click on the big Preview button in the top right Click on the link 'Show in New Window' Bookmark the web...

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

Keyboard and mouse shortcuts in Google Chromehttps://www.joellipman.com/articles/google/keyboard-and-mouse-shortcuts-in-google-chrome.html

23 September 2009 Ctrl+N Opens a new window. Ctrl+T Opens a new tab. Ctrl+Shift+N Opens a new window in incognito mode. Press Ctrl+O, then select file. Opens a file from your computer in Google Chrome. Press Ctrl and click a link. Or click a link with your middle mouse...

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

Uninstalling AEC Central and installing Community Builderhttps://www.joellipman.com/articles/cms/joomla/uninstalling-aec-central-and-installing-community-builder.html

20 January 2010 16. Tick mod_acctexp (if you installed this) and Uninstall. 17. Click on the Components link (to uninstall components) 18. Select AcctExp and click on the Uninstall icon. Now install Community Builder 1. Download the latest version from Joomlapolis.com...

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

Windows 7: System Clock is constantly going out of synchttps://www.joellipman.com/articles/microsoft/windows-os/windows-7-system-clock-is-constantly-going-out-of-sync.html

28 January 2010 Internet Time Click on the Change Settings button Check the box next to Synchronize with an Internet time server is ticked Select an option from the dropdown menu starting with the first Click on the Update now button Text will appear beneath the button...

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• Language: *

Windows Live Messenger: Error 80048820https://www.joellipman.com/articles/microsoft/windows-os/windows-live-messenger-error-80048820.html

08 March 2010 Internet Time Click on the Change Settings button Check the box next to Synchronize with an Internet time server is ticked Select an option from the dropdown menu starting with the first Click on the Update now button Text will appear beneath the button...

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

Windows 7 Aero Featureshttps://www.joellipman.com/articles/microsoft/windows-os/windows-7-aero-features.html

27 April 2010 see a list of visual effects, some of which will be unchecked if you are not experiencing the full range of Aero features. Select the custom option and then select all the effects from the list below it. Hit apply and ok and you should have all the Aero...

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

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

03 June 2010 extra gridlines (the ones that appear in the ruler as little arrows). So right-click on a heading text box that works Select "Size and Position..." Copy to clipboard the exact height value Right-click on a faulty heading textbox Select "Size and...

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

Create Read-Only Database User in SQL Serverhttps://www.joellipman.com/articles/database/create-read-only-database-user-in-sql-server.html

09 November 2010 Security > Logins. Right-click on the user who will be set as having read-only access (in this example "adventureworksro"). Select Properties. Select User Mapping. Map the login to the database they will have access to. Tick the boxes for role...

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