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 this is not the solution to our problem. This is the solution that I initially used but my end-users were asking why is it always 0 seconds. This was because we were using the following MDX statement which had seconds as its smallest denominator:...

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

MySQL Data Type Reference Tablehttp://mail.joellipman.com/articles/database/mysql/mysql-data-type-reference-table.html

15 February 2010 reference table. If you're designing a database then you don't need me to tell you what this is. My personal opinion is to always try to use the minimal type and length of the value required. For example, a comment of 500 words should only be TEXT...

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

Is it a scam? Gumtree.com's warning signshttp://mail.joellipman.com/hardware/is-it-a-scam-gumtreecoms-warning-signs.html

12 October 2010 you have received may not be genuine. If you receive an email alleging to be from a company offering a service, always go directly to the company’s official website and look for details of the service. Cheque overpayment. A buyer, prospective tenant or...

• Type: Article
• Author: Joel Lipman
• Category: IT Support
• Language: *

Basic Webpage Controls with JavaScript / COMhttp://mail.joellipman.com/articles/automation/autohotkey/basic-webpage-controls-with-javascript-com.html

05 July 2011 visible COM_Invoke( pwb, "Navigate", "www.AutoHotkey.com" ) ; Navigate to a webpage ; when finished COM_Release( pwb ) ; Always release COM objects COM_Term() ; Always Uninitialize COM How to access an existing IE object? - Sean's GetWebBrowser()...

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

SSRS Dropdown parameter cannot be blank!http://mail.joellipman.com/articles/microsoft/ssrs/ssrs-dropdown-to-allow-blank-values.html

14 December 2011 dummy reports it couldn't find. It doesn't even mention them anywhere in the resulting report. One Issue The report will always load when opened defaulting to having all parameters set to the dummy value. For me it just opens an empty report with the...

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

CSS Center an iFrame Horizontally and Verticallyhttp://mail.joellipman.com/articles/web-development/css/css-center-an-iframe-horizontally-and-vertically.html

23 September 2019 iframe. When the app within the iframe has an alert message, it popups a div at the centre of its app. The alert message is always at the center of the iframe but if the iframe has a height of 2000 pixels, the iframe gets aligned to the top of the...

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

ZohoBooks: Broken UK Banking Feedhttp://mail.joellipman.com/articles/crm/zoho/zohobooks-broken-uk-banking-feed.html

16 October 2025 Notes and findings: Integration locks: The “Accounts associated with Integration cannot be marked Inactive” message almost always refers to a stuck bank feed token, not a third-party app. This can only be cleared by Zoho’s backend support. Yodlee vs...

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

Mediawiki Extension for Camtasia Studio SWF videoshttp://mail.joellipman.com/articles/cms/mediawiki/mediawiki-extension-for-camtasia-studio-swf-videos.html

08 October 2009 "best" ); so.addParam( "allowFullScreen", "true" ); so.addParam( "scale", "showall" ); so.addParam( "allowScriptAccess", "always" ); so.addVariable( "autostart", "false" ); so.write("media"); // ]]> '; return $this->code; } function getViewPath($file) {...

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

Change default order of weblinkshttp://mail.joellipman.com/articles/cms/joomla/change-default-order-of-weblinks.html

15 November 2009 and you are going to edit the _buildQuery() function, search the file for the following comment and text. As always, I would recommend you make a copy of the file before making the change just in case you need to revert the change: // We need to get a...

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

Room with a view E.M. Forsterhttp://mail.joellipman.com/articles/_other-misc/room-with-a-view-em-forster.html

04 February 2011 a shadow on something wherever we stand, and it is no good moving from place to place to save things; because the shadow always follows. Choose a place where you won't do harm--yes, choose a place where you won't do very much harm, and stand in it for...

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

Room Availability Calendar in Business Intelligence Development Studiohttp://mail.joellipman.com/articles/microsoft/ssrs/room-availability-calendar-in-business-intelligence-development-studio.html

23 March 2011 if you have 30 minute slots). Set the columns to stay at the top of the screen (scrolls with you) and left-most column to always be visible. Set StartTime to the minimum possible time on that day. Do the same for EndTime but set it to the maximum time...

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

Developer's Checklist: Taking over a projecthttp://mail.joellipman.com/articles/web-development/developers-checklist-taking-over-a-project.html

01 March 2011 to the above. Just add a comment to this page. Also if you want to share your nightmare project takeovers, they're always fun to hear about.

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

Checklist for the local computer repairshttp://mail.joellipman.com/hardware/checklist-for-the-local-computer-repairs.html

28 April 2011 charge for) Service: Software installs at flat price Website development per hourly rate Computer repair per hourly rate "I always had work order forms in duplicate. Right above the signature line was a BIG BOLD WARNING ABOUT LOSS OF DATA and “Check...

• Type: Article
• Author: Joel Lipman
• Category: IT Support
• Language: *

Newbies guide to be the local computer guyhttp://mail.joellipman.com/hardware/newbies-guide-to-be-the-local-computer-guy.html

28 April 2011 I love the last point. Down talk as opposed to hype and then produce. Even with most services this nearly always guarantees a happy customer. "So this is all I could fix in the time I have, all your issues have been dealt with and I also did this..."...

• Type: Article
• Author: Joel Lipman
• Category: IT Support
• Language: *

SSRS Querying on either of 2 Parametershttp://mail.joellipman.com/articles/microsoft/ssrs/ssrs-querying-on-either-of-2-parameters.html

19 July 2011 respectively). Most of the remaining datasets use the resulting @StudentReference number in their "where" clause. A student always has a "Student Reference" but not necessarily a student AD account (enquired/applied only). So following the above, I end...

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

Before and After, Highs and Lowshttp://mail.joellipman.com/articles/microsoft/ssrs/before-and-after-highs-and-lows.html

03 August 2011 002 11 47 Report 003 7 61 Multiple Datasets? Again NO that's what I have at the moment. There must be a way. Or is time always on that dimension? HAVING is pointless, WITH ROLLUP is interesting, think I'm looking in the wrong place. Using Aggregate...

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

T-SQL Record Separatorhttp://mail.joellipman.com/articles/database/t-sql/t-sql-record-separator.html

11 October 2011 actually blank and didn't have any of the data we want in the end? The aim here then is to get the inserted blank row to always be the last one on the day and then subsequently marked with the separator marker of Stage #1 (note that here separator...

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

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

21 January 2013 that was ok when maximized. How? You could do loads of code hacks which is what I tested but all for nothing because you always end up needing to specify a third of the width. Our template was 900 pixels in width. I tracked down some code that was...

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

Proposed Budget i3 PC under £200http://mail.joellipman.com/hardware/proposed-budget-i3-pc-under-200.html

26 January 2013 of Windows 8 has led to a review of our developer's equipment and the verdict is that our workstations need upgrading (it always is). So on a budget (ie. as cheap as possible), we'll skip Windows 8 and wait for Windows 9, but in the meantime we need...

• Type: Article
• Author: Joel Lipman
• Category: IT Support
• Language: *

Split a row into multiple rows based on a column valuehttp://mail.joellipman.com/articles/database/t-sql/split-a-row-into-multiple-rows-based-on-a-column-value.html

23 August 2013 may vary from 1 and 10+. Not sure on why this is but it doesn't seem to affect the functionality of the above and you could always hardcode a 1.00 if its confusing. In theory, if you know the shift patterns of an employee, you could enhance the above to...

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