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

19 September 2011 we are still considering it; so this article is more about just getting external images to 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...

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

Joes Network Transmission Detector (JTD)http://mail.joellipman.com/component/content/article/joes-network-transmission-detector-jtd.html?catid=40

29 September 2011 it does what I want and looks like I want it to look, was to make my own. What does it do? Amazing. It detects transmissions over a network. Basically on a computer that isn't on a network (ie. not connected to the internet), this program is extremely...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• 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 ).ToString ) ) )) & " 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

How to change local folder for TFShttp://mail.joellipman.com/articles/microsoft/tfs/how-to-change-local-folder-for-tfs.html

08 March 2012 > Workspaces Edit... the workspace which is causing the problem Change the local folder All the files on TFS should copy over to your local folder; once done close the dialogs click on the TFS icon in Source Control Explorer and check what it says next...

• Type: Article
• Author: Joel Lipman
• Category: Team Foundation Server
• Language: *

Copy a table with structure and data into a temporary tablehttp://mail.joellipman.com/articles/database/t-sql/copy-a-table-with-structure-and-data-into-a-temporary-table.html

03 August 2012 Generate Select Query to extract data from given table and populate temporary table SET @SqlToExecute='SELECT ROW_NUMBER() OVER(ORDER BY ' + @ColName + ') AS dummyIndex, ' + STUFF( ( -- Code to concatenate column names and data types into one string...

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

Slideshow div layer through a windowhttp://mail.joellipman.com/articles/web-development/mootools/slideshow-div-layer-through-a-window.html

11 September 2012 send each new info to the next slide and use only two slides in total (that's the aim at least). Other objects (mostly text over image) will need to be free flowing and slide in emulating a dynamic showcase slideshow. Using MooTools it's also proven to...

• Type: Article
• Author: Joel Lipman
• Category: MooTools Framework
• Language: *

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

11 October 2012 a database of circa 30'000 students and their details (incl. courses ~ 700'000 records) took just under 2 minutes (found over 7 million occurrences similar to "DNYA").

• 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 this is a function which simply finds random characters and inserts these. I would recommend using the DataTumble script over this one as this leaves data very difficult to work with: Before: StudentID StudentName DateOfBirth -----------...

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

Error 1065: Query was Emptyhttp://mail.joellipman.com/articles/database/mysql/error-1065-query-was-empty.html

13 December 2012 In view of the fact that this error pops up in so many systems I take over, I have often gone down the wrong path following the red herring as it were when in fact the answer to this is very common. Why? Bespoke systems are the usual suspects....

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

Setup a copy of your Joomla websitehttp://mail.joellipman.com/articles/cms/joomla/setup-a-copy-of-your-joomla-website.html

19 December 2012 > Options) Don'ts: — Do NOT create TEST as a subfolder of LIVE (this will complicate backups to no end). — Do NOT overwrite/remove the TEST configuration.php file. — Do NOT enable users access till the last step. My Standard Setup LIVE -...

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

Cheat Sheet for mySQL vs t-SQLhttp://mail.joellipman.com/articles/database/cheat-sheet-for-mysql-vs-t-sql.html

31 January 2013 ISNULL(column_name,value_if_null) Rank/Rownum (@rownum:=@rownum+1) AS Rownum LIMIT from_index, number_of_rows ROW_NUMBER() OVER(ORDER BY column_name ASC) AS Rownum Source(s): MSDN Microsoft Library (DATEPART (Transact-SQL)) MSDN Microsoft Library...

• Type: Article
• Author: Joel Lipman
• Category: Databases
• 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 mySQL add-on for Oracle SQL Developer v3.0.04. Why? I've used various mySQL administration tools to manage mySQL databases over the years, all freeware until someone expresses an interest in using it and then the supplier will implement restrictions and...

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

T-SQL Conversion failed when converting the varchar to data type inthttp://mail.joellipman.com/articles/database/t-sql/t-sql-conversion-failed-when-converting-the-varchar-to-data-type-int.html

14 May 2013 simply change the "=" to a "LIKE". Scenario #2 So when the above has been addressed or we've tried casting as varchars all over the place, check the value that gets outputted is also a literal string. So here's some ok code but it will fail if my...

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

Autohotkey Count Number of Files/Folders in a Directoryhttp://mail.joellipman.com/articles/automation/autohotkey/autohotkey-count-number-of-files-folders-in-a-directory.html

04 June 2013 ; if A_LoopFileAttrib contains H,R,S ; continue This works fine at home on your local host on a local drive. Try using this over a networked drive and more time will be spent counting the files then the actual processing (or whatever your script is...

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

SSRS Stop Scrolling Behindhttp://mail.joellipman.com/articles/microsoft/ssrs/ssrs-stop-scrolling-behind.html

08 April 2014 black background). And here's the rendered/published view on the Reporting Server: Conclusion The whole report was appearing over any scrolled content as if it were a header that had been told to keep visible while scrolling. The fix in a nutshell is...

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

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

24 October 2014 the flight restrictions of the area and any other hazards I might need to take into account. Other apps I found only covered the USA, this one I wrote covers the world and can be added to really easily. It works by reading the weather data from...

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

Android OS: Add GoogleMap as fragmenthttp://mail.joellipman.com/articles/google/androidos/android-os-add-googlemap-as-fragment.html

25 November 2014 article is based on a new blank project which does not include code from the previous example but you can still build this over the previous example (as I did). Why? The previous article meant that the Google map was your main activity and any other...

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

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

28 March 2015 it to an array // $array = json_decode($json_result,TRUE); // yields......... Without cURL You'll have seen this all over the Internet as the accepted solution... Doesn't work for me because I'm using cURL but it's a first point of reference. This...

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

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

29 March 2016 how I connected to the Apimo WebService. The Apimo Webservice is an API provided by apimo.com and requires a server request over HTTPS using the GET method. Why? This was quite difficult to connect to and to determine what was wrong with each step of...

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

Display Feeds to major Social Networkshttp://mail.joellipman.com/articles/web-development/display-feeds-to-major-social-networks.html

16 May 2016 box that appears, Copy & Paste the code into your blog or website HTML. YouTube Go to YouTube and browse to your channel Hover the mouse over Uploads and click on the Play All button Click Share Click Embed From the box that appears, Copy & Paste the...

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