Returning Oracle Stored Procedure Resultset in SSRShttps://www.joellipman.com/articles/microsoft/ssrs/returning-oracle-stored-procedure-resultset-in-ssrs.html

19 January 2012 Add a data source to your SSRS report Add an SSRS input parameter Add a dataset Query type: Stored Procedure Refresh fields button Parameter name (oracle input sp variable) and Parameter value (ssrs input parameter) Fields (field name=ssrs reference,...

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

MessageBox or AlertDialog in Android Javahttps://www.joellipman.com/articles/google/androidos/messagebox-or-alertdialog-in-android-java.html

20 October 2014 new AlertDialog.Builder(this) .setTitle("Some Title") .setMessage("some message") .setPositiveButton("OK", new DialogInterface.OnClickListener() { public void onClick(DialogInterface arg0, int arg1) { // Some stuff to do when ok got clicked } })...

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

AutoHotkey: App GUI Listview to Rename Fileshttps://www.joellipman.com/articles/automation/autohotkey/autohotkey-app-gui-listview-to-rename-files.html

08 July 2020 File 3 (3).wav How? So if you copy the following code into an AutoHotkey file and execute it, it will popup an app with 3 buttons: 1st to generate or populate a list of the files in the script directory, the 2nd to do the actual renaming. A text field...

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

Zoho Creator: info/alert/modal/popup notification for any userhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-info-alert-modal-popup-notification-for-any-user.html

06 November 2020 me and to develop a simple notification system that will popup for any user on the submit of a form, or on the click of a button or on the click of a link on a page. Why? Because alert (alert task) can only be used on a load of a form, on a change of a...

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

Windows 7: System Clock is constantly going out of synchttps://www.joellipman.com/articles/microsoft/windows-os/windows-7-system-clock-is-constantly-going-out-of-sync.html

28 January 2010 on your taskbar Click on Change date and time settings link Click on the tab Internet Time Click on the Change Settings button Check the box next to Synchronize with an Internet time server is ticked Select an option from the dropdown menu starting with...

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

Windows Live Messenger: Error 80048820https://www.joellipman.com/articles/microsoft/windows-os/windows-live-messenger-error-80048820.html

08 March 2010 on your taskbar Click on Change date and time settings link Click on the tab Internet Time Click on the Change Settings button Check the box next to Synchronize with an Internet time server is ticked Select an option from the dropdown menu starting with...

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

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

18 May 2010 space and real disks) It should go about creating a usable virtual hard disk. When it's done click on the small "Start" button below the "Remove" button (not your main Start menu button) As soon as it loads, press DEL to enter the BIOS setup. Navigate...

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

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

05 January 2011 in the Solution Explorer > select "Add New Data Source" Give the DataSource1 a more memorable name Click on the "Edit..." button Click on the "Change..." button Select "ODBC" and click on "OK" Select the system data source name Enter the login...

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• 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 > From Microsoft Query > select Data Source Specify SQL Query: > Add Tables (not really just "close" this) > click on SQL button > Type/Paste your SQL Query > OK > Click on "Return Data" button Report Type: Select PivotTable Report > OK Design Table:...

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

Excel PivotTable Filter List Orderinghttps://www.joellipman.com/articles/microsoft/excel/excel-pivottable-filter-list-ordering.html

05 September 2011 list of the report (so you see the fields panel) Untick the filter that is not in alphabetical order Click on the Refresh button Re-Tick the filter to add it back to the report Move this added field to the Report Filter section (click on it and select...

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

Quadcopter App with Flight Restrictions (JQA)https://www.joellipman.com/component/content/article/quadcopter-app.html?catid=40

24 October 2014 to keep up-to-date with new legislation and developments on "drones". Tap once to see a brief description, click on the button to view the full article in your browser. Hangar New to the app I thought it would be really cool if I could change the...

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

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

25 July 2024 > Click on "Create" > Then select "Dashboard": Then in the top right of the dashboard, I'm going to click on the "Widget" button: On the data column, I'll select any query and any field. It doesn't matter which one here, as long as I can get to the 3rd...

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

Stop Excel Row Height Self-Adjust on Refreshhttps://www.joellipman.com/articles/microsoft/excel/stop-excel-row-height-self-adjust-on-refresh.html

30 September 2011 the customer having to format the report after they've already gone through the hassle of clicking on the big fat refresh button... Keeping It Simple Silly. So the suggestion of selecting all cells and then right-clicking and selecting "row height" is...

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

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

27 November 2012 drained, wasn't lasting the day on 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...

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

Zoho Creator: Set Up Custom Domain for Customer Portalhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-set-up-custom-domain-for-customer-portal.html

17 November 2020 Domain So go into your Zoho Creator app and go to the "Settings" tab, then on "Customer Portal" then on the "Settings" button in the top right: Under Portal URL, select "Custom Domain" and in the field below, enter the full domain (incl. subdomain) you...

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

Zoho Creator: Shopify API Integration Oauth 2.0 - Update 2022 (Search by SKU GraphQL)https://www.joellipman.com/articles/crm/zoho/zoho-creator-shopify-api-integration-oauth-2-0-update-2022.html

14 February 2022 Click on "Save" Click on "Install App" button in the top right Confirm by clicking on "Install" button in the popup You will be shown your Admin API access token > Store this in the Access Token field of your Creator form. If your app needs the...

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

Zoho Inventory & eBay Picture Services: UploadSiteHostedPictureshttps://www.joellipman.com/articles/crm/zoho/zoho-inventory-ebay-picture-services-uploadsitehostedpictures.html

31 March 2022 One Login to Zoho One Go to Settings (cog in top right) Click on Applications i the sidebar Click on the Add Application button Select Creator by clicking the Add button below it Link it if applicable to your super admin account Create an app, a form...

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

ZohoCRM: Integrate ChatGPT to ZohoZIAhttps://www.joellipman.com/articles/crm/zoho/zohocrm-integrate-chatgpt-to-zohozia.html

06 March 2023 "Answer a Question" It should be answered by "Construct Answer by Fetching Data" The question can be asked by clicking the button "Ask ChatGPT" Add the parameter: I'm calling it "banter" of type "String" with a prompt message of "What is your question?"...

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

Zoho Books: Generate Bank Text File for Downloadhttps://www.joellipman.com/articles/crm/zoho/zoho-books-generate-bank-text-file-for-download.html

02 October 2023 This is an article to document how we created a button off a Bill record in ZohoBooks which generates a text file to be sent to a bank and downloads it to the staff member's workstation. Why? Why is this a challenge? The file contains bank details and...

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

Zoho CRM: ZDK Client Script: Auto-Select Pipeline based on User Departmenthttps://www.joellipman.com/articles/crm/zoho/zoho-crm-zdk-client-script-auto-select-pipeline-based-on-user-department.html

16 October 2023 administrator > Go to Setup > Pipelines Using the "Standard" layout, let's simply create a new pipeline by clicking the button in the top right. For this demo, we ensure there are at least 2 pipelines: "Hire Pipeline", and "Sales Pipeline". Setup: the...

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