Report Builder 2.0 - Hide Series1https://joellipman.com/component/content/article/report-builder-20-hide-series1.html?catid=75&Itemid=165

06 May 2010 to a current individual) in the joining tables: Return to the Design interface (F8) Right-click on your dataset (in my case: DataSet1) Select 'Dataset Properties' Add a condition to the WHERE clause Specify that the field name in the series fields is...

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

Parameters not being used in report processinghttps://joellipman.com/component/content/article/parameters-not-being-used-in-report-processing.html?catid=75&Itemid=165

07 January 2011 I even separated off the @GivenDate and @GivenCampus and re-assigned them mid-script which made no difference whatsoever. In case you've been stuck for ages (as I have), I found out you cannot declare the parameters used by the software within the SQL...

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

SSRS Querying on either of 2 Parametershttps://joellipman.com/component/content/article/ssrs-querying-on-either-of-2-parameters.html?catid=75&Itemid=165

19 July 2011 (this field can be null in the database); so that's a lot of rows, possibly all unrelated and won't work in my particular case. The solution to this issue of these solutions would be to add another AND clause where you state that the ID...

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

SSRS External Images don't displayhttps://joellipman.com/component/content/article/ssrs-external-images-dont-display.html?catid=75&Itemid=165

19 September 2011 We don't have photos for all ~20000 students at all times and these get updated/uploaded/added to about once a week. In cases where there are no photos, SSRS displays a mini ugly red cross. On the system that used to do this, we could use the HTML...

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

SSRS Retrieving Oracle Stored Procedure Success or ErrorLevelhttps://joellipman.com/component/content/article/ssrs-retrieving-oracle-stored-procedure-success-or-errorlevel.html?catid=75&Itemid=165

04 November 2011 customers. The Workaround we actually went with Our Stored Procedure would check if the unique identifying number (in our case StudentID) matches a record in the database table and that the request number was alphanumeric. In addition, this would be...

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

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

02 December 2011 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 folders will also show. The Side-by-Side...

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

Problem creating SSRS report subscriptionshttps://joellipman.com/component/content/article/problem-creating-ssrs-report-subscriptions.html?catid=75&Itemid=165

11 November 2013 because of the data source used in the report. For static data source connections, this is straightforward but in our case, we have a report which points to different servers based on a report parameter. How? There are various types of data sources used...

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

SSRS: Performance Improvements: SELECT TOPhttps://joellipman.com/component/content/article/ssrs-performance-improvements-select-top.html?catid=75&Itemid=165

07 March 2014 should be able to refine the search enough to get the records they need. Granted this may not be a viable solution for your case, but this did what we were asking and is a serious improvement to the user experience. For one thing, the accidental search...

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

Running Internet Explorer 6, 7, 8 as standaloneshttps://joellipman.com/component/content/article/running-internet-explorer-6-7-8-as-standalones.html?catid=80&Itemid=165

18 May 2010 Because their site seems to be under construction and links on the WWW are no longer valid, I've uploaded their zip just in case to my own site available for non-registered members at...

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• Language: *

Hide a Drive per User in Windows 7https://joellipman.com/component/content/article/hide-a-drive-per-user-in-windows-7.html?catid=80&Itemid=165

28 March 2014 Go to the menu File and select Load Hive Navigate to that user's profile folder, usually C:\users\username in this case Users > Guest Enter NTUSER.DAT in the File name box. (This file is a system-hidden file, so it won't show up in the file selection...

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• Language: *

Apple Magic Trackpad with Windows 11 Intelhttps://joellipman.com/component/content/article/apple-magic-trackpad-with-windows-11-intel.html?catid=80&Itemid=165

20 October 2025 is the one that worked for me. Windows Intel These are the instructions that worked for me so I'm just storing these in case I need to do it again: In Windows > Settings > Bluetooth and Devices > Add Device > Switch trackpad off/on again and wait for it...

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• Language: *

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

06 January 2011 SUM(IF(t1.VisitorBrowser='Other', 1, 0)) 'Other', COUNT(t1.VisitorBrowser) 'Total' FROM (SELECT a.DateTimeStamp Date, CASE WHEN INSTR(a.VisitorUAgent, 'MSIE ') THEN 'MSIE' WHEN INSTR(a.VisitorUAgent, 'Firefox') THEN 'Firefox' WHEN INSTR(a.VisitorUAgent,...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• Language: *

Formatting a date in an MDX queryhttps://joellipman.com/articles/else/database/t-sql/formatting-a-date-in-an-mdx-query.html

11 January 2011 over an hour before I gave up trying to get SWITCH to work. Instead I cheated and got the ordinal in the Transact-SQL query: CASE DATEPART(DAY, [MyDateValue]) WHEN 1 THEN 'st' WHEN 21 THEN 'st' WHEN 31 THEN 'st' WHEN 2 THEN 'nd' WHEN 22 THEN 'nd' WHEN 3...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• Language: *

Copy a table with structure and data into a temporary tablehttps://joellipman.com/articles/else/database/t-sql/copy-a-table-with-structure-and-data-into-a-temporary-table.html

03 August 2012 TABLE #myScrambledTable ADD ' + STUFF( ( -- Code to concatenate column names and data types into one string SELECT CASE WHEN CHARACTER_MAXIMUM_LENGTH IS NULL THEN ',' + COLUMN_NAME + ' ' + DATA_TYPE ELSE ',' + COLUMN_NAME + ' ' + DATA_TYPE + '(' +...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• Language: *

Stored Procedure to List Distinct Values and Countshttps://joellipman.com/articles/else/database/t-sql/stored-procedure-to-list-distinct-values-and-counts.html

26 October 2012 Yes you could just run a SELECT DISTINCT query along with collation to make it case-sensitive and/or accent-sensitive but using this stored procedure means I only specify the table and then the columns. How? IF...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• Language: *

Basic Oracle Function Structurehttps://joellipman.com/articles/else/database/oracle-pl-sql/basic-oracle-function-structure.html

15 January 2012 I'll complicate the function myself. How? Functions are supposed to return a single value, which is all I need in this case. In my example, I need to submit an Active Directory (AD) username and receive a student ID number instead, all with the aim to...

• Type: Article
• Author: Joel Lipman
• Category: Oracle PL/SQL
• Language: en-GB

Database Error: Unable to connect to the database: Could not connect to MySQLhttps://joellipman.com/articles/else/database/mysql/database-error-unable-to-connect-to-the-database-could-not-connect-to-mysql.html

25 September 2009 I am searching the forums for an answer and if I don't find one I'll repost. I just thought I'd share this with you in case this your problem too. Source: Joomla Forum: http://forum.joomla.org/viewtopic.php?f=433&t=198257 My Solution I have over 20...

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

Developer's Checklist: Taking over a projecthttps://joellipman.com/articles/cms/website-development/developers-checklist-taking-over-a-project.html

01 March 2011 in place?) Known Issues/Bugs (is there an "Issues Log"? Anything that still needs addressing?) System Requirements (in case you need to transfer/move to another server) Critical functions used in the system? (do this yourself anyway and use theirs as a...

• Type: Article
• Author: Joel Lipman
• Category: Web-Development
• Language: *

What's the problem? Amusing computer issueshttps://joellipman.com/articles/cms/website-development/whats-the-problem-amusing-computer-reports.html

28 April 2011 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: *

CSS Background Without Causing Scrollbarshttps://joellipman.com/articles/cms/website-development/css/css-background-without-causing-scrollbars.html

23 April 2011 note in case I spend as long as I did again. A Client had some clouds on the background of his photoshop file for his website. They were to be positioned in the top right corner with the leftmost tip aligned to the right of a central content section. I...

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