SSRS Zero Paddinghttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-zero-padding.html

10 November 2011 strings to exceed 5 characters. The Oracle Error Value Returning just the 5 digits of the oracle error code without the minus/hyphen in front. =IIF( Fields!ERROR_CODE.Value="SUCCESS", "Success", Right( "00000" & Replace(...

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

Battery Constantly Drained on iPhonehttps://www.joellipman.com/articles/apple/battery-constantly-drained-on-iphone.html

27 November 2012 a full charge and knew how to close apps running in the background (double-click "home" button and hold down app until red minus buttons appear, tap red button)... I wouldn't usually take notice but I think this is a brilliant example where trying to...

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

Split a row into multiple rows based on a column valuehttps://www.joellipman.com/articles/database/t-sql/split-a-row-into-multiple-rows-based-on-a-column-value.html

23 August 2013 3 003 2.00 1999-02-25 1.00 1 003 2.00 1999-02-25 1.00 2 Great! Now let's just add the Rownum value to the date of sickness (minus 1 for obvious reasons - 25th + row(1) = 26th when the person was off the 25th): SELECT EmployeeNo , '1' +...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• Language: *

AHK Countdown Tooltiphttps://www.joellipman.com/articles/automation/autohotkey/ahk-countdown-tooltip.html

17 July 2014 ?"":"s") " and " ThisManyMinutesRemainder " second" ( ThisManyMinutesRemainder==1?"":"s") ; WORKING TOTALS ; minus weekends, sleep and time not at work ThisManyWorkingSeconds:=DateDiff( A_Now, FinalDate, "s" ) - ((ThisManyDays - (ThisManyWeeks*2)) *...

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

Android: Function to let user take photo or choose existinghttps://www.joellipman.com/articles/google/androidos/android-function-to-let-user-take-photo-or-choose-existing.html

04 November 2014 myPhotoImage.setImageBitmap(BitmapFactory.decodeFile(picturePath)); } } Just in case The ImageView I have (minus the width, height, margins, etc): Additional To check if the user has a camera beforehand, apparently...

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

Zoho CRM: Schedule a Task: Timesheet Reminderhttps://www.joellipman.com/articles/crm/zoho/zoho-crm-schedule-a-task-timesheet-reminder.html

02 December 2021 given it the following scopes: ZohoCRM.modules.ALL ZohoCRM.users.READ ZohoCRM.coql.READ // // set to the number of hours minus the ones to be logged on Friday (40 - 8) v_RemindeMeAtHoursLogged = 32; // // set to the Account record of our organization...

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

Zoho Deluge: a HTML Entity Decoderhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-a-html-entity-decoder.html

27 January 2022 ...

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

Zoho Creator: Radio group into Calendar Carouselhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-radio-group-into-calendar-carousel.html

09 March 2022 of Calendar Day Select). The key to remember here is that it isn't a week commencing date but more like the today's date minus 7 or plus 7 days depending on which way they navigate. We then need the offset so that when a user clicks on the #9 entry, the...

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