Win32 Constantshttps://www.joellipman.com/articles/automation/autohotkey/win32-constants.html

05 July 2011 = (TVN_FIRST-53) Const TVN_ITEMEXPANDINGA = (TVN_FIRST-5) Const TVN_ITEMEXPANDINGW = (TVN_FIRST-54) Const TVN_ITEMEXPANDEDA = (TVN_FIRST-6) Const TVN_ITEMEXPANDEDW = (TVN_FIRST-55) Const TVN_BEGINDRAGA = (TVN_FIRST-7) Const TVN_BEGINDRAGW =...

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

SSRS Expand specific drilldown by defaulthttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-expand-specific-drilldown-by-default.html

23 February 2011 specifies some room bookings for a particular week. When I open the report, each drilldown row is collapsed (as opposed to expanded). The user can specify the date as it's a report parameter. What we want The user will select a date. We want the report...

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

MySQL parameters in Excel 2007 PivotTableshttps://www.joellipman.com/articles/database/mysql/mysql-parameters-in-excel-2007-pivottables.html

24 August 2011 in non Microsoft technology. Limitations of Excel 2007 PivotTables Aesthetics: Drilldown bolded items are NOT the sum of a expanded node. (despite no line separator or the totalled value in the corresponding row) Show this week date range by default Use...

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

Search a database for a string (MySQL, T-SQL)https://www.joellipman.com/articles/database/search-a-database-for-a-string-mysql-t-sql.html

08 October 2012 paste into your SQL administration software. You can put a distinct on it (not forgetting the collate). This example is expanded in a further article called "Search a database with soundex": /* USING A CURSOR */ DECLARE @SqlToExecute nvarchar(max);...

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