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

  1. Sort order a dropdown list in MS InfoPath without programminghttps://www.joellipman.com/component/content/article/sort-order-a-dropdown-list-in-ms-infopath-without-programming.html?catid=73&Itemid=165

    Datasheet View (you could probably use a "Standard View", I just used the Datasheet one) Give the view a name, select what columns you want the form to have (I included the IDs for functional purposes) Further down the "Create View" page, there should...

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

  2. SSIS Skip Rows in Excel Source filehttps://www.joellipman.com/component/content/article/ssis-skip-rows-in-excel-source-file.html?catid=74&Itemid=165

    How? My example is that I have an excel sheet where the first 10 rows are descriptions to the column, and then I have 38 columns ("A" to "AL"): In the data flow, click on the Excel datasource component so that it's selected. View the Properties panel...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration 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

    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 to have to click on each cell to specify this so just do it to the first column then bring up the properties...

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

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

    a Matrix rather than a Tablix: Insert a "Matrix" into the body of your report. Drag "ReportName" into the field that says "Columns". Right-click on the grey left margin and select "Insert Row" then "Outside Group - Below". Delete the row with the left...

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

  5. Returning Oracle Stored Procedure Resultset in SSRShttps://www.joellipman.com/component/content/article/returning-oracle-stored-procedure-resultset-in-ssrs.html?catid=75&Itemid=165

    TO my_ssrs_user; Notes: No "SELECT... INTO..." on the second query which is the one that will return my columns. Two output fields are expected to be returned: "p_STUDENT_DETAILS" and "p_STUDENT_REF". 2. Add a datasource Nothing different to your...

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

  6. SQL Queries for Statisticshttps://www.joellipman.com/articles/else/database/mysql/sql-queries-for-statistics.html

    logged in) and of course the Timestamp (DateTimeStamp). Here is a page of some MySQL queries I can do based on just those 5 columns: MediaWiki: number of unique guests, students and staff by month. Also associates a UserID to the wikimedia_user table to...

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

  7. Generate a Timesheet in MySQL https://www.joellipman.com/articles/else/database/mysql/generate-a-timesheet-in-mysql.html

    -- 2013-12-05 Thursday -- 2013-12-06 Friday -- 2013-12-07 Saturday -- 2013-12-08 Sunday Brilliant! We have the first two columns of what we want to do. Now we need the same again but this time we want the morning slots SELECT DATE( DATE_ADD( NOW( ) ,...

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

  8. Joes Quicklist Weblinks (JQW) Downloadshttps://www.joellipman.com/component/content/article/joes-quicklist-weblinks-jqw-downloads.html?catid=105&Itemid=165

    text to Joomla language file (translatable) - Date Uploaded: Sun, 10th Mar 2013 2.1.1 - Corrected alias reference to all columns irrespective of order settings. - Link for text only links title and not description. - Restored module parameter: Display...

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

  9. MS Excel - Sort pivottable column headings by datehttps://www.joellipman.com/component/content/article/sort-pivottable-column-headings-by-date.html?catid=110&Itemid=165

    "08" so maybe I'm barking up the wrong tree. If I padded with one more zero so that "008" is before "010": Great! The columns are displayed in the correct order but who's ever seen a date written as the 008th of April? What if we didn't use parentheses?...

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

  10. SSRS Repeat Headers in PDF Reporthttps://www.joellipman.com/component/content/article/ssrs-repeat-headers-in-pdf-report.html?catid=75&Itemid=165

    include the tablix header... obviously). I right-clicked on the header row of the tablix and checked the box "Repeat header columns on each page. Situation I have a report which has been set to landscape with zero margins specified. Although BIDS...

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

  11. Trim values along with the tabhttps://www.joellipman.com/articles/else/database/mysql/trim-values-along-with-the-tab.html

    data and then converting to MySQL commands. Unfortunately, the MS Excel software adds tab characters to delimit the columns... How? UPDATE `mytable` SET `myColumn` = TRIM(CHAR(9) FROM TRIM(`myColumn`)); Source: Stack Overflow - How to Remove Tabs

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

  12. MS Excel - Open CSV with Long Numbershttps://www.joellipman.com/component/content/article/ms-excel-open-csv-with-long-numbers.html?catid=110&Itemid=165

    to do with each column: 1. Specify that the data is delimited 2. Specify the data is delimited by commas 3. Specify which columns should be imported as text (the long numbers and phone numbers)

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
Results 41 - 52 of 52