Advanced Search

Here are a few examples of how you can use the search feature:

Entering this and that into the search form will return results containing both "this" and "that".

Entering this not that into the search form will return results containing "this" and not "that".

Entering this or that into the search form will return results containing either "this" or "that".

Search results can also be filtered using a variety of criteria. Select one or more filters below to get started.

Assuming appear is required, the following 47 results were found.

  1. Blank columns issue when exporting to Excel (Data Only) from Crystal Reportshttps://www.joellipman.com/component/content/article/blank-columns-issue-when-exporting-to-excel-data-only-from-crystal-reports.html?catid=110&Itemid=165

    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....

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: *
  2. Crystal Reports: Exporting to Excel omits column headershttps://www.joellipman.com/component/content/article/crystal-reports-exporting-to-excel-omits-column-headers.html?catid=110&Itemid=165

    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...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  3. ZohoBooks: Broken UK Banking Feedhttps://www.joellipman.com/articles/crm/zoho/zoho-books/zohobooks-broken-uk-banking-feed.html

    old feed has been cleared, go to Banking > Connect Bank. In the search box, start typing and if there is a feed, it should appear. You will want the modern Open Banking connection that replaces the old Yodlee and Plaid labels. Follow the prompts to log...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  4. Room Availability Calendar in Business Intelligence Development Studiohttps://www.joellipman.com/component/content/article/room-availability-calendar-in-business-intelligence-development-studio.html?catid=75&Itemid=165

    Test1 Room 08:00:00 08:00:00 2011-03-23 08:00:00.000 Test2 Room 08:00:00 09:30:00 2 Note that [Test1 Room] will appear as a row but have no slots booked against it. [Test2 Room] will both appear as a row and have 3 slots taken up (if you left the above...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: *
  5. SSRS External Images don't displayhttps://www.joellipman.com/component/content/article/ssrs-external-images-dont-display.html?catid=75&Itemid=165

    2008 R2 Reporting Server (SSRS) running on Windows Server 2003 Team Foundation Server 2010 (TFS) Problem #1: Image does not appear within SSRS When previewing the report in BIDS, the photo appears fine. If we deploy the report to our Reporting Server...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: *
  6. Background Gradient Disappears on Long Pageshttps://www.joellipman.com/articles/cms/website-development/css/background-disappears-on-long-pages.html

    on the site, the contents background (white) shows. When I visit a very long page on the site, the contents background disappears and reveals the overall background (blue) making the text very hard to read. Why? Took me a while to figure out what was...

    • Type: Article
    • Author: Joel Lipman
    • Category: Cascading Stylesheets
    • Language: *
  7. XML Schema Referencehttps://www.joellipman.com/articles/cms/website-development/xml/xml-schema-reference.html

    Elements Element Explanation all Specifies that the child elements can appear in any order. Each child element can occur 0 or 1 time annotation Specifies the top-level element for schema comments any Enables the author to extend the XML document with...

    • Type: Article
    • Author: Joel Lipman
    • Category: Extensible Markup Language
    • Language: en-GB
  8. GDPR Privacy Policyhttps://www.joellipman.com/component/content/article/gdpr-privacy-policy.html?catid=50&Itemid=165

    • Type: Article
    • Category: Static Items
    • Language: *
  9. PC Build 2022: 5 Monitors connected to 1 PC using 1 GPUhttps://www.joellipman.com/component/content/article/pc-build-2022-5-monitors-connected-to-1-pc-using-1-gpu.html?catid=45&Itemid=165

    your PC Weirdly, the BIOS will load up on my one monitor connected to my motherboard, but my windows login screen will appear on my central monitor (after further reboots my daisy chained 2 monitors now load the bios logo with the primary monitor...

    • Type: Article
    • Author: Joel Lipman
    • Category: Articles
    • Language: *
  10. Joes Quicklist Weblinks (JQW)https://www.joellipman.com/component/content/article/joes-quicklist-weblinks-jqw.html?catid=53&Itemid=165

    page until all thumbnails have been generated. Switch "STOP Thumbnail Service" to "YES" Logout NB: Thumbnails will first appear blue as the service downloads/queues them. Adding a weblink: Add your Joomla! weblink as per usual Switch "STOP Thumbnail...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  11. Zoho Templates - Font size is inexplicably tinyhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-templates-font-size-is-inexplicably-tiny.html

    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 width but this is not good for a final...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  12. Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Bookshttps://www.joellipman.com/articles/crm/zoho/zoho-books/zoho-creator-download-uploaded-file-and-attach-to-sales-order-in-zoho-books.html

    There is a lag/delay in the synchronization of Zoho Books to Zoho CRM and vice-versa. Annoyingly the attachment does not appear to be included in any sync... This method would be enough if the action was instantaneous and the attachments were also...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  13. Zoho Deluge: Setup an API Connection for InvokeURLhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-setup-an-api-connection-for-invokeurl.html

    and Connect" You will get a popup confirming what this app will access and you should click on "Accept": A quick popup will appear to say connected. Done! Now you can use this in your custom function with the invokeURL without the need for a header...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  14. Zoho Creator: Button on Report for Merging Multiple Selected Recordshttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-button-on-report-for-merging-multiple-selected-records.html

    Records". Amazing! You're all done! Go test it by going to the report, hover the mouse over each row and a tickbox will appear, tick a few and click on your newly made button (as per the first screenshot on this article).

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  15. Zoho CRM: Mapping a Multi-User or Multi-Lookup field using Delugehttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-mapping-a-multi-user-or-multi-lookup-field-using-deluge.html

    changes. I now query all the records held so far in this linking module which I'm guessing is called Quotes_X_Users (would appear in the popup once you start typing zoho.crm.getRecords. I'll get an array back of 2 records and I'll be looking for the 2...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  16. Zoho CRM & Zoho Bookings Issue: Full Name appears in Last Name (first name first name last name)https://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-zoho-bookings-full-name-appears-in-last-name.html

    A quick article to explain why the full name might appear in the last name field in Zoho CRM. Why? We had a customer report the issue that sometimes the full name of a contact was appearing in the last name field and creating a contact called "Firstname...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  17. Zoho CRM: Standard Setup for Tax Rateshttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-standard-tax-rate-setup.html

    you click on the edit icon in the line item "Tax" you will see both options available to be ticked, the same popup will appear if you click on the edit icon in the header "Tax" (applies to subtotal). Note: If you do not do the second section as per this...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  18. Zoho Creator/Deluge: UnPredictable exception, Invalid statement foundhttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-deluge-unpredictable-exception,-invalid-statement-found.html

    Execution Failed UnPredictable exception, Invalid statement found Line:(20) I cannot guarantee that this error doesn't appear for other reasons but I will add to this article if I encounter any. This is simply how I fixed this error on this occasion....

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  19. ZohoCRM: ZDK Client Script to retrieve Contact Emailhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-zdk-client-script-to-retrieve-contact-email.html

    other event you can use this in inline editing mode in is the Canvas mode. Error(s) Encountered Contacts doesn't seem to appear in Client Script IDE. Didn't for me but then it isn't too hard to guess what the module name is.

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  20. Zoho Books/Inventory: Trigger a workflow when an invoice has been paidhttps://www.joellipman.com/articles/crm/zoho/zoho-books/zoho-books-inventory-trigger-a-workflow-when-an-invoice-has-been-paid.html

    needed to know what card they had paid with (if paid by card). The customer wanted payment method and payment date to appear on the invoice. How? This sounds rather straightforward, write a function that given an invoice, checks the customer payments...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
Results 1 - 20 of 47