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

02 December 2011 I've recently written a report for SQL Server Reporting Services 2008 R2 (SSRS) which will compare up to 4 reports and will compare the time taken for each one. The breakdown or what I was able to measure with the default installation are the times...

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

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

11 November 2013 A quick article on if you are trying to create a new subscription to a SQL Server Reporting Server (SSRS) report and you are getting a warning message similar to the following: Message from webpage Subscriptions cannot be created because the credentials...

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

SSRS Stop Scrolling Behindhttps://www.joellipman.com/component/content/article/ssrs-stop-scrolling-behind.html?catid=75&Itemid=165

08 April 2014 to: Microsoft SQL Server Reporting Services (SSRS) 2008 R2 Microsoft Visual Studio 2012 Microsoft Business Intelligence Development Studio What? I recently revamped our standard report with a new template comprising of a single Tablix which contained...

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

Change Regional Settings for your Reporthttps://www.joellipman.com/component/content/article/change-regional-settings-for-your-report.html?catid=75&Itemid=165

17 May 2010 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

T-SQL example of Case-Sensitive Soundexhttps://www.joellipman.com/articles/else/database/t-sql/t-sql-example-of-case-sensitive-soundex.html

10 October 2012 What? This article is for demonstrating how to use a SOUNDEX in a select and then listing all the variations based on case-sensitivity. Why? We have a database with data in it. For a particular column we have setup default values, let's use the example...

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

SSRS Zero Paddinghttps://www.joellipman.com/component/content/article/ssrs-zero-padding.html?catid=75&Itemid=165

10 November 2011 zero padding would need to be applicable within an MDX query. The Situation We have a database using Oracle 10g, and a SQL Server Reporting Services v2008 R2 environment. My use for this was when displaying an audit log displaying the oracle errors....

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

CharIndex Reverse - find occurrence starting from end of string in TSQLhttps://www.joellipman.com/articles/else/database/t-sql/charindex-reverse-find-occurrence-starting-from-end-of-string-in-tsql.html

28 January 2013 This is a quick note on finding the last occurrence of a string in a longer string. This has to be in Transact SQL for a SQL Server instance only and not filtered by other code. Why? I have a string such as the following (column positions added for demo...

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

Stop Excel Row Height Self-Adjust on Refreshhttps://www.joellipman.com/component/content/article/stop-excel-row-height-self-adjust-on-refresh.html?catid=110&Itemid=165

30 September 2011 Situation I have a Microsoft Excel 2007 file that connects to a SQL Server 2008 R2 database. The Excel file pulls data using lookup tables and displays the data in an Excel Spreadsheet. The Problem We can select all cells and set row height to be 30 for...

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

Zoho Deluge: Date from a String (dd/MM/yyyy to yyyy-MM-dd)https://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-date-from-a-string-dd-mm-yyyy-to-yyyy-mm-dd.html

01 September 2021 What? A quick article to remind me of the regex to change a date from the format dd/MM/yyyy to yyyy-MM-dd. Why? Irrespective of server, organization or user settings, the date handling can vary. If we are getting a date from a CSV or other external...

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

Setup a copy of your Joomla websitehttps://www.joellipman.com/articles/cms/joomla/setup-a-copy-of-your-joomla-website.html

19 December 2012 What? More for others than for myself, but this article is for those who do not have development/test environments of their Joomla website. I have been doing this for years and still come across clients who have the one version of their website. They...

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

SSRS Hide results table if emptyhttps://www.joellipman.com/component/content/article/ssrs-hide-results-table-if-empty.html?catid=75&Itemid=165

29 March 2011 is the data value reliable if it's blank? The long way of doing this I would have called this article "Iteration within SQL Server Reporting Services Business Intelligence Development Studio (BIDS) version 2008 through combining Transact-SQL and MDX...

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

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

04 November 2011 We have a report in SQL Server Reporting Services 2008 R2 (SSRS) reading from an Oracle 10g database which works great and lists all the details on a specific student. An additional request is that there appears a link that will run a stored procedure...

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

SSRS Dropdown parameter cannot be blank!https://www.joellipman.com/component/content/article/ssrs-dropdown-to-allow-blank-values.html?catid=75&Itemid=165

14 December 2011 What? I have created an SSRS report which can compare 4 reports side by side and brings up their latest execution times to the nearest millisecond. The report has 4 parameters. Each parameter is a dropdown populated by a list of all available reports....

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

The ReportServer Databasehttps://www.joellipman.com/articles/else/database/the-reportserver-database.html

08 August 2011 Amazing, I have just spent all morning on Microsoft websites to determine what number is the TimeDataRetrieval column displaying. Thank you I know it's an INT. There is just a serious lack of documentation as to what this database is and how it...

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

Error during processing - Converting Date/Timehttps://www.joellipman.com/articles/else/database/t-sql/error-during-processing-converting-datetime.html

13 July 2010 Builder 2.0 which I've stopped using as my day job wants us to use Business Intelligence Development Studio for all our SQL Server Analysis Service (SSAS) and Reporting Service (SSRS) projects/solutions. The features and interface are very similar when...

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

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

26 October 2012 value was found in. ** ** - myCount: the number of times this value was found in this column. ** ** ** ** Link to other SQL Server collations: http://msdn.microsoft.com/en-us/library/ms180175.aspx ** ** **...

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

DataScramble - Randomizing data rowshttps://www.joellipman.com/articles/else/database/t-sql/datascramble-randomizing-data-rows.html

07 December 2012 1964-08-08 How? Precursor You will need to be able to create the following view to generate random numbers on SQL Server. -- Drop the view if it already exists IF OBJECT_ID ('vwRandom', 'V') IS NOT NULL DROP VIEW vwRandom ; GO -- Used to reference RAND...

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

No rows returned in Oracle causes SP to failhttps://www.joellipman.com/articles/else/database/oracle-pl-sql/no-rows-returned-in-oracle-causes-sp-to-fail.html

24 January 2012 happens when using these as a subquery which has an empty result set. Furthermore I am using this stored procedure in a SQL Server Reporting Services (SSRS) environment and don't want to return any rows if there are no matches (not a blank row either)...

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

Generate Academic Calendar using MySQLhttps://www.joellipman.com/articles/else/database/mysql/generate-academic-calendar-using-mysql.html

27 November 2012 3-Jul-2013 4-Jul-2013 5-Jul-2015 27 52 8-Jul-2013 9-Jul-2013 10-Jul-2013 11-Jul-2013 12-Jul-2015 28 This query in T-SQL (SQL Server 2008 R2) for CMIS Facility SELECT calendar.WeekNumber AS AcademicWeek, CAST(DATEPART(dd, calendar.StartDate) AS...

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

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

05 April 2011 CDate(cstr(month(today.now())+1) + "/1/" + cstr(year(today.now()))) ) This idea was based on Bob Griffin's post on SQL Server Central.com forums where he subtracts 1 day from the first day of next month to get the last date/number of days in this month.

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