SSRS External Images don't displayhttp://mail.joellipman.com/articles/microsoft/ssrs/ssrs-external-images-dont-display.html

19 September 2011 display when they are provided over an authenticated URL (You shouldn't be having any issues with this if the image is available to anonymous users - eg. Google Logo). Our Setup Windows XP Workstation Business Intelligence Development Studio 2008 (BIDS)...

• 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 confusing the end-user... Workaround #1 Although I'm convinced of a solution considering the ReportServer database will be able to tell you how many milliseconds it took for a report to execute... I decided to do a database level calculation using two...

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

Performance Report - Background colors based on dataset valueshttp://mail.joellipman.com/articles/microsoft/ssrs/green-red-background-colors-based-on-dataset-values.html

02 December 2011 2008 R2 (SSRS) which will compare up to 4 reports and will compare the time taken for each one. The breakdown or what I was able to measure with the default installation are the times taken for "data retrieval", "processing", "rendering", and then the...

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

DataJumble - Shuffling characters in a data valuehttp://mail.joellipman.com/articles/database/t-sql/data-shuffling-function.html

01 August 2012 1926-01-02 2 lgreg BFdos 1969-03-14 3 onrUest ehAr 1968-05-05 4 otentre AhYe Usr 1964-08-08 Precursor You will need to be able to create the following view to generate random numbers on SQL Server. -- Used to reference RAND with in a function CREATE...

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

Basic Joomla 2.5 Mootools Formhttp://mail.joellipman.com/articles/cms/joomla/basic-joomla-25-mootools-form.html

20 August 2012 Basic Mootools Form in Joomla 2.5 Name: E-Mail: Sample CheckBox: Sample SelectList: yes no Ajax Response Ready, Willing and Able Big Note: UPDATE 2012 It is important to refer to the correct mootools scripts in order for this to work. Unfortunately,...

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

Search a database for a value and count matching rowshttp://mail.joellipman.com/articles/database/search-a-database-for-a-value-and-count-matching-rows.html

05 November 2012 We have a datawarehouse and we want to be able to count all the records in any table of the database that match on a particular warehouse load. This is a column value where the column is called "WarehouseLoadKey" and the value we want to search on is...

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

DataScramble - Randomizing data rowshttp://mail.joellipman.com/articles/database/t-sql/datascramble-randomizing-data-rows.html

07 December 2012 Along with my DataJumble function and DataTumble procedure which also help scramble database tables sent to suppliers/developers, this is a function which simply finds random characters and inserts these. I would recommend using the DataTumble script...

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

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

25 February 2013 environment and we get prompted to login (with the same account as we're currently logged-in with???) instead of being able to just click on "Yes". How? The gist is that we're going to create a scheduled task (that won't be scheduled) and a shortcut to...

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

Generate a Timesheet in MySQL http://mail.joellipman.com/articles/database/mysql/generate-a-timesheet-in-mysql.html

05 December 2013 slots. All days and time slots must be listed irrespective of whether any time has been associated to them. We need to be able to specify any date, and the system returns the timesheet for the week that date occurs in. How? The example below shows how...

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

SSRS: Performance Improvements: SELECT TOPhttp://mail.joellipman.com/articles/microsoft/ssrs/ssrs-performance-improvements-select-top.html

07 March 2014 improvement was the "SELECT TOP 100" brain wave: -- DataSet1: SELECT TOP 100 Reference, Forenames, Surname, DOB FROM PersonsTable WHERE (Reference = @GivenRef OR @GivenRef ='') AND (Forenames LIKE @GivenForenames + '%' OR @GivenForenames = '') AND...

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

SITS: Export field code and namehttp://mail.joellipman.com/articles/web-development/xml/sits-export-field-code-and-name.html

12 August 2014 to: Microsoft Windows 7 Enterprise SITS:Vision Students (v8.7.0) What? You might be able to work it out from the online manuals but it took me a while, we wanted to bring back both the code and the lookup value in our XML to our Staging environment....

• Type: Article
• Author: Joel Lipman
• Category: Extensible Markup Language
• Language: *

Autohotkey - Chrome Profiles in Alphabetical Orderhttp://mail.joellipman.com/articles/automation/autohotkey/autohotkey-chrome-profiles-in-alphabetical-order.html

07 January 2020 in alphabetical order and can be double-clicked to open the Chrome browser with that profile. How? So you will need to be able to run AutoHotkey or create executables from an AHK file. Here is the code that creates a GUI with a ListView with rows that...

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

Zoho Creator: Button on Report for Merging Multiple Selected Recordshttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-button-on-report-for-merging-multiple-selected-records.html

06 December 2020 saved in the system. Create the workflow Now go to a the "Design" mode of the report that contains the forms you want to be able to merge (multiple selection) and click on the "Actions" tab then on the 'plus' icon under "For Multiple Records" to add a...

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

Zoho Creator: Download File from ZohoCRM field type "File Upload" (not attachments)http://mail.joellipman.com/articles/crm/zoho/zoho-creator-download-file-from-zohocrm-field-type-file-upload-not-attachments.html

02 February 2021 usually a PDF) to a custom module in their CRM; I then need the customer from the customer portal in a ZohoCreator app to be able to download this file. How? The trick to doing this is that actually you have to treat it as an attachment. As you may...

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

Windows OS: Alt Codes / Symbols / Special Charactershttp://mail.joellipman.com/articles/microsoft/windows-os/windows-os-alt-codes-symbols-special-characters.html

03 June 2021 to demonstrate how to type special characters not found on your keyboard or on a Qwerty UK/US keyboard layout. Why? Being able to type international characters from other alphabets is necessary when dealing with languages other than English. Preserving...

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

Zoho CRM: Standard Setup for Tax Rateshttp://mail.joellipman.com/articles/crm/zoho/zoho-crm-standard-tax-rate-setup.html

02 September 2021 on "Save" and you've pretty much specified the tax rates that this CRM can use; but... do the next steps for users to be able to use these. Done, sorta To have this selectable for users in their transactional modules (quotes, sales orders, invoices,...

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

Zoho Creator: Copy Subform to other Subformshttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-copy-subform-to-other-subforms.html

17 November 2021 one subform to other subforms in the same form. Why? I'm creating an appointment/booking system and I want the user to be able to set entries in a subform called "Mondays" then to click a button which copies it to the remaining working days. How? So I...

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

Zoho CRM & Creator: Download attachment and upload to Creator file fieldhttp://mail.joellipman.com/articles/crm/zoho/zoho-crm-creator-download-attachment-and-upload-to-creator-file-field.html

11 March 2022 My use case here is that we are creating a Creator app that will show the attachments on a CRM contact record (and be clickable). The complication here is that the user can use the Creator form to add a new attachment that will eventually be uploaded...

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

PC Build 2022: 5 Monitors connected to 1 PC using 1 GPUhttp://mail.joellipman.com/pc-build-2022-5-monitors-connected-to-1-pc-using-1-gpu.html

12 March 2022 Cooler 1 £74.99 O/S Microsoft Windows 11 Pro 64-bit 1 £219.99 Case Fans CoolMoon 3 Pack 120mm Crystal 3 @£28.99 Monitor Cable KabelDirekt - DisplayPort to DVI adapter cable 2m dual link 1 £9.89 Additional iYueshare 120mm Magentic Mesh Filter Cover Grill...

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

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

07 April 2022 textarea field. Clicked on "Install Certificate" A popup confirmed the domain and then using other browser profiles, I was able to verify that SSL had successfully been applied...

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