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

17 November 2011 ) // yields // 00:00:02.1543570 -- problems with adding a string to it? CStr will not work, use .ToString ="Time Taken: " & ( CDate(Last(Fields!REPORTENDTIME.Value, "Dataset2")) - CDate(First(Fields!REPORTSTARTTIME.Value, "Dataset1")) ).ToString & "...

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

Joes FREE Website Thumbnailer (JWT)https://www.joellipman.com/component/content/article/joes-free-website-thumbnailer.html?catid=40

28 June 2011 image uses of disk space). Output Thumbnail File Type: can be BMP, GIF, JPG, PNG or TIF Time between page load and picture taken: in case your internet connection is slow, or your average website takes longer to load or not. The fastest it will go is 15...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

Room Availability Calendar in Business Intelligence Development Studiohttps://www.joellipman.com/articles/microsoft/ssrs/room-availability-calendar-in-business-intelligence-development-studio.html

23 March 2011 hours only as well... Ok I admit I only googled for about 1 hour before I gave up and just wrote my own. Saying that it's taken me 4 hours just to do the below... hopefully it will be quicker next time now that I noted it all down. The SQL Script:...

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

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

02 December 2011 a report for SQL Server Reporting Services 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...

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

Google Drive API v3 - OAuth2 using Service Account in PHP/JWThttps://www.joellipman.com/articles/google/google-drive-oauth-using-service-account-in-php.html

02 February 2019 doesn't need the client libraries, composer, vendor, etc. Why? This took me the best part of a month to get working. It is taken from Google's documentation as well as other forums and websites that try to explain it. Do not waste your time like I did...

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

ZohoBooks: Stripe Terminal Integrationhttps://www.joellipman.com/articles/crm/zoho/zohobooks-stripe-terminal-integration.html

16 March 2023 sends the amount to the reader for a payment atempt Date Modified: 2023-02-24 (Joel Lipman) - If custom field "Amount To Be Taken" is not greater than zero, then defaults to balance due of invoice. More Information: TEST PAYMENT SCENARIOS WITH PHYSICAL...

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

ZohoCRM & ZohoWriter: Generate Rich-Text / HTML Email Signatures in CRMhttps://www.joellipman.com/articles/crm/zoho/zohocrm-zohowriter-generate-rich-email-signatures-in-crm.html

05 December 2023 v_ImageURL = v_ImageURL.replaceAll("https://workdrive.zohopublic.eu/file/","",true); // // replaced with URL taken on inspect element v_ImageURL = "https://previewengine-accl.zohopublic.eu/image/WD/" + v_ImageURL; } } } return v_ImageURL; Function:...

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

Zoho Books / Inventory: Get Item Rate from a Price Book/Listhttps://www.joellipman.com/articles/crm/zoho/zoho-books-inventory-get-item-rate-from-a-price-book-list.html

23 May 2024 will work in May 2024 following the API domain change. The use-case is that the customer wants the item/product rate taken from the item record, if a pricebook is specified and the item exists within it, then it takes the rate from the pricelist. Note...

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

ZCRM Client Script: Correct Decimal Fields OnLoadhttps://www.joellipman.com/articles/crm/zoho/zcrm-client-script-correct-decimal-fields-onload.html

13 December 2023 */ // freezes the GUI? ZDK.UI.freeze(true); // attempt try { // taken from stackoverflow: https://stackoverflow.com/questions/17369098/simplest-way-of-getting-the-number-of-decimals-in-a-number-in-javascript var fn_CountDecimals = function(value) { if...

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

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

27 April 2010 without actually opening them by simply hovering over the icon in the taskbar. Click on one of them and you will be taken to that window, this also works with tabs in Internet Explorer which is very handy, but unfortunately it doesn’t work in Firefox or...

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

SSRS Hide results table if emptyhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-hide-results-table-if-empty.html

29 March 2011 I have a report which I've already completed and pretty chuffed with. It shows the details on a user-specified room taken from a room bookings system. Below the details, we've connected it to the assets database and want to list the equipment and...

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

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

19 September 2011 Situation We want some photos taken from another website of ours to display in our report. These are not stored locally on the Reporting Server because other services use these photos on our Intranet and we only want one location to upload the photos....

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

SSRS Retrieving Oracle Stored Procedure Success or ErrorLevelhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-retrieving-oracle-stored-procedure-success-or-errorlevel.html

04 November 2011 display a message saying "executed stored procedure", "please click on the link to continue" and then the user would be taken to a report which says either "Stored Procedure was successful" or "No sorry you're going to have to go back to the beginning...

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

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

20 August 2012 not include the mootools-more.js file: -- reminder: check for conflicts Additional Notes You have no idea how long it has taken me to get this code in working order and as easy as it may be to others, this has been quite a challenge. I have tried so...

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

Reorder Columns in a Tablehttps://www.joellipman.com/articles/database/reorder-columns-in-a-table.html

22 July 2013 a quick note to myself on how to reorder columns as I was having difficulty using a phpMyAdmin interface to do this. How? Taken from the best forum for programming Qs&As: http://stackoverflow.com/questions/4095481/easy-way-to-re-order-columns Method:...

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

DJI Phantom FC40 - Fun at the raceshttps://www.joellipman.com/articles/_other-misc/quadcopters/dji-phantom-fc40-fun-at-the-races.html

17 September 2014 moving forwards in an arc to go round corners. Then I learnt there were so many different angles and routes I could have taken (NTS: Take picture of whole track beforehand and plan a route). Strong Winds: Fighting the wind to keep up with the cars. Keep...

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

Convert XML UTF-16 to JSON UTF-8 with PHP cURLhttps://www.joellipman.com/articles/web-development/php/convert-xml-utf-16-to-json-utf-8-with-php-curl.html

28 March 2015 json php curl utf16_decode PHP Manual: curl-setopt Well this is my stop. It's being several hours that for others could have taken a several minutes if you knew where to look. My aim was to convert UTF-16 received XML to UTF-8 in order to convert XML to...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB

Migrating from Joomla 2.5.x to 3.4.xhttps://www.joellipman.com/articles/cms/joomla/migrating-from-joomla-2-5-x-to-3-4-x.html

12 September 2015 inherit privileges they shouldn't have. This script has been adapted to change the Admin ID to a number that hasn't been taken yet or to use the current one and is specified as a local variable. -- Specify v2.5.x admin ID and v3.4.x admin ID SET...

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

Zoho People: Reject an Application for Leave in Deluge based on Criteriahttps://www.joellipman.com/articles/crm/zoho/zoho-people-reject-an-application-for-leave-in-deluge.html

10 December 2020 "Approved", "Rejected". We're using the !="Cancelled" and probably !="Rejected" because we want pending ones to also be taken into account (first come first serve basis). Calculate the percentage of people already booked off: A very quick percentage...

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

ZohoCRM: Template: not being able to edit a text boxhttps://www.joellipman.com/articles/crm/zoho/zohocrm-template-not-being-able-to-edit-a-text-box.html

25 January 2022 article with not 100% certainty on what the cause/outcome would be for your case but worked for us. This documents the steps taken to edit/modify the header on a sales order inventory template. Why? A client raised an issue that they had previously...

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