Alternate row background colour in Reporting Serviceshttps://www.joellipman.com/articles/microsoft/ssrs/alternate-row-background-colour-in-reporting-services.html

04 February 2011 there's a faster way) and instead of color, click on the expression button (fx) and use the following: =IIF(RowNumber(Nothing) Mod 2, "#ffffff", "#eeeeee") or =IIF(RowNumber(Nothing) Mod 2, "WhiteSmoke", "Garamond") This is telling the report to be...

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

Foreign Characters create symbols in PHP and MySQLhttps://www.joellipman.com/articles/web-development/php/foreign-characters-create-symbols-in-php-and-mysql.html

25 January 2016 How does it happen? Have I tried the other solutions on the web? I have tried adding the following to my headers: This does nothing: // add these to the header: DOESNT WORK mb_internal_encoding('UTF-8'); mb_http_output('UTF-8'); mb_http_input('UTF-8');...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB

Licence GNU/GPLhttps://www.joellipman.com/static-items/licence-gnugpl.html

03 April 2009 solely as a consequence of using peer-to-peer transmission to receive a copy likewise does not require acceptance. However, nothing other than this License grants you permission to propagate or modify any covered work. These actions infringe copyright...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *

Zoho CRM: Mapping a Multi-User or Multi-Lookup field using Delugehttps://www.joellipman.com/articles/crm/zoho/zoho-crm-mapping-a-multi-user-or-multi-lookup-field-using-deluge.html

28 April 2021 code to populate the multi-lookup field if(!isnull(r_Create.get("id"))) { m_Link = Map(); // using record IDs cos there's nothing better m_Link.put("Test",r_Create.get("id")); // using record IDs cos there's nothing better...

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

Zoho Deluge: Nested Catch Statementshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-nested-catch-statements.html

04 February 2025 in HTML and we want a PDF file returned. I have severaly instances of an API which accepts HTML and returns a PDF file. Nothing complex but issues with one of the servers being down, or inaccessible due to certificate expirys, means that the Cx business...

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

Project Plan for Freelance Websitehttps://www.joellipman.com/articles/web-development/project-plan-for-freelance-website.html

25 February 2010 support to be arranged prior to launch Discuss expectations for changes and support (response times) Critical - nothing works! Major - something important is broken Minor - less urgent but still broken Request - nice to have Support structure /...

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

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

04 February 2011 scenery, a face in the audience, an irruption of the audience on to the stage, and all our carefully planned gestures mean nothing, or mean too much."

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

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

29 March 2011 and pasting from other sites to add content to my own. And I'm not just adding content, the way I'm doing the below is nothing similar to what I googled (probably a bad sign but time is ticking and no one has forever). Situation: I have a report which...

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

CSS Background Without Causing Scrollbarshttps://www.joellipman.com/articles/web-development/css/css-background-without-causing-scrollbars.html

23 April 2011 specified it's left. It caused the horizontal scrollbar which is a bit annoying because you scroll to the right and theres nothing but some background image. Also the footer was at 100% so it got cut off if you scrolled horizontally. Aim / Objective To...

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

What's the problem? Amusing computer issueshttps://www.joellipman.com/articles/web-development/whats-the-problem-amusing-computer-reports.html

28 April 2011 the whole purpose! A media student: "My computer has swallowed my CD-Rom, I put in the disk but when I eject the CD there's nothing in there!". I can't really have a go at customers as it took 4 IT technicians deliberating over 30 minutes (remote...

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

Joes FREE Website Thumbnailer (JWT)https://www.joellipman.com/component/content/article/joes-free-website-thumbnailer.html?catid=40

28 June 2011 thumbnails follow the same restrictions as the MS Windows filesystem (so no colons, back/forward slashes, etc). If there is nothing specified, it will name it something like "000065.bmp". Do not include the file extension (and the dot/period) as this is...

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

Unix Date Format Specifiershttps://www.joellipman.com/articles/linux/unix-date-format-specifiers.html

05 July 2011 date and time Sat Nov 04 12:02:33 EST 1989 Time zone %z -zzzz RFC-822 style numeric timezone -0500 %Z time zone (e.g., EDT) nothing if no time zone is determinable EST

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

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

02 September 2011 Procedure Rather than a returned dataset, our Stored Procedure updates a field in one of our Oracle tables and returns nothing. It accepts 3 parameters: The StudentID (reference) varchar2, Username (who's running the report) varchar2 and a JobID...

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

Joes Network Transmission Detector (JTD)https://www.joellipman.com/component/content/article/joes-network-transmission-detector-jtd.html?catid=40

29 September 2011 boring and doesn't do anything. But unlike many other similar programs which add to the network traffic, this program adds NOTHING to the network traffic, and therefore is a much better measure of what data is being received/sent from your workstation....

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

Stop Excel Row Height Self-Adjust on Refreshhttps://www.joellipman.com/articles/microsoft/excel/stop-excel-row-height-self-adjust-on-refresh.html

30 September 2011 adjust their row to fit but all others were left untouched. Perfect! Other Searches that I may search for again but get me nothing stop row height change on refresh data excel 2007 excel row height refresh data row height being reset on refresh excel...

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

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

19 January 2012 my columns. Two output fields are expected to be returned: "p_STUDENT_DETAILS" and "p_STUDENT_REF". 2. Add a datasource Nothing different to your usual method of connecting to a data source, I just added this section to say that my data source is type...

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

Inline Labels in Form Fields using Javascripthttps://www.joellipman.com/articles/web-development/js/inline-labels-in-form-fields-using-javascript.html

21 August 2012 -- split this value into an array separated by the delimiter character "" -- join this array back replacing any spaces with nothing Examples: -- If field is "Joes Just Joking!" yields "JoesJustJoking!" -- If field is " Space is a big place " yields...

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

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

21 January 2013 these. As for MSIE, 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...

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

Export/Import Database using MySQL Workbenchhttps://www.joellipman.com/articles/database/mysql/export-import-database-using-mysql-workbench.html

05 February 2013 specify to export to a Self-Contained File and click on Start Export: Importing Before importing a SQL file, check that nothing in it instructs it to use a specific database (otherwise you might overwrite your LIVE/production database). Click on the...

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

SSRS Stop Scrolling Behindhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-stop-scrolling-behind.html

08 April 2014 content as if it were a header that had been told to keep visible while scrolling. The fix in a nutshell is to ensure nothing is kept visible while scrolling. This issue is specific to my template because the entire report is displayed within a tablix...

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