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

  1. Excel PivotTable Filter List Orderinghttps://joellipman.com/component/content/article/excel-pivottable-filter-list-ordering.html?catid=110&Itemid=165

    I googled this for a while and there are a lot of solutions out there, none of which applied to what we meant and lots of people in the same boat. The Situation We have an Excel report which summarizes for our guys at the top, all the activities and...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB

  2. MS Excel: Convert a text to a numberhttps://joellipman.com/component/content/article/ms-excel-convert-a-text-to-a-number.html?catid=110&Itemid=165

    could argue this is a problem with your data but the way I see it is it's a space character and TRIM() should work. My solution Include the space (if there is one) in the substitute formula: =SUBSTITUTE(B3, " ₱", "") The resulting value will still need...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB

  3. MS Excel - Split Workbook into separate files per sheethttps://joellipman.com/component/content/article/ms-excel-split-workbook-into-separate-files-per-sheet.html?catid=110&Itemid=165

    End Sub Press F5 to run the code. A separate file will be created for each sheet in the same folder. A combined all-in-one solution The following script is made of 4/5 subroutines. Follow the instructions above on how to execute a vbscript and then...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB

  4. Make bootstrap carousel responsive to swipehttps://joellipman.com/articles/cms/website-development/bootstrap/make-bootstrap-carousel-responsive-to-swipe.html

    will suggest to load the jQueryMobile library but that started messing up the template layouts for me. I really like the solution (and think it should be voted best answer) put forward by Mark Shiraldi: The code is minimal but does what it needs to do...

    • Type: Article
    • Author: Joel Lipman
    • Category: Bootstrap
    • Language: *

  5. Zoho Books: Attach a document to a bill using Deluge / REST APIhttps://joellipman.com/articles/crm/zoho/zoho-books/zoho-books-attach-a-document-to-a-bill-using-deluge-rest-api.html

    it here so I can refer to how you attach a document to a record in Zoho Books. The bigger part of this component is in a solution which replaces the autoscan feature in Zoho Books for received documents (Supplier/Vendor Invoices received to trigger the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *

  6. Joomla banners not rotatinghttps://joellipman.com/articles/cms/joomla/joomla-banners-not-rotating.html

    The issue here is that you have added all your banners, divided between clients and categories and you're looking for a solution which doesn't involve installing a 3rd party applicatoin. Unfortunately the Joomla banner module only supports alternating...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB

  7. $_SERVER['http_referer'] returns blank in Internet Explorerhttps://joellipman.com/component/content/article/serverhttpreferer-returns-blank-in-internet-explorer.html?catid=62&Itemid=165

    environment variable can be changed by the user anyway but I was using it as an additional validation check. The only solution is to not use it for verification purposes as it will only work in every other browser except Internet Explorer (more...

    • Type: Article
    • Author: Joel Lipman
    • Category: Microsoft
    • Language: en-GB

  8. How to run a .RUN filehttps://joellipman.com/component/content/article/how-to-run-a-run-file.html?catid=63&Itemid=165

    on the file you downloaded Select 'Properties' Select the 'Permissions' tab Tick the 'Execute' checkbox Conclusion The solution using the terminal worked for me but the second one using Gnome didn't.

    • Type: Article
    • Author: Joel Lipman
    • Category: Linux
    • Language: *

  9. Android Background Image Resolutionshttps://joellipman.com/articles/else/app-dev/android-os/android-background-image-resolutions.html

    1600x2133 (364kb) and was not displaying on smaller devices. Configuring drawables for each layout seemed to be the only solution. res/drawable-ldpi 240x320 res/drawable-mdpi 320x480 res/drawable-hdpi 480x800 res/drawable-xhdpi 640x960...

    • Type: Article
    • Author: Joel Lipman
    • Category: AndroidOS
    • Language: *

  10. SSRS - Lost window with datasetshttps://joellipman.com/component/content/article/ssrs-lost-window-with-datasets.html?catid=75&Itemid=165

    parameters and datasets isn't there. I spent a bit of time enabling/disabling toolbars before I found this. Open a Report solution (or have one open already?) The menu link is "report data" and it's right at the bottom of the "View" menu.

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

  11. Set default parameter dates to start and end of monthhttps://joellipman.com/component/content/article/set-default-parameter-dates-to-start-and-end-of-month.html?catid=75&Itemid=165

    one day. If the second parameter (ToDate) is the same as the first (FromDate), then the range is for that particular date. Solution Easy for some but anything that I spend 30 minutes googling and reading up on is asking for an article on my own site....

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: *

  12. Reminder on SSRS row separatorhttps://joellipman.com/component/content/article/reminder-on-ssrs-row-seperator.html?catid=75&Itemid=165

    are using SQL Server Reporting Services (in my case version 2008 R2), then yes, you won't need to use the database level solution and can follow these quick steps: Right-click the grey header of the tablix row (left-most grey part) Select "Add Group"...

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

  13. SSRS Subscriptions cannot be createdhttps://joellipman.com/component/content/article/ssrs-subscriptions-cannot-be-created.html?catid=75&Itemid=165

    Microsoft Business Intelligence Development Studio 2008 (BIDS) Microsoft SQL Server 2008 R2 What? This article describes solutions to the error: Subscriptions cannot be created because the credentials used to run the report are not stored, or if a...

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

  14. SSRS No Delay for First Report of the Dayhttps://joellipman.com/component/content/article/ssrs-no-delay-for-first-report-of-the-day.html?catid=75&Itemid=165

    This article describes a solution our reporting server administrators found to cut the loading time of the first report of the day. Why? Take any SSRS report, if one of us was the first to run it on that day, it would take an additional 60 seconds to...

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

  15. Oracle: order by subquery missing right parenthesishttps://joellipman.com/articles/else/database/oracle-pl-sql/oracle-order-by-subquery-missing-right-parenthesis.html

    ) FROM Person_Staff ps -- In oracle, yields "missing parenthesis" error. So you can see my parentheses are fine. Working Solution: SELECT ps.person_id, ps.person_name, ( select txt from ( select pa.person_text as txt, pa.person_reference as personid,...

    • Type: Article
    • Author: Joel Lipman
    • Category: Oracle PL/SQL
    • Language: *

  16. Strip HTML in MySQLhttps://joellipman.com/articles/else/database/mysql/strip-html-in-mysql.html

    putting a note as I have spent ages looking for a solution and getting it to work in my environment. What? Need to be able to omit HTML tags in certain fields of a mySQL database. Why? We are preparing to migrate old content to a new system. From a...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB

  17. Ordered List of over 1000 Itemshttps://joellipman.com/articles/cms/website-development/css/ordered-list-of-over-1000-items.html

    So many people asking this when the solution is a bit of aesthetic styling. ol{margin:4px} -- yields 995. 996. 997. 998. 999. 000. 1000 Ordered list resets to zero after the ninth item Ordered List Maximum

    • Type: Article
    • Author: Joel Lipman
    • Category: Cascading Stylesheets
    • Language: *

  18. How to make a HTML form post its variables to itselfhttps://joellipman.com/articles/cms/website-development/html/how-to-make-a-html-form-post-its-variables-to-itself.html

    a PHP page which generates a HTML form. When the user submits the form, you want the same PHP page to process the data. Solution I've seen a lot of people write CGI requests but if you left the action attribute blank, this would do the same thing:...

    • Type: Article
    • Author: Joel Lipman
    • Category: Hypertext Markup Language
    • Language: en-GB

  19. Converting SQL date in PHP to European date format and vice-versahttps://joellipman.com/articles/cms/website-development/php/converting-sql-date-in-php-to-european-date-format-and-vice-versa.html

    hours, minutes and seconds). For demonstration purposes, I'm going to be using the European date format so DD/MM/YYYY. The Solution This is what I use to convert a given SQL date to the standard European format:...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB

  20. First and Last Entry on a Page using Modulus Remainderhttps://joellipman.com/articles/cms/website-development/php/first-and-last-entry-on-a-page-using-modulus-remainder.html

    out of frustration and the inability to know exactly what I'm looking for... always difficult. After a cup of tea the solution was glaringly obvious, just do a primary school mathematics table and it all makes sense (see my 10 mod table below). This...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: *
Results 121 - 140 of 140