SSRS Zero Paddinghttp://mail.joellipman.com/articles/microsoft/ssrs/ssrs-zero-padding.html

10 November 2011 log displaying the oracle errors. Oracle Errors An Oracle error usually returns in the format of -12345. If we want to look them up the error is ORA-12345. Unfortunately Oracle also returns errors of less than 10000 so ORA-00201 would actually be...

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

How to Display Report Execution Time in SSRS (milliseconds)http://mail.joellipman.com/articles/microsoft/ssrs/how-to-display-report-execution-time-in-ssrs.html

17 November 2011 Create another dataset (would have to be the first dataset to load so you would need delete your current datasets then add them in the order you want them to load) to get the timestamp of when the queries started. IIF your result row count, if it's...

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

Administrator Program Shortcut without Prompthttp://mail.joellipman.com/articles/microsoft/windows-os/administrator-program-shortcut-without-prompt.html

25 February 2013 rights/privileges when run. This is so that these programs can write back and forth to our C drive. If we don't run them as local administrators on the workstation, they error incessantly and never manage to do what you want them to do. What? I want to...

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

Parse a HTML Table into a ListViewhttp://mail.joellipman.com/articles/web-development/html/parse-a-html-table-into-a-listview.html

30 March 2013 a ListView. Why? I want a snippet of code that replicates any HTML table. How? I've been trying various ways so I'm posting them here. My opinions on them change with the weather so until I do some benchmarking I won't know which ones best: Method #1...

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

T-SQL functions to convert Strings to Tableshttp://mail.joellipman.com/articles/database/t-sql/t-sql-functions-to-convert-strings-to-tables.html

20 August 2014 to: Microsoft SQL Server 2008 R2 Microsoft SQL Server 2012 What? These were in a solution and I thought I'd note them on my site so I can refer to them more easily. How? Let's start with a function that just converts a string of words delimited by...

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

Minimal Privileges for MySQL Database Backup Cron Jobhttp://mail.joellipman.com/articles/linux/cpanel/minimal-privileges-for-mysql-database-backup-cron-job.html

20 March 2019 my_db > /path_to/backup.sql // and in your cnf file: [mysqldump] user=my_user password=my_password The one to rule them all: // everything: using external file, suffixing date and compressing: mysqldump --defaults-file=/full-path-to/.my.cnf my_db | gzip...

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

Zoho Creator: Receive eBay Order Notifications via Webhookhttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-receive-ebay-order-notifications-via-webhook.html

20 September 2021 Enable Auth'n'auth (Authentication and Authorization) Process Not getting notification via the URL but you are getting them via email? Well I read somewhere you need to use Auth'n'auth to enable these notifications if you don't want to sit on a call...

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

Zoho CRM & Zoho Books: Get Books Currency and Tax IDshttp://mail.joellipman.com/articles/crm/zoho/zoho-crm-zoho-books-get-books-currency-and-tax-ids.html

24 September 2021 How? Using the REST API and InvokeURL in Zoho Deluge to look at Zoho Books. This uses up an extra 2 calls so you could run them once, store them as a map on your function if you don't want to use up these 2 every time your sales team push a CRM Sales...

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

Joel's Reference to MidJourney v4 Promptshttp://mail.joellipman.com/graphic-design/joel-s-guide-to-midjourney-prompts.html

11 February 2023 Ratio --ar 1:1 --ar 16:9 --ar 2:3 --ar 3:2 --ar 4:3 Other worthwhile mentions The following are to add to your subject theme and again, I'm only trying to list ones that produced the desired effect: Famous Shows in the style of... Note that these are...

• Type: Article
• Author: Joel Lipman
• Category: Graphic Design
• Language: *

Zoho Analytics: Create a Monitoring System with Imageshttp://mail.joellipman.com/articles/crm/zoho/zoho-analytics-create-a-monitoring-system-with-images.html

25 July 2024 called "Untitled-1". I enter some labels in the first column. These will be keys later on to link my report to so keep them short without any special characters. I then saved this table with the name "Joels Image Library". I think I closed it and...

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

Upgrading Joomla CMS version 3.x to Joomla CMS 5.xhttp://mail.joellipman.com/articles/cms/joomla/upgrading-joomla-cms-version-3-x-to-joomla-cms-5-x.html

04 February 2025 ALL articles I noticed that if I search for some of my articles, they weren't appearing in the smart search but I could see them in the category blogs. Login to Administrator > Components > Smart Search > Index Click on the "Index" button in the toolbar...

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

GDPR Privacy Policyhttp://mail.joellipman.com/static-items/gdpr-privacy-policy.html

14 February 2019 you subject to the following conditions. If you visit or shop within this website, you accept these conditions. Please read them carefully. Privacy Please review our Privacy Notice, which also governs your visit to our website, to understand our...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *

Disclaimerhttp://mail.joellipman.com/static-items/disclaimer.html

30 May 2009 of those sites. The inclusion of any links does not necessarily imply a recommendation or endorse the views expressed within them. Every effort is made to keep the website up and running smoothly. However, Joel Lipman .Com takes no responsibility for,...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *

This file contains HTML or script code that may be erroneously interpreted by a web browserhttp://mail.joellipman.com/articles/web-development/html/this-file-contains-html-or-script-code-that-may-be-erroneously-interpreted-by-a-web-browser.html

08 October 2009 'ppt', 'xls', 'mpp', 'pdf', 'zip', 'flv', 'swf'); Online forums are saying this is it, but my system still didn't allow them and returned the above error... Secondly: Edit your /includes/specials/SpecialUpload.php file and add the following line shortly...

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

Change default order of weblinkshttp://mail.joellipman.com/articles/cms/joomla/change-default-order-of-weblinks.html

15 November 2009 DESC on line 187: $listOrder = JRequest::getCmd('filter_order_Dir', 'ASC'); Note: If you do not use any of these or mistype them, the Joomla! CMS has included code so that weblinks automatically switch to "ordering".

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

Running Internet Explorer 6, 7, 8 as standaloneshttp://mail.joellipman.com/articles/microsoft/windows-os/running-internet-explorer-6-7-8-as-standalones.html

18 May 2010 Intro I know there are a lot of articles on the WWW detailing this process but none of them really worked for me. I recently changed job and no longer have all my test machines at work. Instead I only have the one workstation :eek Still I've been asked...

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

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 the column headers appear, then try this: I googled this for ages and found different suggestions here and there but none of them produced consistent results. One solution was to untick "Simplify page headers" on the Excel Format Options when you export...

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

Webdeveloper-Speakhttp://mail.joellipman.com/articles/web-development/webdeveloper-speak.html

13 July 2010 or purchased by the US Federal Government is accessible by people with disabilities. I'm going to stop there but do check them out at http://www.motive.co.nz/index.php

• Type: Article
• Author: Joel Lipman
• Category: Web-Development
• Language: *

Change the login link in MediaWikihttp://mail.joellipman.com/articles/cms/mediawiki/change-the-login-link-in-mediawiki.html

22 September 2010 to staff and different localgroups. When users click on the 'Login' link, we want the system to automatically prompt them for their username/password. (Kerberos authenticated, as opposed to NTLM authenticated). Note: This article is displaying how to...

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

Accessing a MySQL Database with Business Intelligence Development Studiohttp://mail.joellipman.com/articles/database/mysql/accessing-a-mysql-database-with-business-intelligence-development-studio.html

05 January 2011 machine, or enable remote errors I fixed this by repeating stages 1 and 2 (above) on the Reporting Server. Ensure you name them the same thing as you did in the report. I am looking at ways of doing this without logging into the reporting server or...

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