Report Builder 2.0 - Hide Series1http://mail.joellipman.com/articles/microsoft/ssrs/report-builder-20-hide-series1.html

06 May 2010 most of the jobs suddenly left or moved to another team. To exclude the rest and only show "Series1" Took me a while to figure this out but modify the above statement along the lines of SELECT _SMDBA_.Incident.[Incident #] ,_SMDBA_.Incident.[Group Name]...

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

MySQL parameters in Excel 2007 PivotTableshttp://mail.joellipman.com/articles/database/mysql/mysql-parameters-in-excel-2007-pivottables.html

24 August 2011 the title doesn't put you off but after much Googling and Bing-ing, I still couldn't figure out how to do this. Hopefully this article will help you more than my search engine skills do. My Setup Windows XP Workstation...needs to open... Excel 2007 SP2...

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• 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 storing a note here because it took a while to figure out and googling other solutions did not answer our questions but did lead us to a workaround. So this is regarding an error when trying to add parameters to a Stored Procedure of an Oracle database...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• 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 this article should have got you to the part where you're simply specifying what data displays where. It took me 4 days to figure this out then document it. Here's to hoping that this saves you some time!

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

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

20 November 2012 background disappears and reveals the overall background (blue) making the text very hard to read. Why? Took me a while to figure out what was the problem, I'd visit some pages and they'd be fine, but when visiting a long page, it would initially...

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

SSIS Convert a string into a datehttp://mail.joellipman.com/articles/microsoft/ssis/ssis-convert-a-string-into-a-date.html

14 March 2013 two dates one which was imported as a string (DT_WSTR) and another as a integer (DT_R8). Why? It took me a long time to figure this and it was only by trawling through columns that someone mentioned that maybe all the data in that column is not...

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

Android: Keytool and Google Maps displaying greyhttp://mail.joellipman.com/articles/google/androidos/android-keytool-and-google-maps-displaying-grey.html

31 October 2014 as a checklist to ensure I don't release an app that only displays maps to myself (again). Why? This took me a while to figure out so hopefully this will help others. How? The gist is that I was using the Test SHA1 when adding allowed Android Keys to...

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

Zoho CRM & Zoho Books: Get SalesPersonshttp://mail.joellipman.com/articles/crm/zoho/zoho-crm-zoho-books-get-salespersons.html

30 August 2021 ZohoBooks called "joel_books". The "v_Filter" appears to do absolutely nothing but I've left it in there in case one day I figure it out: // init m_CreateSO = Map(); v_SalesPersonID = ""; // // eval v_BooksOrgID = 12345678901; r_SoDetails =...

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

Zoho CRM: Schedule a Call using Delugehttp://mail.joellipman.com/articles/crm/zoho/zoho-crm-schedule-a-call-with-deluge.html

18 November 2021 in Zoho CRM using Zoho Deluge. Why? Because I find a need to document anything that takes longer than 30 minutes to figure out so I don't spend so long the next time I have to do it. The use-case scenario here is that when an appointment is made for a...

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

Zoho CRM / Deluge: Send an email with a CRM Quote using a given CRM templatehttp://mail.joellipman.com/articles/crm/zoho/zoho-crm-send-an-email-with-a-crm-quote-using-a-given-crm-template.html

18 August 2022 view page of a record and the staff simply click on and it does all the aforementioned. How? The difficult part here was to figure out how to convert the CRM record into a PDF using a customer's template. // // initialize (this is code added to a button...

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

SSRS Use T-SQL Like with a Parameterhttp://mail.joellipman.com/articles/microsoft/ssrs/ssrs-use-t-sql-like-with-a-parameter.html

04 April 2011 AND @ToDate AND rb.[ContactName] LIKE '%@GivenName%' -- WARNING: 0 matching rows This returns nothing. Took me a while to figure why but it's the parameter that's the issue. You don't enclose it with apostrophes for one thing. So let me rewrite this:...

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

Mootools - How to contain a menu sidebar between header and footerhttp://mail.joellipman.com/articles/web-development/mootools/mootools-how-to-contain-a-menu-sidebar-between-header-and-footer.html

10 August 2012 This has taken me too long to figure out and I hope I don't lose this note again. The only website that was titled similarly kept slowing down my computer too much so I decided to work out my own. The complexity is due to content also being dynamically...

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

SELECT COUNT(DISTINCT name) FROM tablehttp://mail.joellipman.com/articles/cms/joomla/select-count-distinct-name-from-table.html

24 September 2015 number. I'm still unsure as to why WHERE...GROUP BY... doesn't return the same totals and will update this article when I figure it out.

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