SSRS Repeat Headers in PDF Reporthttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-repeat-headers-in-pdf-report.html

26 October 2011 some tablix headers but when I request the same report in PDF format, the tablix headers only appear once on the first page. Every subsequent page simply displays the report header (which does not include the tablix header... obviously). I right-clicked...

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

Free Translator API using Googlehttps://www.joellipman.com/articles/google/free-translator-api-using-google.html

08 January 2013 article to get your Google Translation services working with your website. Why? At time of print, Google now charge for every 2,000,000 characters (2 million) every month. Microsoft's Bing has added itself to the fray pretending to offer free services...

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

Zoho CRM: Client Script Confirmation Box and Popup Mailerhttps://www.joellipman.com/articles/crm/zoho/zoho-crm-client-script-prompt-and-popup-mailer.html

06 February 2024 repeating a script from the Zoho Kaizen series allowing a confirmation box (something lacking in Zoho Creator - but that every app outside of Zoho has) as well as a popup to email from CRM with a rich-text interface. Why? The use-case here is...

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

Disclaimerhttps://www.joellipman.com/static-items/disclaimer.html

30 May 2009 sites. The inclusion of any links does not necessarily imply a recommendation or endorse the views expressed within them. Every effort is made to keep the website up and running smoothly. However, Joel Lipman .Com takes no responsibility for, and will...

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

Add the website name to the page title in Joomla!https://www.joellipman.com/articles/cms/joomla/add-the-website-name-to-the-page-title.html

06 September 2009 to display both the actual page title and other stuff. As I like doing this for this particular website (my personal one) in every version of Joomla it's been upgraded to, I've noticed some differences that I've noted down below. Specific Joomla...

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

Database Error: Unable to connect to the database: Could not connect to MySQLhttps://www.joellipman.com/articles/database/mysql/database-error-unable-to-connect-to-the-database-could-not-connect-to-mysql.html

25 September 2009 same reasons. I installed the standard 1.5 installation package. I have uninstalled and reinstalled once just to make sure everything was OK. Basically after I use my website (using the default Joomla welcome template with NO modifications whatsoever) I...

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

How To Make Chocolate Chip Cookieshttps://www.joellipman.com/articles/_other-misc/how-to-make-chocolate-chip-cookies.html

30 September 2009 Everyone loves chocolate chip cookies, and with VideoJug's special recipe, it's easy to make the perfect chocolate chip cookie every time. You Will Need: 150 g sugar 160 g brown sugar, , packed 220 g butter 2 eggs, , large 2 tsp vanilla extract 280 g...

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

Mediawiki Extension for Camtasia Studio SWF videoshttps://www.joellipman.com/articles/cms/mediawiki/mediawiki-extension-for-camtasia-studio-swf-videos.html

08 October 2009 to the wiki } Amend your skin files Amend your skins to include the reference to this script in between the head tags of every page, so Amend your LocalSettings.php file Add the following the the LocalSettings.php file in your mediawiki root folder:...

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

Windows 7: System Clock is constantly going out of synchttps://www.joellipman.com/articles/microsoft/windows-os/windows-7-system-clock-is-constantly-going-out-of-sync.html

28 January 2010 side for SpecialPollInterval The default time period is 7 days calculated in seconds. If you wanted to change this to update every day, you would use 86400, or 60 seconds * 60 minutes * 24 hours * 1 day. I wouldn’t recommend setting this to anything...

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• Language: *

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

25 February 2010 documents, phone - aim for lightweight) Include all files used in the development (source files, visuals, documents) Explain every incremental change will render design less elegant and consistent Ask client to go over documentation (separate technical...

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

Remove write-protect from USB pen in Windowshttps://www.joellipman.com/articles/microsoft/windows-os/remove-write-protect-from-pen-in-windows.html

13 April 2010 to upgrade my 16Gb USB Integral Pen from Play.Com to a 32Gb equivalent. I use my USB pen as the "My Documents" folder on every computer I use. It was fine with my 16Gb one but my 32Gb ones have all failed at some point. I went for a cheap one on...

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

Joe's CSV Chart Generator (JCG)https://www.joellipman.com/component/content/article/joellipmans-csv-chart-generator.html?catid=40

26 May 2010 system AMCharts.com. AMCharts.com provide a flash-based interactive chart which you can zoom in and out of, includes almost every type of chart you can think of (though this program only uses chart types: Area, Bar, Column, Line and Pie). Note that...

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

SQL Calendar in Business Intelligence Development Studiohttps://www.joellipman.com/articles/database/t-sql/sql-calendar-in-business-intelligence-development-studio.html

14 January 2011 Dates([Date]) AS ( --Select First day in range SELECT CONVERT(DATETIME,@StartDate) AS [Date] UNION ALL --Add a record for every day in the range SELECT DATEADD(DAY, 1, [Date]) FROM Dates WHERE Date...

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

Room Availability Calendar in Business Intelligence Development Studiohttps://www.joellipman.com/articles/microsoft/ssrs/room-availability-calendar-in-business-intelligence-development-studio.html

23 March 2011 Times([Time]) AS ( --Select First hour in range SELECT CONVERT(DATETIME,@StartTime) AS [Time] UNION ALL --Add a record for every half-hour in the range (change based on slot times) SELECT DATEADD(MI, 30, [Time]) FROM Times WHERE Time...

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

Developer's Checklist: Taking over a projecthttps://www.joellipman.com/articles/web-development/developers-checklist-taking-over-a-project.html

01 March 2011 of Security Testing (XSS and SQL-Injection at least?) Referenced common files / global assets (especially those used in every page) Expert/Testing/Resistant users (contact details and informally their technical knowledge/skills) Availability via...

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

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

28 April 2011 said but it's still not working". "From my logs, you haven't restarted this machine in a while.". "No I definitely log off every evening and then back on again". "You mean you log back on in the morning?" "No it takes so long in the morning, this is...

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

Run commands for Windowshttps://www.joellipman.com/articles/microsoft/windows-os/run-commands-for-windows.html

05 July 2011 sfc /scannow System File Checker Utility (Scan Once At The Next Boot) sfc /scanonce System File Checker Utility (Scan On Every Boot) sfc /scanboot System File Checker Utility (Return Scan Setting To Default) sfc /revert System File Checker Utility...

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

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

11 October 2011 values in last data row with blanks The trick to this is to get Stage #1 working for you with your query and then for every column of data that you are extracting, you will need to use the case statement to either put the value or your empty row. Here's...

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

Search a database with SOUNDEXhttps://www.joellipman.com/articles/database/search-a-database-with-soundex.html

11 October 2012 well, eg. "Daat ont Ety Aviable". How? Mine's a bit of a copout as it is a two-step process. I wanted a query that searched every column containing strings in the database and we are somewhat limited in Sql Server 2008 R2 by 4000 characters in a...

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

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

03 April 2009 GENERAL PUBLIC LICENSE Version 3, 29 June 2007 Copyright © 2007 Free Software Foundation, Inc. Everyone is permitted to copy and distribute verbatim copies of this license document, but changing it is not allowed. Preamble The GNU General Public License...

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