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

  1. Google Drive API v3 - OAuth2 using Service Account in PHP/JWThttps://www.joellipman.com/component/content/article/google-drive-oauth-using-service-account-in-php.html?catid=61&Itemid=165

    can do it in pure PHP and all you need is the JSON key that you generated in your Google console. Applies to: Google Drive REST API v3 Google OAuth 2.0 v4 Google Cloud Platform IAM Google Suite PHP v5.6.35 How? I'm going to go through each section of...

    • Type: Article
    • Author: Joel Lipman
    • Category: Google
    • Language: en-GB
  2. Report Builder 2.0 - Hide Series1https://www.joellipman.com/component/content/article/report-builder-20-hide-series1.html?catid=75&Itemid=165

    members could have changed and that a person doing most of the jobs suddenly left or moved to another team. To exclude the rest and only show "Series1" Took me a while to figure this out but modify the above statement along the lines of SELECT...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  3. Alternate row background colour in Reporting Serviceshttps://www.joellipman.com/component/content/article/alternate-row-background-colour-in-reporting-services.html?catid=75&Itemid=165

    row being of all rows in the dataset and not for a particular drill-down item. It will alternate between the two for the rest of the report. [The second example is what I use most frequently]. Additional: Suppose you have lots of columns, you don't want...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: *
  4. How to Display Report Execution Time in SSRS (milliseconds)https://www.joellipman.com/component/content/article/how-to-display-report-execution-time-in-ssrs.html?catid=75&Itemid=165

    to get the timestamp of when the queries started. IIF your result row count, if it's zero, just display blank, else, do the rest of the query. Blank out the textbox basically (execution time is kinda irrelevant when you get 0 matches) We went with...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  5. SSRS Stop Scrolling Behindhttps://www.joellipman.com/component/content/article/ssrs-stop-scrolling-behind.html?catid=75&Itemid=165

    exists (contains page number) because if printed, the page would end on a dataset row and continue the next page with the rest of the dataset. This footer allows for a large space at the bottom of the page indicating the page number. The footer of the...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  6. How to change local folder for TFShttps://www.joellipman.com/component/content/article/how-to-change-local-folder-for-tfs.html?catid=79&Itemid=165

    connected it to a Team Foundation Server 2010 (TFS) instance and set my working local folder to my home directory. When the rest of my colleagues installed it however, they decided to use a common local directory for all workstations so configuration...

    • Type: Article
    • Author: Joel Lipman
    • Category: Team Foundation Server
    • Language: *
  7. Merge the content of two similar tables in MySQLhttps://www.joellipman.com/articles/else/database/mysql/merge-the-content-of-two-similar-tables-in-mysql.html

    of two tables with a CROSS JOIN, (BTW these are not instructions to create some table I'll never use again unlike the rest of the solutions I found on the web). In MySQL, I only know how to do this with a UNION ALL clause. Scenario: I have a Joomla...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  8. Project Plan for Freelance Websitehttps://www.joellipman.com/articles/cms/website-development/project-plan-for-freelance-website.html

    of what I picture as a perfect project; unfortunately the first 2 pages tend to be completed in just over a day and the rest of the time is spent faffing around with design and functionality. We use the ProjectFork extension to manage projects, it helps...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
  9. What's the problem? Amusing computer issueshttps://www.joellipman.com/articles/cms/website-development/whats-the-problem-amusing-computer-reports.html

    If you're not an IT person, you may want to avoid reading the rest of this article in case you're easily offended. It's just an amusing stab at customers computer issues. Note that most of the below were remote support jobs so we weren't there in...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
  10. 301 Redirect using htaccess filehttps://www.joellipman.com/articles/cms/website-development/301-redirect-using-htaccess-file.html

    # http://www.myolddomain.com/anything -> # -> http://www.mynewdomain.com Redirect domain but keep the rest of the URL: RewriteEngine on RewriteRule ^(.*)$ http://www.newdomain.com/$1 [R=301,L] # Redirects users from: # http://www.myolddomain.com -> # ->...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
  11. Advanced RokStories Stylinghttps://www.joellipman.com/articles/cms/joomla/advanced-rokstories-styling.html

    adapts depending on your image size, so no need to manually create rounded corners on your images, RokStories will do the rest. The custom features are also available in the standalone version. Lorem ipsum dolor sit amet, consectetur adipiscing elit....

    • Type: Article
    • Author: Webmaster
    • Category: Joomla
    • Language: *
  12. UNC Paths in Sharepoint 2007 linkshttps://www.joellipman.com/component/content/article/unc-paths-in-sharepoint-2007-links.html?catid=77&Itemid=165

    but I'm just trying to add a link to our Sharepoint 2007 portal. How? Add a link with the prefix File:// and complete the rest of the path as per usual. Sharepoint will correct the link when you OK it if you are trying to enter a real UNC path:...

    • Type: Article
    • Author: Joel Lipman
    • Category: SharePoint
    • Language: *
Results 41 - 52 of 52