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

  1. Performance Report - Background colors based on dataset valueshttps://www.joellipman.com/component/content/article/green-red-background-colors-based-on-dataset-values.html?catid=75&Itemid=165

    Catalog WHERE Type = 2 ORDER BY Name If you want to use these datasets, parameter options should be that the Name is the "Label" and ItemID is the "Value", just in case you didn't pick up on this. If no type is specified (type=2) then datasources and...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  2. SSRS Dropdown parameter cannot be blank!https://www.joellipman.com/component/content/article/ssrs-dropdown-to-allow-blank-values.html?catid=75&Itemid=165

    from a query" = Select the dataset of dropdown options, pay attention to the value in "Value field" (as I kept putting the label rather than the value field) to make this all work. Notes: My convert part of my SQL query is because I had to match the...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  3. Parse a HTML Table into a ListViewhttps://www.joellipman.com/articles/cms/website-development/html/parse-a-html-table-into-a-listview.html

    } LV_ModifyCol() Method #2 This method only uses two columns with the label being a concatenation of the value of the first column and the column heading. StringReplace,ReturnedHTMLTableRows,ReturnedHTMLTable,,|,A...

    • Type: Article
    • Author: Joel Lipman
    • Category: Hypertext Markup Language
    • Language: en-GB
  4. Inline Labels in Form Fields using Javascripthttps://www.joellipman.com/articles/cms/website-development/js/inline-labels-in-form-fields-using-javascript.html

    specific case the color grey. value="Name:" - give this field a default value. In this specific case, we are giving it the label value to indicate to the user to enter their Name (as in forename or surname). onFocus() - What to do when the user moves...

    • Type: Article
    • Author: Joel Lipman
    • Category: JavaScript
    • Language: en-GB
  5. Convert Past Date to Time Ago in PHPhttps://www.joellipman.com/articles/cms/website-development/php/convert-past-date-to-time-ago-in-php.html

    etc..."). function getTimeAgo($p_Date) { // get seconds ago $v_Seconds = strtotime('now') - strtotime($p_Date); // set unit labels $a_UnitLabels = array('year','month','week','day','hour','minute','second'); // set unit values $a_UnitValues = array(...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB
  6. Joes Word Cloud (JWC) Downloadhttps://www.joellipman.com/component/content/article/joes-word-cloud-jwc-downloads.html?catid=105&Itemid=165

    Bug: Correction if only one exclusion category selected - Date Uploaded: Thu, 27th Mar 2014 3.2.1 JoomlaGate - Enhancement: Label parameters in XML and language file review - Date Uploaded: Tue, 18th Mar 2014 3.2 - Fixed Bug: Redeclare function issue...

    • Type: Article
    • Author: Joel Lipman
    • Category: Downloads
    • Language: *
  7. Excel PivotTable Filter List Orderinghttps://www.joellipman.com/component/content/article/excel-pivottable-filter-list-ordering.html?catid=110&Itemid=165

    comes before February but not alphabetically, so let's do this as an example: Move the field from "Report Filter" to "Row Labels" (put it at the top as parent) Right-click on the pivotTable on one of the values of the row label you just moved Select...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  8. Import Excel CSV file as JavaScript arrayhttps://www.joellipman.com/component/content/article/import-excel-csv-file-as-javascript-array.html?catid=110&Itemid=165

    I have: A CSV file exported from Excel along with double-quotes label1,label2 item1a,item2a item1c,"item2c,c" item1b,item2b What I want: To read the file (stored on the server) and convert to a JavaScript array of objects var my_object_array = [ {...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  9. Zoho CRM: Client Script: Swap Quote Account with Deal Lookuphttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-client-script-swap-quote-account-with-deal-lookup.html

    ******************************************************************************* Function: Quotes - Map Distributor/Reseller Label: Quotes - Map Distributor/Reseller Page Details Category Module Page Create Page (Standard) Module Quotes Layout Standard...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  10. SITS: XET format for Export not availablehttps://www.joellipman.com/articles/cms/website-development/xml/sits-xet-format-for-export-not-available.html

    see what the resulting XML will look like so that my post-staging phase can be developed as it will know what the data and label fields look like. How? I had this in my training environment but not in my development environment. I had to create a Data...

    • Type: Article
    • Author: Joel Lipman
    • Category: Extensible Markup Language
    • Language: *
Results 41 - 50 of 50