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 during is required, the following 25 results were found.

  1. Error during processing - Converting Date/Timehttps://www.joellipman.com/articles/else/database/t-sql/error-during-processing-converting-datetime.html

    The features and interface are very similar when developing reports though. The error I'd get was An error occurred during local report processing. An error has occurred during report processing. Cannot read the next data row for the dataset DataSet1....

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: *
  2. SSRS Report Builder 2.0 - Error during processinghttps://www.joellipman.com/component/content/article/ssrs-report-builder-20-error-during-processing.html?catid=75&Itemid=165

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

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  3. Joel's Reference to MidJourney v4 Promptshttps://www.joellipman.com/component/content/article/joel-s-guide-to-midjourney-prompts.html?catid=115&Itemid=165

    Back Odalisque Pose S-Shape Pose Sitting With their Back to the camera Period / Age in the year «Year» 60s 90s Autumn during the Dark Ages at Dawn at Dusk in the Evening Futuristic during Golden Hour Historical during the Middle Ages at Midday at...

    • Type: Article
    • Author: Joel Lipman
    • Category: Graphic Design
    • Language: *
  4. SSIS Script: convert UPPERCASE to Mixed-Case using TitleCasehttps://www.joellipman.com/component/content/article/ssis-script-convert-uppercase-to-mixed-case-using-titlecase.html?catid=74&Itemid=165

    DebugLogEventDescription, DTSLogEntryFrequency.DTSLEF_PROPORTIONAL); } // This method is called during Design Time when the component is added to the data flow public override DTSValidationStatus Validate() { bool pbCancel = false; IDTSInput100 input =...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  5. Zoho Deluge - Multi-line Variable Assignments and Expressionshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-multi-line-statements-using-semi-colon-termination.html

    // yields "d" This approach works well for reference lists, configuration values, or ordered datasets where readability during development is helpful. 3) Method chaining across multiple lines Method chaining can be split across lines to make...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  6. Returned a data type that is not validhttps://www.joellipman.com/articles/else/database/t-sql/returned-a-data-type-that-is-not-valid.html

    a general data type error and not just because I tried to convert a date in SQL format to a Month name. An error occurred during local report processing. An error has occurred during report processing. The Group expression used in grouping...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: *
  7. Accessing a MySQL Database with Business Intelligence Development Studiohttps://www.joellipman.com/articles/else/database/mysql/accessing-a-mysql-database-with-business-intelligence-development-studio.html

    If you get the following error (like I did) when you view the deployed report on the Reporting Server: An error occurred during client rendering. An error has occurred during report processing. Cannot impersonate user for data source 'BUKB_Test'. For...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  8. COVID-19: Working from Homehttps://www.joellipman.com/component/content/article/covid-19-work-from-home.html?catid=45&Itemid=165

    So it's pretty important not to be slouching over the coffee table for hours or days on end. I was waiting to move house during 2020 but then a virus capable of locking down the world manifested itself. I thought this would be temporary but after 4...

    • Type: Article
    • Author: Joel Lipman
    • Category: Articles
    • Language: *
  9. Write a Calendar in Autohotkeyhttps://www.joellipman.com/component/content/article/write-a-calendar-in-autohotkey.html?catid=48&Itemid=165

    autohotkey syntax. Actually, the following code is an excerpt from my program which checks an online server (for IT Events during this month) and if it can't download the calendar, it had to display an offline version in the GUI. To display the...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: en-GB
  10. AHK Countdown Tooltiphttps://www.joellipman.com/component/content/article/ahk-countdown-tooltip.html?catid=48&Itemid=165

    ThisVersion:="0.3 Beta" ; My leaving date FinalDate := "2014" "08" "29" "13" "00" "00" ; Background image to change to during the running of this program DesktopBackgroundImage1:="\\bournemouth.ac.uk\data\Staff\Home\jlipman\My...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: *
  11. Client Services: Website Development Agreementhttps://www.joellipman.com/component/content/article/client-services-website-development-agreement.html?catid=50&Itemid=165

    upgrade or replacement of an existing system). Warranty checks will be run for 1 month (unless agreed otherwise). Support during this month is included in the initial development. Service Transition will happen over the course of 1 month where the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Static Items
    • Language: *
  12. Zoho Creator: Expecting ZC_SUBFORM_250 expression found COLLECTIONhttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-expecting-zc-subform-250-expression-found-collection.html

    A very quick article as I couldn't find anything on the WWW to document this error. Why? During a data migration, I was using a custom function to copy all the data from one app to another. The specific form was for "Leads" which contained a subform...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  13. Zoho Creator: Sendmail a list of attachmentshttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-send-mail-a-list-of-attachments.html

    very quick article on sending an email with Deluge which needs a dynamic number of files attached to it. Why? This came up during a call with another developer and it occurred to me that perhaps this isn't clearly documented. But there are tips found...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  14. Zoho Webhooks & Shopify API: Keep Disappearinghttps://www.joellipman.com/articles/else/e-commerce/shopify/zoho-webhooks-shopify-api-automatically-restore.html

    find your webhooks being automatically removed by Shopify, then we put this schedule in to run as many times as possible during the day (but not enough to be banned): Login to ZohoCRM > Setup > Automation > Schedules > Create New Schedule I'm calling my...

    • Type: Article
    • Author: Joel Lipman
    • Category: Shopify
    • Language: *
  15. Zoho CRM: Remove Duplicate Product Recordshttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-remove-duplicate-product-records.html

    An article on removing duplicate products within ZohoCRM. Why? Product duplicates are a common issue during development, especially when we have products imported via a feed or API or simply by staff and their spreadsheets. There is a deduplication...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  16. ZohoBooks: Broken UK Banking Feedhttps://www.joellipman.com/articles/crm/zoho/zoho-books/zohobooks-broken-uk-banking-feed.html

    Always confirm with Zoho before deletion to ensure historical manual imports are preserved. Manual import workaround: During any downtime, you can manually upload transactions using CSV import and reconcile as usual. Once the feed is reconnected, Zoho...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  17. Installing phpBB3 for Joomla with a RocketTheme templatehttps://www.joellipman.com/articles/cms/joomla/installing-phpbb3-for-joomla-with-a-rockettheme-template.html

    Linux (Apache), all file names and folder names are case-sensitive, so phpbb3 is NOT the same as phpBB3. Bear this in mind during the installation process. Before we begin: I have to admit this took me a while. I had never used phpBB3 before nor were...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  18. Joomla Component: Set default params on installationhttps://www.joellipman.com/articles/cms/joomla/joomla-component-set-default-params-on-installation.html

    . ' = ' . $db->quote('com_XXX')); $db->setQuery($query); $db->query(); } } } Additional: ACL during install My component is editable by registered users only. This meant that everytime someone installs the component, they would usually need to go into...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  19. Windows 10: Shortcut Apps to Settingshttps://www.joellipman.com/component/content/article/windows-10-shortcut-apps-to-settings.html?catid=80&Itemid=165

    Display (Orientation) ms-settings:screenrotation Duplicating my display ms-settings:quietmomentspresentation During these hours ms-settings:quietmomentsscheduled Encryption ms-settings:deviceencryption Focus assist ms-settings:quiethours...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  20. Project Plan for Freelance Websitehttps://www.joellipman.com/articles/cms/website-development/project-plan-for-freelance-website.html

    time is spent faffing around with design and functionality. We use the ProjectFork extension to manage projects, it helps during times when we can't see face-to-face with colleagues or clients. Startup Meeting For you to discuss: Aims / Objectives...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
Results 1 - 20 of 25