Knowledge base / Since 1999
Practical solutions and technical notes from CRM platforms, workflow automation, APIs, databases and the systems around them.
Advanced search342 entries / matching Data
Clear filters
Intro If you ever want to check the parameters submitted with a report for alpha numeric characters (so it doesn't contain symbols, punctuations, etc) then you should do this at the database level, and then get the report to complete the check: The Plan User enters value in parameters and clicks on "View Report" Report...
We have a report in SQL Server Reporting Services 2008 R2 (SSRS) reading from an Oracle 10g database which works great and lists all the details on a specific student. An additional request is that there appears a link that will run a stored procedure which Updates a timestamp in an existing table Inserts a row into an...
Why? I recently made a joomla module that displays the lastest members to signup. It goes a little further and counts activated accounts for the past day, week, month and year (the below examples count all accounts irrespective of being activated or not). It needs to pick up trends as well and compare for example today...
My Setup XP SP3 Workstation Business Intelligence Development Studio 2008 (BIDS) SQL Server Reporting Services 2008 R2 (SSRS) What do I want? I have a report displaying room bookings. Each row lists the day, date, room name, start/finish times, booking details and the staff contact. I want an empty row to appear betwee...
The Problem I've set 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 on the header row of the tablix and checked t...
I have googled, binged and asked but to no avail. Some self-proclaimed IT experts in forums said "why would you want to do that?". Unhelpful Bellends. It's a bit like asking me "Why can't I turn on my computer" and me replying "why would you want to do that?". Anyway, I was looking for something like the record separat...
This is for Joomla 1.5.x sites! Note that this article is for Joomla 1.5.x sites to be converted to Wordpress 3.2.x sites. I started with a Joomla 1.5 as the move from Joomla 1.6 or greater is a lot easier since it uses nested categories like Wordpress. There are lots of commercial migrators out there and they all seem...
The Situation I have a Microsoft Excel 2007 file that connects to a SQL Server 2008 R2 database. The Excel file pulls data using lookup tables and displays the data in an Excel Spreadsheet. The Problem We can select all cells and set row height to be 30 for example, but everytime we refresh the data in the Excel spread...
So this is a program I've been wanting for ages. Only way to be sure it doesn't have any malicious code and that it does what I want and looks like I want it to look, was to make my own. What does it do? Amazing. It detects transmissions over a network. Basically on a computer that isn't on a network (ie. not connected...
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 Books: Change a Purchase Order's Delivery Address over API Zoho CRM: Presenting ABM for Zoho CRM: Expand and retain your customers with precision Zoho CRM: Announcing the new SKILL.md for Zoho CRM and the updated OAS repository! Zoho CRM: Allow Only Administrators To Change Task Owners Zoho Billing: Workflow does not exist!Protected notes
Log in for protected notes and any private client projects assigned to your account.