URL passed settings in Reporting Serviceshttp://mail.joellipman.com/articles/microsoft/ssrs/url-passed-settings-in-reporting-services.html

11 February 2011 didn't find this clear on the net. Tried it and it didn't work. That's because I was using the Reporting Manager URL rather than the Reporting Server URL. Note: Change "" to the name of your Reporting Server Change...

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

SSRS Hide results table if emptyhttp://mail.joellipman.com/articles/microsoft/ssrs/ssrs-hide-results-table-if-empty.html

29 March 2011 assets database and want to list the equipment and features found inside the room. Problem #1: More of an aesthetic problem than functional but when the room didn't contain equipment (or the admins had not added the equipment info on the system), it...

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

Difference between two dates - the midnight hourhttp://mail.joellipman.com/articles/web-development/difference-between-two-dates-the-midnight-hour.html

06 April 2011 please)? The Solution Eureka! Or duh! for those that it's obvious to... Compare the two timestamps, if the "To date" is less than the "From date" then add 1 day to the date: $thisDateSQL=date("Y-m-d", strtotime($sub_row['DateSession']));...

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

Inserting incremental weeks in MySQLhttp://mail.joellipman.com/articles/database/mysql/inserting-incremental-weeks-in-mysql.html

15 April 2011 it should return the additional 52 rows we want add. Note that the table "WeekStructure" could have been any table with more than 52 rows, I'd say specify the table you will NOT be adding these rows to... SET @count:=0; SELECT '2012/2013' AS SetID,...

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

Joes Quicklist Weblinks (JQW)http://mail.joellipman.com/component/content/article/joes-quicklist-weblinks-jqw.html?catid=40

03 July 2011 Thumbnail Services will give you a limited number of free thumbnail generations. About 100,000 on average which is more than enough for our Joomla! website (unless you're reinventing the wheel by making a Joomla! Google Directory). Let's say I have...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• 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 Reporting Services as a replacement for website applications. We only did it because we have more staff trained in SSRS than in bespoke third-party software and the ability to support/develop outweighed the cons.

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

SSRS Parameters in Oracle Stored Procedurehttp://mail.joellipman.com/articles/microsoft/ssrs/ssrs-parameters-in-oracle-stored-procedure.html

02 September 2011 (SSRS) with Team Foundation Server 2010. The database with our stored procedure is Oracle 10g. The Stored Procedure Rather than a returned dataset, our Stored Procedure updates a field in one of our Oracle tables and returns nothing. It accepts 3...

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

Migrate Joomla Users to WordPresshttp://mail.joellipman.com/articles/cms/wordpress/migrate-joomla-users-to-wordpress.html

03 October 2011 'display_name' FROM my_joomla_db.jos_users a ORDER BY a.id; A bit more to do: PHP file So I needed to do a loop and rather than complicate things with stored procedures and cursors, it's likely if you're using either Joomla or Wordpress that you have a...

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

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

11 October 2011 marked with the separator marker of Stage #1 (note that here separator marker is marked by day1 does not equal day2 rather than a column called marker): --Create CTE WITH tblDifference AS ( SELECT t1.*, ROW_NUMBER() OVER (ORDER BY t1.Date ASC, t1.Start...

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

SSRS Zero Paddinghttp://mail.joellipman.com/articles/microsoft/ssrs/ssrs-zero-padding.html

10 November 2011 in the format of -12345. If we want to look them up the error is ORA-12345. Unfortunately Oracle also returns errors of less than 10000 so ORA-00201 would actually be returned as "-201". As I wanted a link so that the user can just click on this link...

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

Joes DNS Correction (JDC)http://mail.joellipman.com/component/content/article/joes-dns-correction2.html?catid=40

25 November 2011 and my computer will say that it could not connect to either the TFS or my target deploy location. I found a quicker fix than rebooting your computer which is to open a command prompt and to type "ipconfig /flushdns" then "ipconfig /registerdns" and the...

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

Performance Report - Background colors based on dataset valueshttp://mail.joellipman.com/articles/microsoft/ssrs/green-red-background-colors-based-on-dataset-values.html

02 December 2011 the rows as... rows. My pic above shows my 4 reports results side by side. To do this, I had to insert a Matrix rather than a Tablix: Insert a "Matrix" into the body of your report. Drag "ReportName" into the field that says "Columns". Right-click on...

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

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

14 December 2011 = Select the dataset of dropdown options, pay attention to the value in "Value field" (as I kept putting the label rather than the value field) to make this all work. Notes: My convert part of my SQL query is because I had to match the datatype used by...

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

Getting the mysql where in delimited string to workhttp://mail.joellipman.com/articles/database/mysql/getting-the-mysql-where-in-delimited-string-to-work.html

02 January 2012 delim, '')))/LENGTH(delim) + 1; -- get total number delimeters and add 1 -- add 1 since total separated values are 1 more than the number of delimiters -- start of while loop WHILE(ctr

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

Basic Oracle Stored Procedure Structurehttp://mail.joellipman.com/articles/database/pl-sql/basic-oracle-stored-procedure-structure.html

16 January 2012 first to return the ID of the student, and then to use this number in a second query which we're hoping will be quicker than a straightforward table join. Syntax CREATE [OR REPLACE] PROCEDURE stored_procedure_name [ (parameter [,parameter]) ] IS | AS...

• Type: Article
• Author: Joel Lipman
• Category: Oracle PL/SQL
• Language: en-GB

Returning Oracle Stored Procedure Resultset in SSRShttp://mail.joellipman.com/articles/microsoft/ssrs/returning-oracle-stored-procedure-resultset-in-ssrs.html

19 January 2012 from an Oracle stored procedure and displaying this in SQL Server Reporting Services (SSRS). Well "non-productive" more than "fun" as most of the examples on the net are either half-complete or partially documented. So here goes... Using Business...

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

Basic Joomla 2.5 Mootools Formhttp://mail.joellipman.com/articles/cms/joomla/basic-joomla-25-mootools-form.html

20 August 2012 me how to send a form asynchronously (ie. running in the background without loading a new page). How? This form is more AJ than AJAX as I don't even use an XML file. You'll need to create a receiving file that sends back the data, in my case, I've...

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

T-SQL example of Case-Sensitive Soundexhttp://mail.joellipman.com/articles/database/t-sql/t-sql-example-of-case-sensitive-soundex.html

10 October 2012 -- yields StudentDetail ----------------- Data Not Yet Available Which isn't at all what we set out to achieve other than it identified the remaining values as having the same SOUNDEX value. Adding the COLLATE option straight after the column that needs...

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

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

11 October 2012 ** AND TABLE_SCHEMA='dbo' ** ** ** ** - For performance, return results based on string length which is 1 greater or lesser than the original ** ** string value: ** ** Automatic: ** ** @minStringLength and @maxStringLength are calculated based on...

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

Battery Constantly Drained on iPhonehttp://mail.joellipman.com/articles/apple/battery-constantly-drained-on-iphone.html

27 November 2012 to "remind you". The reminder here was to charge the phone but it was the reminder which would drain a full charge in less than a day.

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