SSRS / MDX Date Querieshttps://www.joellipman.com/component/content/article/ssrs-mdx-date-queries.html?catid=75&Itemid=165

03 August 2011 myself using date ranges endlessly as I've been working in SSRS. The below is derived from a collection of various sources across the web as well as some of my own. These are what worked in my environment: WinXP, BIDS (vs2008), TFS (vs2010), SSRS 2008...

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

Include a carriage return in a column headinghttps://www.joellipman.com/component/content/article/include-a-carriage-return-in-a-column-heading.html?catid=78&Itemid=165

07 July 2014 data source located on a database on the other side of the world. I want the header in the column "Academic Week" to break across two lines so that the column doesn't expand to the width of "Academic Week" and instead expands to the width of the word...

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

Error during processing - Converting Date/Timehttps://www.joellipman.com/articles/else/database/t-sql/error-during-processing-converting-datetime.html

13 July 2010 Well I find myself again the dummie of the Internet. I basically came across this error and STFW'd for ages following complex T-SQL Timestamp conversions but to no avail. Not saying that you shouldn't try their solutions but just check you haven't done...

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

Drop If Object Existshttps://www.joellipman.com/articles/else/database/t-sql/drop-if-object-exists.html

03 August 2012 2008 Management Studio doesn't like this and refuses to understand what I'm trying to do. Why? As this data seemed to be across various websites, I wanted a page which has all of them in one place. So here you go, I hope it's of some use. If it's wrong...

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

Webdeveloper-Speakhttps://www.joellipman.com/articles/cms/website-development/webdeveloper-speak.html

13 July 2010 I don't usually write an article on another site but I came across it and rather than just add it to my weblinks section, I thought I'd give it a little more credit. "Motive is a web design and development agency based in Wellington, New Zealand...

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

CSS keeping the footer at the bottomhttps://www.joellipman.com/articles/cms/website-development/css/css-keeping-the-footer-at-the-bottom.html

25 April 2011 enough time trying different methods across the web but only 1 article worked for me using the "push" div layer. Loosely based on Ryanfait: Make a Footer Stick to the Bottom of the Page Aim: Header Left Right Footer Situation The header displayed fine....

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

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

20 November 2012 on a small page but I have discovered limitations with the majority of browsers when having to spread gradient backgrounds across a long page. It would appear to be fool proof because of the "background:#f7f7f7" specified at the beginning of the code...

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

Sort an associative array by values in Javascripthttps://www.joellipman.com/articles/cms/website-development/js/sort-an-associative-array-by-values-in-javascript.html

29 September 2015 is true but quite unhelpful. The original code is not my own either but that's not an excuse. I also found that examples across the web were only partial and thought I'd write a full example here. No jQuery and using the Google Chrome browser. I wanted...

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

DJI Phantom FC40 Paint-Job and AerialFreaks Cyclops FC40 Gimbal Upgradehttps://www.joellipman.com/component/content/article/dji-phantom-fc40-paint-job-and-aerialfreaks-cyclops-fc40-gimbal-upgrade.html?catid=113&Itemid=165

04 September 2014 really worried but it's coming out really nicely Sparkly! and Shiny Hmm... wrong way round, the compass cable seems to go across the unit unless I have the top sticker wrong Legs on Checking vents (note I had masked these before painting as per youtube...

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

Zoho People Analytics Regional Configurationhttps://www.joellipman.com/articles/crm/zoho/zoho-people/zoho-people-analytics-regional-configuration.html

02 February 2026 be visible No tables, queries, or report editing should be accessible At this stage, the user will be able to see employees across all regions, which is expected. Remove the Test User from the Employee Dashboard Well simply remove the group that test...

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

Joes WebGL Experimenthttps://www.joellipman.com/component/content/article/joes-webgl-experiment.html?catid=53&Itemid=165

06 April 2013 replacement for Joes Revolver Maps? So I recently came across the Chrome Experiments WebGL Globe which I think is beautiful; here's a screenshot of what I envisaged though: Demo It's still in development and a somewhat stable beta version is demo'd at...

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

Clicking on a weblink returns a 404 errorhttps://www.joellipman.com/articles/cms/joomla/clicking-on-a-weblink-returns-a-404-error.html

06 November 2009 If you are in the administration panel and you are editing your weblinks and you come across this error: "404 - An error has occurred. Joomla! was unable to locate the stated resource." Just check that the category the link is in is published.

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