Setting a rocket theme background to fixedhttp://mail.joellipman.com/articles/cms/joomla/setting-a-rocket-theme-background-to-fixed.html

06 September 2009 -> Template Manager> Edit the CSS for the template You should be given an option of css files, select styles.css and click on the Edit button Look for these lines: body.bgstyle1 #main-background {background:...

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

SSRS Report Builder 2.0 - Error during processinghttp://mail.joellipman.com/articles/microsoft/ssrs/ssrs-report-builder-20-error-during-processing.html

06 May 2010 or stored procedure. The Quick Fix Return to the Design interface of Report Builder 2.0 for the problematic report: Right-click on the reported DataSet (in my case: DataSet1) and select 'Dataset Properties' Select 'Parameters' and click on the...

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

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

26 October 2011 Every subsequent page simply displays the report header (which does not include the tablix header... obviously). I right-clicked on the header row of the tablix and checked the box "Repeat header columns on each page. Situation I have a report which has...

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

Select unique values in Microsoft Excel columnhttp://mail.joellipman.com/articles/microsoft/excel/select-distinct-values-in-microsoft-excel-column.html

03 July 2012 cells. Display all Unique Found this note on one of Microsoft Help sites: Office 2010: Select the data range to do this to. Click on the "Data" tab. Click on "Advanced" (Advanced Filter). Tick the "Unique records only" box. A few more from Microsoft...

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

SSRS Border Problemhttp://mail.joellipman.com/articles/microsoft/ssrs/ssrs-border-problem.html

20 January 2014 will apply the border to some cells and sometimes a whole section of the report with just one border??? How? In Design view, click on the first cell (top-left), hold down the shift key and click on the last cell (bottom-right). This selects all cells....

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

SSIS: Add Reference Microsoft.SqlServer.TxScripthttp://mail.joellipman.com/articles/microsoft/ssis/ssis-add-reference-microsoft-sqlserver-txscript.html

03 June 2014 this... obvious to Microsoft staff so why should their documentation include it? Workaround (applies for any dll) You right-click on the "references" folder, Select "Add Reference..." Click on "Browse..." Navigate to C:\Windows\assembly Select the...

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

Joomla: Remove IDs from URLs for out-of-the-box SEFhttp://mail.joellipman.com/articles/cms/joomla/joomla-remove-ids-from-urls.html

14 March 2020 and rename it to .htaccess All GUI Now login to your Joomla Administrator section Browse to System > Global Configuration Click on "Articles" in the left sidebar Under "SEO Settings" set to "Yes" to the options: Search Engine Friendly URLs Use URL...

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

Upgrading Joomla CMS version 3.x to Joomla CMS 5.xhttp://mail.joellipman.com/articles/cms/joomla/upgrading-joomla-cms-version-3-x-to-joomla-cms-5-x.html

04 February 2025 in the smart search but I could see them in the category blogs. Login to Administrator > Components > Smart Search > Index Click on the "Index" button in the toolbar and this will popup a progress bar through all your content

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

ZCRM Client Script: Correct Decimal Fields OnLoadhttp://mail.joellipman.com/articles/crm/zoho/zcrm-client-script-correct-decimal-fields-onload.html

13 December 2023 Page is "Edit Page (Standard)" Module is "Products" Layout is "Standard" Event Type is "Page Event" Event is "onLoad" Click "Next" Method 1 This includes a function which counts the number of decimals. I didn't need to use this method for my client;...

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

GDPR Privacy Policyhttp://mail.joellipman.com/static-items/gdpr-privacy-policy.html

14 February 2019 information in the following ways: Whenever you are asked to fill in a form on the website, look for the box that you can click to indicate that you do not want the information to be used by anybody for direct marketing purposes. If you have previously...

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

Privacy Policyhttp://mail.joellipman.com/static-items/privacy-policy.html

30 May 2009 information in the following ways: whenever you are asked to fill in a form on the website, look for the box that you can click to indicate that you do not want the information to be used by anybody for direct marketing purposes if you have previously...

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

Forum Ruleshttp://mail.joellipman.com/static-items/forum-rules.html

31 May 2009 with ****, you have done something wrong. Please edit your post and tone it down before your timer runs out. To edit a post, click the "Edit" button right below it. Cheating the censor system is against the rules. If you break one of these rules, the...

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

How to redirect the visitor after the contact pagehttp://mail.joellipman.com/articles/cms/joomla/how-to-redirect-the-visitor-after-the-contact-page.html

06 September 2009 make sure it is published. Now when you visit your page in the frontend you will see the menu item for the page you created. Click on that link to view your page. We are doing this because you need to find out the exact URL of the page you created. Make...

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

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

08 October 2009 Video Info (complete optional settings) > Make sure "Embed Video into HTML" is checked > Next Specify production name and click on 'FINISH' This will produce a HTML, SWF, XML and JS file in the output directory. We only want the SWF and JS file. Add our...

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

Change the login link in MediaWikihttp://mail.joellipman.com/articles/cms/mediawiki/change-the-login-link-in-mediawiki.html

22 September 2010 version 1.14. Some articles are available for public, some are restricted to staff and different localgroups. When users click on the 'Login' link, we want the system to automatically prompt them for their username/password. (Kerberos authenticated, as...

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

Passwords: Did-you-knowhttp://mail.joellipman.com/hardware/passwords-did-you-know.html

15 November 2010 can opt to have these protected by a 'Master Password' but by default and without this, Firefox will display them all at a click of a button. (source: n/a 08/2008) Password recovery tools for the majority of popular programs we use today are free to...

• Type: Article
• Author: Joel Lipman
• Category: IT Support
• Language: *

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

11 February 2011 view the report properties, the first field in Report Builder or Business Intelligence Development Studio (BIDS) is "Code". Click on the browse button next to it to edit. Visit http://odetocode.com/code/128.aspx Issues encountered Note there appears to...

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

Joes Bug Tracker (JBT)http://mail.joellipman.com/component/content/article/joes-bug-tracker-jbt.html?catid=40

07 July 2011 by JComments or Facebook. Uses MD5 Hash/Sum and numerical post/get data (anti-SQL-injection?). Minimal typing (for click-happy people like me). Currently only allows for back-end Joomla! administration. Automatic version control Automatic changelogs...

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

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

02 September 2011 or you can do this in the next screenshot. Note how all our variables are hidden and cannot be NULL. If you're unsure, right-click on your dataset and bring up its properties... Specify the query type as "Stored Procedure" and then browse the dropdown...

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

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

10 November 2011 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 and it would take them to http://ora-00201.ora-code.com/. The Padding Found this in a forum so thought I'd...

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