SSRS Redirect after a report is runhttp://mail.joellipman.com/articles/microsoft/ssrs/ssrs-redirect-after-a-report-is-run.html

12 August 2011 advised that if we had time in the future we could expand on this further. Google Searches that got me nowhere: ssrs process parameter after report execution auto-redirect after are a report is run ssrs vbscript post report processing ssrs auto redirect...

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

SSRS Parameters in Oracle Stored Procedurehttp://mail.joellipman.com/articles/microsoft/ssrs/ssrs-parameters-in-oracle-stored-procedure.html

02 September 2011 page just checks with the end-user that this is what they really want to do as we don't really have an immediate undo process. The form page carries the cancel button (textbox which actions to the previous report with same parameters) and another link...

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

Fun with DllCall in AutoHotkeyhttp://mail.joellipman.com/articles/automation/autohotkey/fun-with-dllcall-in-autohotkey.html

27 September 2011 number of network card interfaces DllCall("iphlpapi\GetNumberOfInterfaces", "UintP", nIf) MsgBox % nIf... // get current process ID ProcessID := DllCall("GetCurrentProcessId")

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

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 ) ) )) & " second(s)" // yields // Time Taken: 2.15443570 second(s) // I don't have a report that takes over an hour to process but in theory this should accommodate it. Problem #1 If zero rows are returned from the search, then there is no...

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

Joes DNS Correction (JDC)http://mail.joellipman.com/component/content/article/joes-dns-correction2.html?catid=40

25 November 2011 /flushdns" then "ipconfig /registerdns" and the connections would have been restored. As I love automation and reducing processes to single-click fixes, I made this teeny tiny program to run the above commands and check the error levels. Installation:...

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

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

19 January 2012 Add a dataset: returned "Fields" These is where you "map" the variables to the oracle returned variables. Debug Testing "Process of elimination" is possibly my favorite and most reliable way of figuring out what's wrong. Here are some suggestions: Check...

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

Search a database with SOUNDEXhttp://mail.joellipman.com/articles/database/search-a-database-with-soundex.html

11 October 2012 and in this example, find typos as well, eg. "Daat ont Ety Aviable". How? Mine's a bit of a copout as it is a two-step process. I wanted a query that searched every column containing strings in the database and we are somewhat limited in Sql Server 2008...

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

DataTumble - Randomize Data Rowshttp://mail.joellipman.com/articles/database/t-sql/datatumble-randomize-data-rows.html

07 December 2012 August 2009 ** ** Revision: V 0.01 ** ** Description: Stored Procedure to scramble Data in a column of a table. ** ** The process will mix the Data using a random function. ** ** Once the Data has been scrambled it won't be possible to get the original...

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

Access MySQL databases using Oracle SQL Developerhttp://mail.joellipman.com/articles/database/mysql/access-mysql-databases-using-oracle-sql-developer.html

01 February 2013 our SQL Server instances but it wasn't practical to link this to mySQL databases. How? So this is how I did it, I found the process rather straightforward anyway so let's begin: Download the JDBC Driver for MySQL (Connector/J) connector from...

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

Export/Import Database using MySQL Workbenchhttp://mail.joellipman.com/articles/database/mysql/export-import-database-using-mysql-workbench.html

05 February 2013 This article isn't unique as there are other tutorials out there. This is meant to detail a process to export a database using MySQL Workbench and then to import it into another database. Why? If you're confined to use this product then this is how to...

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

Restore MSSQL Error: Database is in usehttp://mail.joellipman.com/articles/database/restore-mssql-error-database-is-in-use.html

08 March 2013 who is logged in GO -- SQL Server 2008 EXEC SP_WHO2 // even more details GO -- Run as database owner to see ALL connected processes as well. Why? For every DBA this is a doddle and doesn't warrant its own article but for those of us who merely use SQL...

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

Transferring Apps (purchases) from iPhone 4s to 5s on a Windows PChttp://mail.joellipman.com/articles/apple/ios/transferring-apps-purchases-from-iphone-4s-to-5s-on-a-windows-pc.html

03 November 2013 it up but you could do the below again at anytime (as I discovered). The steps below apply after having gone through the process of setting up the phone and finishing on the "Get Started" (including Touch ID). Ensure your old phone's iOS is fully...

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

Accessing Apimo WebService APIhttp://mail.joellipman.com/articles/automation/api-misc/accessing-apimo-webservice-api.html

29 March 2016 = substr($output, stripos($output, '?>') + 2 ); // remove leading spaces, carriage returns $output = trim($output); // process if type specified was xml if($apimo_type=='xml'){ // send header header("Content-Type:text/xml"); // print result to page echo...

• Type: Article
• Author: Joel Lipman
• Category: API Miscellaneous
• Language: *

PHP Issue: simplexml_load_string parser error : Input is not proper UTF-8, indicate encoding !http://mail.joellipman.com/articles/web-development/php/php-issue-simplexml-load-string-parser-error-input-is-not-proper-utf-8-indicate-encoding.html

02 August 2016 error : Input is not proper UTF-8, indicate encoding ! Bytes: 0xA0 0x3C 0x2F 0x73 in /home/public_html/my_folder/my_xml_processing_script.php on line 160 Why? I'm downloading an XML feed to our servers, and then loading the downloaded file into memory...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: *

Pure JS - Display Time Elapsed & Remaininghttp://mail.joellipman.com/articles/web-development/js/pure-js-display-time-elapsed-remaining.html

30 October 2018 elsewhere... This example specifically displays the time remaining on an access_token which is generated from an OAuth 2.0 process. I want to display to the user how much time is left before another access token will be generated and how long ago was...

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

MS Excel - Split Workbook into separate files per sheethttp://mail.joellipman.com/articles/microsoft/excel/ms-excel-split-workbook-into-separate-files-per-sheet.html

11 February 2019 per sheet. Why? The Excel file in question was about 36000 rows and had a file size of about 11Mb. In order for an import process to work, the import would only accept XLS files no greater than 1Mb. So our script has to split a single spreadsheet into...

• Type: Article
• Author: Joel Lipman
• Category: Excel
• 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 options to grant and would have to grant them via a terminal/command line to MySQL. GRANT SELECT, LOCK TABLES, RELOAD, PROCESS, TRIGGER, SUPER, REPLICATION CLIENT, SHOW VIEW ON *.* TO 'mybackupuser'@'localhost' IDENTIFIED BY 'mybackupuser'; Suggestions?...

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

Zoho Deluge - Counting in a Map dataTypehttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-counting-in-a-map.html

02 September 2019 it to see if I can refine the code or find a some short codes that will do the same. Why? I'm aiming to automate a process which counts the number of products allocated to an account or in total for a purchase order. Let us assume we have the following...

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

Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Bookshttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-download-uploaded-file-and-attach-to-sales-order-in-zoho-books.html

15 May 2020 task in Creator Schedules > New Workflow Choose a Date Field Start Date: select form and choose Modified_Time Run this process on condition "Attached Files in CRM equals false" Execute Workflow "After 2 Minutes" Repeat Interval = Once Name the workflow...

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

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

06 November 2020 on a page. Why? Because alert (alert task) can only be used on a load of a form, on a change of a field or on the validate process. And because info can only be displayed to an admin and even in some cases only as an additional link in the form. The...

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