Parameters not being used in report processinghttps://joellipman.com/articles/microsoft/ssrs/parameters-not-being-used-in-report-processing.html

07 January 2011 - 1, @baseDate) = @SelectedDate AND wm.[WeekNumber] = @weekNumber AND tt.[SiteId] = @siteId AND tt.[Status] 3 -- Remove cancelled bookings AND upper(sd.[Descrip]) not like 'ADDITIONAL TIMETABLE%' ORDER BY Date ASC, Room ASC, tt.[StartTime] ASC,...

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

Connect to Joomla database in standalone scripthttps://joellipman.com/articles/cms/joomla/connect-to-joomla-database-in-standalone-script.html

17 August 2012 // Database name $db_prefix = $Config->dbprefix; // Database prefix (may be empty) // Database prefix (if empty then remove prefixing double underscore) $db_prefix = (trim($db_prefix)=="") ? "":$db_prefix; $db_connect =...

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

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

03 April 2009 this License without regard to the additional permissions. When you convey a copy of a covered work, you may at your option remove any additional permissions from that copy, or from any part of it. (Additional permissions may be written to require their...

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

Warning: Save failed. Another menu item has the same aliashttps://joellipman.com/articles/cms/joomla/warning-save-failed-another-menu-item-has-the-same-alias.html

13 March 2015 same alias in Root. Root is the top level parent You will need: Access to the Joomla Administration Panel (to check for and remove expired menu items) A good database administrator who is comfortable with making changes to the database Why? We have a...

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

Migrating from Joomla 2.5.x to 3.4.xhttps://joellipman.com/articles/cms/joomla/migrating-from-joomla-2-5-x-to-3-4-x.html

12 September 2015 1, INSTR(a.`name`, ':|joe')-1 ) -- FROM `v34_db`.`v34_assets` a -- WHERE a.`name` LIKE '%:|joe|:%' -- Joe-Code: Remove comments UPDATE `v34_db`.`v34_assets` a SET a.`name`=SUBSTRING(a.`name`, 1, INSTR(a.`name`, ':|joe')-1 ) WHERE a.`name` LIKE...

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

Accessing Apimo WebService APIhttps://joellipman.com/articles/automation/api-misc/accessing-apimo-webservice-api.html

29 March 2016 '&agency='.$company_id_1_agency_id. '&company='.$company_id_1. '&brand='.$company_id_1_brand_id ); // remove XML declaration from results $output = substr($output, stripos($output, '?>') + 2 ); // remove leading spaces, carriage returns $output =...

• Type: Article
• Author: Joel Lipman
• Category: API Miscellaneous
• Language: *

Zoho Templates - Font size is inexplicably tinyhttps://joellipman.com/articles/crm/zoho/zoho-templates-font-size-is-inexplicably-tiny.html

22 February 2019 about it, but I went home yesterday downtrodden by an issue which I'd been working on for most of the day where I would remove all the styling and the text would still appear small. Sure I resized the text to about 46pt and everything was over 3000px in...

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

Zoho Deluge: Generate List of TimeZoneshttps://joellipman.com/articles/crm/zoho/zoho-deluge-generate-list-of-timezones.html

19 October 2021 Enderbury (GMT+13:00) Tongatapu (GMT+14:00) Kiritimati This list has the main US ones grouped at the top so let's remove the select and optgroup tags, escape any double-quotes, and prepend/append with a Zoho Deluge list declaration: l_TimeZoneOptions =...

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

Zoho Books: Generate Bank Text File for Downloadhttps://joellipman.com/articles/crm/zoho/zoho-books-generate-bank-text-file-for-download.html

02 October 2023 that file sat on someone's mailbox. It must be downloaded (as in browser downloads it to the computer immediately) and then removed from wherever it was downloaded from... All within ZohoBooks without using any other apps or software. How? Here's how to...

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

Security Checklistshttps://joellipman.com/articles/cms/joomla/security-checklists.html

06 September 2009 2. Change the default administrator username 3. Protect directories and files 4. Adjust file and directory permissions 5. Remove unneeded files 6. Turn Register Globals Emulation OFF 7. Check for extension vulnerabilities 8. Remove junk files Source:...

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

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

06 September 2009 ); Create thankyou page and menu item for ID, change this in the code to redirect to the item ID - remove menu item Ultimately this solved the problem of redirecting the user after they complete the contact form: If you were wondering how to get the...

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

Installing phpBB3 for Joomla with a RocketTheme templatehttps://joellipman.com/articles/cms/joomla/installing-phpbb3-for-joomla-with-a-rockettheme-template.html

28 September 2009 For installation purposes, this mysql user has been granted all privileges (change this after a successful install and remove system privileges such as "drop table"). Upload the compressed file to your http://www.mysite.com/ web root folder and extract...

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

Community Builder in Joomla Vulnerabilityhttps://joellipman.com/articles/cms/joomla/community-builder-in-joomla-vulnerability.html

10 November 2009 index files with strange naming conventions (eg. xzcseifs_kdiek.html) which shouldn't be there either). You'll need to remove these and restore your website. I'd suggest joomlapack if you're using a joomla site, backup just the database, do a fresh...

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

Running Internet Explorer 6, 7, 8 as standaloneshttps://joellipman.com/articles/microsoft/windows-os/running-internet-explorer-6-7-8-as-standalones.html

18 May 2010 disks) It should go about creating a usable virtual hard disk. When it's done click on the small "Start" button below the "Remove" button (not your main Start menu button) As soon as it loads, press DEL to enter the BIOS setup. Navigate to the "Boot"...

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

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

26 May 2010 Bar, Column, Line and Pie). Note that AMCharts.com is free as long as you leave the copyright information. If you want to remove the copyright text that displays on the charts, you need to buy the products of AMCharts.com. I have no afiliation with...

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

Crystal Reports: Exporting to Excel omits column headershttps://joellipman.com/articles/microsoft/excel/crystal-reports-exporting-to-excel-omits-column-headers.html

03 June 2010 the same height. Checked all data field text boxes are aligned and the same width as their respective column heading. Remove any ruler gridlines that don't truly serve a process (even if they're just for margin purposes)

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

Create Read-Only Database User in SQL Serverhttps://joellipman.com/articles/database/create-read-only-database-user-in-sql-server.html

09 November 2010 db_accessadmin Members of the db_accessadmin fixed database role can add or remove access to the database for Windows logins, Windows groups, and SQL Server logins. db_backupoperator Members of the db_backupoperator fixed database role can back up the...

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

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

11 February 2011 I'd put a note on how to remove the toolbar using the URL as I didn't find this clear on the net. Tried it and it didn't work. That's because I was using the Reporting Manager URL rather than the Reporting Server URL. Note: Change "" to the name of your...

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

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

23 March 2011 SET @EndTime = @GivenDate + ' 23:30:00'; --First time of the day (required to display empty rooms) END Add check to SQL to remove rooms with no name. Show hour in top column only on the hour =IIF(MINUTE(Fields!Time.Value)=30, "", Fields!Time.Value) Make...

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

List all cron jobs for all usershttps://joellipman.com/articles/linux/list-all-cron-jobs-for-all-users.html

04 May 2011 # Given a stream of crontab lines, exclude non-cron job lines, replace # whitespace characters with a single space, and remove any spaces from the # beginning of each line. function clean_cron_lines() { while read line ; do echo "${line}" | egrep...

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