SSRS Expand specific drilldown by defaulthttp://mail.joellipman.com/articles/microsoft/ssrs/ssrs-expand-specific-drilldown-by-default.html

23 February 2011 thought I'd put something here as there are lots of posts like this on forums (a lot of which seem to be copied & pasted from other sites) but they refer to SQL Server 2000 or SQL Server 2005. This is how to do it in SQL Server 2008 and creating a...

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

Oracle SQL - Convert given list (CSV) into Rowshttp://mail.joellipman.com/articles/database/pl-sql/oracle-sql-convert-given-list-csv-into-rows.html

30 August 2011 a quick note as to something that worked for me. Taken from the Oracle forums @ https://forums.oracle.com/forums/thread.jspa?messageID=6861756 Situation I have one column of values that I've suffixed a comma to but I want to display this as a rows in a...

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

MediaWiki: MySQL to extract path to imageshttp://mail.joellipman.com/articles/cms/mediawiki/mediawiki-mysql-to-extract-path-to-images.html

06 December 2011 of September 2011. I've left it in there for my own benefit as it's unlikely I'm asked for an entire export. Should yield something like: img_name img_size img_user_text img_timestamp img_path img_path_with_file ============== ==============...

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

Warning call_user_func: First argument is expected to be a valid callbackhttp://mail.joellipman.com/articles/cms/joomla/warning-call-user-func-first-argument-is-expected-to-be-a-valid-callback.html

22 November 2012 What? If you get something like the following error: Warning: call_user_func() [function.call-user-func]: First argument is expected to be a valid callback in /home/.../templates/rt_affinity/rt_sectionrows.php on line 311 How? Copy & backup the file...

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

SSRS Display question mark when date is blankhttp://mail.joellipman.com/articles/microsoft/ssrs/ssrs-display-question-mark-when-date-is-blank.html

15 April 2014 like a question mark to display if there is no date to populate the field. Why? At the moment, the expression in there is something like this: =Format(Fields!MyCompletionTime.Value, "dd/MM/yyyy HH:mm:ss") -- yields 11/02/2014 11:21:32 Sounds good,...

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

SITS: XET format for Export not availablehttp://mail.joellipman.com/articles/web-development/xml/sits-xet-format-for-export-not-available.html

08 August 2014 go and retrieve a student/staff (depending on what data your XET feeds off) Bring up STU File > Export... You should have something similar to the following:

• Type: Article
• Author: Joel Lipman
• Category: Extensible Markup Language
• Language: *

Error 404 Component Not Found when enabling SEF URLshttp://mail.joellipman.com/articles/cms/joomla/404-component-not-found-sef.html

02 September 2015 contact the System Administrator of this site and report the error below. 404 Component not found. Just because I'm doing something like this: How? I found that this was only affecting my subdomains where this template was installed. I installed some...

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

MySQL Transactions in PHPhttp://mail.joellipman.com/articles/database/mysql/mysql-transactions-in-php.html

14 December 2016 1 row affected by each query if ($a1==1 && $a2==1) { //Everything looks OK, commit changes $mysqli->commit(); } else //Something went wrong. Roll back to before begin_transaction() $mysqli->rollback(); } $mysqli->close(); mysqli->begin_transaction()...

• Type: Article
• Author: Ike Francis
• Category: MySQL
• Language: en-GB

Zoho Deluge: Push a value to a datetime field in CRMhttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-push-a-value-to-a-datetime-field-in-crm.html

10 September 2021 quick article to show pushing the date and time to ZohoCRM or ZohoCreator. Why? You may have received an error that goes something like: datatype: datetime How? Here are some formatting examples: Creator to CRM: v_CreatorTime =...

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