Knowledge base / Since 1999
Practical solutions and technical notes from CRM platforms, workflow automation, APIs, databases and the systems around them.
Advanced search209 entries / matching Images
Clear filters
Having trouble ordering your frontpage articles? After re-ordering articles wondering where it was taking the order it puts the articles in the front page (or landing page) was confusing me. The quick answer is that it is within the menu manager > main menu > menu item section of your Joomla! Admin Panel. Certain Advan...
Well I find myself again the dummie of the Internet. I basically came across this error and STFW'd for ages following complex T-SQL Timestamp conversions but to no avail. Not saying that you shouldn't try their solutions but just check you haven't done this silly mistake. I'm only guessing the same error would happen i...
If you need to remove files which are simply the converted versions of music or video files, then this tool asks which folder has the files it will keep and which ones it will send to the Recycle Bin. TESTED ON: - Windows XP, Windows 7 SCREENSHOTS: LICENSE: These scripts are offered freely and in good faith. Please do...
Following up on my article on correcting disappearing headers, a further issue with our web-report is that even an export to Excel (Data Only) from Crystal Reports 9, created extra columns. This issue could not be replicated on the client machine (ie. from my workstation). I would have to upload the report to the serve...
If you've been to the point where you're exporting a report to Excel, and only some of the column headers appear, then try this: I googled this for ages and found different suggestions here and there but none of them produced consistent results. One solution was to untick "Simplify page headers" on the Excel Format Opt...
TESTED ON: - Windows XP, Windows Server 2003, Windows 7 SCREENSHOTS:
Basically I thought that the regional settings of a report generated using Report Builder 2.0 on a MS SQL Server 2008 instance were dependent on either the server or the client machine. Realised that this was actually specified in the report. Here's a quick note on how to set Dates and Times used in parameter fields to...
Dunno about you guys but I've searched the WWW for a solution and couldn't find it. The work around I've documented is a "solution" to my situation and environment. Our setup is: SQL Server 2008 Report Builder 2.0 BMC Service Desk Express 9.8 DataSet1: Incident # Group Name Close Date & Time Assigned to Full Name Incid...
The Issue After modifying a report and on running it, Report Builder 2.0 returns the following error: An error occurred during local report processing. An error has occurred during report processing. Query execution failed for dataset 'DataSet1'. The variable name '@GroupName' has already been declared. Variable names...
Working principle
This site exists as a practical knowledge base built from real-world experience across systems, platforms, and technologies since 1999. Much of the content documents solutions, edge cases, and working patterns that were learned through investigation where documentation was incomplete or absent, and is shared to reduce the same friction for others.
Recently Added
Zoho CRM: Sync Deal and related record owners from Zoho Desk Zoho CRM: Link supplier emails to the Purchase Order Emails related list Zoho CRM's WhatsApp integration now supports multiple accounts, multiple numbers, and custom modules Zoho Books: Improper Statement Error might be due to missing ';' Zoho MCP in 2026: What Claude Can Actually Do Inside Zoho CRMProtected notes
Log in for protected notes and any private client projects assigned to your account.