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 here to the name of your report ORDER BY e.TimeStart DESC Deploy the report to the SSRS Run the report from MS Internet Explorer Check results using Microsoft SQL Server Management Studio (SSMS) My test results showed that in fact my time was closer to...

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

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

08 March 2012 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 to "Local Path" (for me this said the name of the local folder that I specified just before)

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

Inline Labels in Form Fields using Javascripthttps://www.joellipman.com/articles/web-development/js/inline-labels-in-form-fields-using-javascript.html

21 August 2012 "Name:". Why? I've noticed a lot of solutions now use JQuery or Mootools but most of these will not work in Internet Explorer 7 which is unfortunately still in use. I needed a back-to-basics solution and this is the one I have used since my fad of...

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

Sync Outlook 2007 Shared Calendar with SharePoint 2007https://www.joellipman.com/articles/microsoft/sharepoint/sync-outlook-2007-shared-calendar-with-sharepoint-2007.html

09 November 2012 team's annual leave). full access to a SharePoint 2007 site (team portal). Steps: Open your Outlook 2007 Using MS Internet Explorer (demo below is version 8), bring up your SharePoint Calendar Click on Actions Select Connect to Outlook Allow the website...

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

Background Gradient Disappears on Long Pageshttps://www.joellipman.com/articles/web-development/css/background-disappears-on-long-pages.html

20 November 2012 border-radius: 0 0 5px 5px; Example Additional The above issue happened when using Google Chrome v23 or MS Internet Explorer v8 (so Webkit and MSIE appear to be affected). If your website consists of small pages then ignore this issue as it's unlikely...

• Type: Article
• Author: Joel Lipman
• Category: Cascading Stylesheets
• Language: *

Three boxes, two roll over, one falls outhttps://www.joellipman.com/articles/web-development/css/three-boxes-two-roll-over-one-falls-out.html

21 January 2013 boxes made of div layers. When viewed normally on a 15" Laptop, all was good using Chrome and tolerable using MS Internet Explorer. If we maximized the Google Chrome browser, the row would split and there would be 2 boxes on the top row and the third...

• Type: Article
• Author: Joel Lipman
• Category: Cascading Stylesheets
• Language: *

Administrator Program Shortcut without Prompthttps://www.joellipman.com/articles/microsoft/windows-os/administrator-program-shortcut-without-prompt.html

25 February 2013 to elevate without prompting Further Notes Location of Windows 7 Taskbar shortcuts (Pinned): %APPDATA%\Microsoft\Internet Explorer\Quick Launch\User Pinned\TaskBar. You can determine what %APPDATA% is by opening a command prompt and typing: echo...

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

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

22 July 2013 viewing a table structure... Though maybe this is derived from a template and depending on if you are using MS Internet Explorer... Can't get it working? I use whatever is most useful and Google's Chrome is the fastest browser I have. Here are some ways...

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

Batch Process to rename multiple files using Windows DOShttps://www.joellipman.com/articles/automation/ms-dos/batch-process-to-rename-multiple-files-using-windows-dos.html

09 August 2014 create a batch file b) use it to rename the files c) delete the batch file. Open a command prompt: Method #1 Open windows explorer to the folder you want to apply this to Hold down the shift key and right-click on the folder Select "open command window...

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

Joes Revolver Map (JRM) Downloadshttps://www.joellipman.com/component/content/article/joes-revolver-map-jrm-downloads.html?catid=92

07 September 2015 Jan 2013 1.3- Upgraded to work with Joomla 2.5.x - Date Uploaded: Thu, 27th Dec 2012 1.2- Checked compatibility: Internet Explorer v6+, Mozilla Firefox v3.5+, Google Chrome v5+ - Added alignment parameter ("float") relative to its container. - Added div...

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

AutoHotkey: Get Media Information and Displayhttps://www.joellipman.com/articles/automation/autohotkey/autohotkey-get-media-information-and-display.html

07 August 2020 What? This is a copied article just to store a permanent reference for if I ever need to build an app similar to the file explorer in the Microsoft Windows OS. Why? I had an app for use in MS Windows 7 to display the properties of sound files though...

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

Zoho Creator / eBay: Get all Active Productshttps://www.joellipman.com/articles/crm/zoho/zoho-creator-ebay-get-all-active-products.html

13 October 2021 listings / active products Date Created: 2021-10-13 (Joellipman.com - Joel Lipman) - Initial release More Info: - API Explorer Test Tool: https://developer.ebay.com/DevZone/build-test/test-tool/default.aspx?index=0&env=production&api=trading -...

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

Zoho Creator: eBay: Get Item Transactionhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-ebay-get-item-transaction.html

22 January 2022 a line item transaction per item ID Date Created: 2022-01-22 (Joellipman - Joel Lipman) - Initial release More Info: - API Explorer Test Tool: https://developer.ebay.com/DevZone/build-test/test-tool/default.aspx?index=0&env=production&api=trading -...

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

ZohoDeluge: Get All eBay Orders Given a From and Till Datehttps://www.joellipman.com/articles/crm/zoho/zohodeluge-get-all-ebay-orders-given-a-from-and-till-date.html

28 February 2023 a from and till date Date Created: 2023-02-28 (Joel Lipman) - Initial release Date Modified: ???? - ??? More Info: - API Explorer Test Tool: https://developer.ebay.com/DevZone/build-test/test-tool/default.aspx?index=0&env=production&api=trading -...

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

ZohoCRM: Get All eBay Active Listingshttps://www.joellipman.com/articles/crm/zoho/zohocrm-get-all-ebay-active-listings.html

01 March 2023 all active listings Date Created: 2023-03-01 (Joel Lipman) - Initial release Date Modified: ???? - ??? More Info: - API Explorer Test Tool: https://developer.ebay.com/DevZone/build-test/test-tool/default.aspx?index=0&env=production&api=trading -...

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

Zoho Deluge: Get All Orders from eBayhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-get-all-orders-from-ebay.html

29 March 2023 errors and query order line item IDs (ErrCode: 21917182) - Modified to check that there are some orders. More Info: - API Explorer Test Tool: https://developer.ebay.com/DevZone/build-test/test-tool/default.aspx?index=0&env=production&api=trading -...

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

ZohoCRM Webhook: Create ZohoInventory Records from an eBay orderhttps://www.joellipman.com/articles/crm/zoho/zohocrm-webhook-create-zohoinventory-records-from-an-ebay-order.html

27 April 2023 item: now ticks purchase information and track inventory. - Issue on create that shipment is not created. More Info: - API Explorer Test Tool: https://developer.ebay.com/DevZone/build-test/test-tool/default.aspx?index=0&env=production&api=trading -...

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

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

Increase Recent Documents Number in Windows XPhttps://www.joellipman.com/articles/microsoft/windows-os/increase-recent-documents-number.html

28 July 2011 just for me: Start > Run > Regedit > OK Browse to HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Policies\Explorer Create New DWORD Value Name it "MaxRecentDocs" Double-click on the new DWORD Set value data to "19" ( equals 25 ) Leave Base...

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

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

03 January 2013 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 was missing in this case.

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