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

  1. Problem creating SSRS report subscriptionshttps://www.joellipman.com/component/content/article/problem-creating-ssrs-report-subscriptions.html?catid=75&Itemid=165

    DataSource In the folder where you put your Data Sources, click on the button "New Data Source" Specify the details, especially the connection string (which the system account can use). Set "Connect Using" to "Credentials supplied by the user running...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  2. SSRS: Performance Improvements: SELECT TOPhttps://www.joellipman.com/component/content/article/ssrs-performance-improvements-select-top.html?catid=75&Itemid=165

    This article details a method we used on a search form in a SQL Server Reporting Services (SSRS) environment. The requirement (amongst others) was that the report ran in less than a few seconds. Analyzing the report through the ReportServer databases...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  3. Search a database with SOUNDEXhttps://www.joellipman.com/articles/else/database/search-a-database-with-soundex.html

    your search result twice, this may be why. Performance Average - Run against a database of circa 30'000 students and their details (incl. courses ~ 700'000 records) took just under 2 minutes (found over 7 million occurrences similar to "DNYA").

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: en-GB
  4. Database Error: Unable to connect to the database: Could not connect to MySQLhttps://www.joellipman.com/articles/else/database/mysql/database-error-unable-to-connect-to-the-database-could-not-connect-to-mysql.html

    into this for a friend and going through forums to investigate this error. After you've checked your database connection details, I find what FisherC said below is the most probable cause for the error. FisherC says: I have the same problem, but I'm not...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  5. 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

    the dataset) Select the Report Type (for just a table with a heading row at the top, select "Tabular") > Next Click on "Details" until everything is added. > Next I'm boring and old-school so my table style will be "Generic". > Next FINISH That's all...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  6. Access MySQL databases using Oracle SQL Developerhttps://www.joellipman.com/articles/else/database/mysql/access-mysql-databases-using-oracle-sql-developer.html

    a new database connection (or click on the plus sign in the connections tab), select the mySQL tab and complete the login details and host location... Done! Additional I wouldn't recommend using Oracle SQL Developer. You have to use mostly SQL to create...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  7. Sort an associative array by values in Javascripthttps://www.joellipman.com/articles/cms/website-development/js/sort-an-associative-array-by-values-in-javascript.html

    What? An article on how to quickly adapt an array code and sort by its values. Surprising how many examples are on the web and everyone saying you're doing it wrong... Which is true but quite unhelpful. The original code is not my own either but that's...

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

    for pagination and auto-scroll - Date Uploaded: Sat, 3rd Sep 2011 2.0.5 beta - Parameters: Grid Mode - sortable, column details, headings, text width. - Date Uploaded: Sat, 3rd Sep 2011 2.0.4 beta - Parameter: Slideshow Mode (by Ryan Florence v2.1) or...

    • Type: Article
    • Author: Joel Lipman
    • Category: Downloads
    • Language: *
  9. Stop Excel Row Height Self-Adjust on Refreshhttps://www.joellipman.com/component/content/article/stop-excel-row-height-self-adjust-on-refresh.html?catid=110&Itemid=165

    means that anyone with access to the Excel spreadsheet can go and view the connections and see the username/password details (granted read-only access). One of the requirements was that only authorised personnel could refresh the data on the Excel...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  10. Passwords: Did-you-knowhttps://www.joellipman.com/component/content/article/passwords-did-you-know.html?catid=116&Itemid=165

    USB flash drives in the parking lot. Employees pick them up and plug them into their machines at work which then sends the details over the internet. Apparently this has a 9 in 10 chance of working. Possibly the most notable in 2008 being the US...

    • Type: Article
    • Author: Joel Lipman
    • Category: IT Support
    • Language: *
  11. Zoho Inventory Template Issue: First Page is Blankhttps://www.joellipman.com/articles/crm/zoho/zoho-inventory/zoho-inventory-template-issue-first-page-is-blank.html

    So I thought I'd write an article to help me resolve the particular issue where the organization details and the header of the product line items table would display on the first page, the product line items would then print on the second page, with the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Inventory
    • Language: *
  12. Zoho CRM: Make Upload File Field Mandatoryhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-make-upload-file-field-mandatory.html

    Client Script. So we're going to check on page onload, onchange for the Create Page (Standard), Edit Page (Standard), and Details Page (Standard). My use-case has a requirement that another dropdown called "Order Type" has to be set to "Supplier". My...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  13. $_SERVER['http_referer'] returns blank in Internet Explorerhttps://www.joellipman.com/component/content/article/serverhttpreferer-returns-blank-in-internet-explorer.html?catid=62&Itemid=165

    as it will only work in every other browser except Internet Explorer (more specifically versions 6 and 7...???) For more details: http://www.webmaster-talk.com/php-forum/19149-_server-http_referer-fails-under-internet-explorer.html

    • Type: Article
    • Author: Joel Lipman
    • Category: Microsoft
    • Language: en-GB
  14. MediaWiki: MySQL to extract path to imageshttps://www.joellipman.com/articles/cms/mediawiki/mediawiki-mysql-to-extract-path-to-images.html

    In not as many words as others, here's my MySQL query to extract details on images stored in the MediaWiki CMS system (v1.14). Why? Prior to a migration and just after another change freeze, I had sent all Wiki articles modified since the last export...

    • Type: Article
    • Author: Joel Lipman
    • Category: MediaWiki
    • Language: en-GB
  15. SSRS Repeat Headers in PDF Reporthttps://www.joellipman.com/component/content/article/ssrs-repeat-headers-in-pdf-report.html?catid=75&Itemid=165

    panel (see below screenshot). Click on the "static" row that is the header of the tablix (the data of the tablix is "details"). Set "FixedData" to "True" if you want the headers to scroll with the report when viewed on the Reporting Server or within...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  16. Reminder on SSRS row separatorhttps://www.joellipman.com/component/content/article/reminder-on-ssrs-row-seperator.html?catid=75&Itemid=165

    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 between each day in the list, so I have: Monday 03/10/2011 Main Office...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  17. SSRS Subscriptions cannot be createdhttps://www.joellipman.com/component/content/article/ssrs-subscriptions-cannot-be-created.html?catid=75&Itemid=165

    don't display. The answer to this error is your report needs to use a datasource with the credentials stored, here are the details to our report As developers, we connect to the datasource directly using our Windows Credentials. For the SSRS server...

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