SSRS Templates in BIDS 2008https://www.joellipman.com/articles/microsoft/ssrs/ssrs-templates-in-bids-2008.html

01 April 2011 Open a Windows Explorer and make a duplicate of the report that you want to use as a template. Rename the copy (suffix with template?) Remove objects unique to the report and leave elements for all reports. File > Save selected item as... For SSRS...

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

Code Troubleshooting Checklisthttps://www.joellipman.com/articles/web-development/code-troubleshooting-checklist.html

03 June 2011 diagnosable parts? Checked appropriate services are running? Questions for the customer Can you access the service? Can you open other similar files in the same environment? Is a colleague experiencing the same issue? Can you access the service using a...

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

Mouseover Links in AutoHotkeyhttps://www.joellipman.com/articles/automation/autohotkey/mouseover-links-in-autohotkey.html

08 July 2011 ; CREATE GUI Gui, Color, FFFFFF Gui, +OwnDialogs +SysMenu +Caption +0x800000 Gui, Add, Text, gOpenDocumentation, Open the documentation Gui, Show, w600 h700, %ThisProgramName% WinSet, AlwaysOnTop, On, %ThisProgramName% OnMessage(0x200, "WM_MOUSEMOVE")...

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

UNC Paths in Sharepoint 2007 linkshttps://www.joellipman.com/articles/microsoft/sharepoint/unc-paths-in-sharepoint-2007-links.html

08 November 2012 suggested I setup WebDAV to do this, I thought I'd write this article to warn others that that's unnecessary and can simply open another can of worms (security-wise). There may be situations when this is better but I'm just trying to add a link to our...

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

List last modified files using FTP Command-linehttps://www.joellipman.com/articles/web-development/ftp/list-last-modified-files-using-ftp-command-line.html

20 November 2012 and uploaded to a site, how do I do it using just Microsoft Windows? How? I don't have a clue. Here's what I've got so far: Open a command-prompt (Start > Run > Type COMMAND > OK) Type ftp my_ftp_host (where "my_ftp_host" is the hostname or IP of the...

• Type: Article
• Author: Joel Lipman
• Category: File Transfer Protocol
• Language: *

Deserialization and cannot checkout files in TFShttps://www.joellipman.com/articles/microsoft/tfs/deserialization-and-cannot-checkout-files-in-tfs.html

03 January 2013 is one of those obvious ones for those that know how but for those who can't remember, then it can take a while. How? Open the solution file Select any file in the Solution Explorer Go to File » Source Control » Go Online The "Go Online" is the option I...

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

SSRS Border Problemhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-border-problem.html

20 January 2014 on the first cell (top-left), hold down the shift key and click on the last cell (bottom-right). This selects all cells. Now open the "Properties" pane, find the "BorderStyle" and type the word "None" next to it (as its value). Press the "Enter" key if...

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

SSRS No Delay for First Report of the Dayhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-no-delay-for-first-report-of-the-day.html

11 April 2014 reports on that server. Apply to each server that requires it. Let your report server administrators do this: On the server, open the XML file: C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting...

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

Excel: Extract hyperlink from linkhttps://www.joellipman.com/articles/microsoft/excel/excel-extract-hyperlink-from-link.html

06 November 2014 article on if you want to extract the link from some text you have copied off the web and into an MS Excel document. How? Open up a new workbook. Get into VBA (Press Alt+F11) Insert a new module (Insert > Module) Copy and Paste the Excel user defined...

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

Joes Transmission Detector (JTD) Downloadshttps://www.joellipman.com/component/content/article/joes-transmission-detector-jtd-downloads.html?catid=92

07 September 2015 VersionPlatform ChangeLogOptions1.0- Read data packets without causing network traffic - Display program used to open port - Disallow program minimize - Background made transparent - Added received/sent data graph progress bars - Listview rolls...

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

Display a thumbnail of a Google Drive videohttps://www.joellipman.com/articles/google/display-a-thumbnail-of-a-google-drive-video.html

13 November 2018 and select "Get Shareable Link". If link sharing is already on, it will display a link such as: https://drive.google.com/open?id=, where is the file ID. If not the "Share with Others" dialog will popup and the file ID will be in the link:...

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

Joomla: Remove IDs from URLs for out-of-the-box SEFhttps://www.joellipman.com/articles/cms/joomla/joomla-remove-ids-from-urls.html

14 March 2020 do this without any coding... Pre-amble To allow the Joomla CMS to manage your SEFs you need to setup your htaccess file: Open the root of your Joomla website in your file manager (you can FTP or use web-based clients) Find the file htaccess.txt and...

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

Zoho Deluge: Generate and Send a CSV via Emailhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-generate-and-send-a-csv-via-email.html

16 June 2021 just noting that I'm enclosing each value with double-quotes because the values might have commas and someone may want to open this in Google Sheets or Microsoft Excel: // // init l_NewCSVrows = List(); v_ThisEventTime = zoho.currenttime; // // loop...

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