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

  1. Returned a data type that is not validhttps://www.joellipman.com/articles/else/database/t-sql/returned-a-data-type-that-is-not-valid.html

    AS Month Solved by changing SQL statement to t1.Date AS Month This will return the SQL date but using your report builder or business intelligence development studio, you can specify in the report designer how to format the returned value to a more...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: *
  2. SQL Calendar in Business Intelligence Development Studiohttps://www.joellipman.com/articles/else/database/t-sql/sql-calendar-in-business-intelligence-development-studio.html

    if you bear with me as I add captions to the below screenshots: Design the Query: So copy the above text, click on query builder and "edit as text", then paste it into there. When you ok this you should be on the following screen: Select the Report...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
  3. 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 Solution Explorer > select "Add New Report" Select the "Shared Data Source" you just created > Next Click on the "Query Builder" button Right-click on any empty space in the first frame > Select "Add Table..." Add and specify the query as you would...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  4. Display Feeds to major Social Networkshttps://www.joellipman.com/articles/cms/website-development/display-feeds-to-major-social-networks.html

    that appears, Copy & Paste the code into your blog or website HTML. Pinterest Browse to Pinterest Developer Tools - Widget Builder Include the javascript file '//assets.pinterest.com/js/pinit.js' once in the page Customize your feed and Copy & Paste the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
  5. Disable User Registration in Joomla 1.5 - Configuration Filehttps://www.joellipman.com/articles/cms/joomla/disable-user-registration-in-joomla-1-5-configuration-file.html

    to enable it. Not Working? Are you sure you are using the Joomla user component or a 3rd-party such as Community Builder or K2? If so, you're in trouble as you HAVE to use the joomla admin panel to edit the settings of the 3rd party components.

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  6. Change Regional Settings for your Reporthttps://www.joellipman.com/component/content/article/change-regional-settings-for-your-report.html?catid=75&Itemid=165

    Basically I thought that the regional settings of a report generated using Report Builder 2.0 on a MS SQL Server 2008 instance were dependent on either the server or the client machine. Realised that this was actually specified in the report. Here's a...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  7. SSRS Expand specific drilldown by defaulthttps://www.joellipman.com/component/content/article/ssrs-expand-specific-drilldown-by-default.html?catid=75&Itemid=165

    is how to do it in SQL Server 2008 and creating a report in Business Intelligence Development Studio (BIDS) or MS Report Builder. Scenario I have a report that specifies some room bookings for a particular week. When I open the report, each drilldown...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  8. SSRS Border Problemhttps://www.joellipman.com/component/content/article/ssrs-border-problem.html?catid=75&Itemid=165

    to select a cell to have an outline border but then cells around it without a border. You may find that BIDS or Report Builder (however you're building your report) will apply the border to some cells and sometimes a whole section of the report with...

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