Parameters not being used in report processinghttps://www.joellipman.com/articles/microsoft/ssrs/parameters-not-being-used-in-report-processing.html

07 January 2011 Notes', c.[Name] AS 'Contact', c.[Company] AS 'Dept', c.[Phone] AS 'Phone' FROM [CMISdata].[cmisuser].[SLOTDETAILS] sd INNER JOIN [CMISdata].[cmisuser].[TIMETABLE] tt ON tt.[SlotId] = sd.[SlotId] and tt.[SetId] = sd.[SetId] INNER JOIN...

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

Migrate Joomla! 1.5.x to 2.5.x+https://www.joellipman.com/articles/cms/joomla/migrating-from-joomla-15-to-16.html

30 January 2011 @new_jos_admin_id AS created_user_id, b.date AS created_time, '*' AS `language` FROM `my_old_database`.jos_categories c INNER JOIN `my_old_database`.jos_banner b ON b.catid=c.id WHERE c.section='com_banner'; --...

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

Performance Report - Background colors based on dataset valueshttps://www.joellipman.com/articles/microsoft/ssrs/green-red-background-colors-based-on-dataset-values.html

02 December 2011 e.TimeEnd) [Total Time] ,RANK() OVER (ORDER BY e.[TimeStart] DESC) [Rank] FROM [ReportServer].[dbo].[ExecutionLogStorage] e INNER JOIN [ReportServer].[dbo].[Catalog] c ON e.ReportID = c.ItemID WHERE e.[ReportID] = @ReportParameter1 union all SELECT TOP...

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

Migrating from Joomla 2.5.x to 3.4.xhttps://www.joellipman.com/articles/cms/joomla/migrating-from-joomla-2-5-x-to-3-4-x.html

12 September 2015 ':|joe|:', c.`id`) AS new_name, a.`title`, a.`rules` FROM `v25_db`.`v25_assets` a INNER JOIN `v25_db`.`v25_content` c ON c.`asset_id`=a.`id` WHERE a.`name` LIKE 'com_content.article.%'; -- Articles INSERT INTO `v34_db`.`v34_content` ( `id`, `asset_id`,...

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

Room Availability Calendar in Business Intelligence Development Studiohttps://www.joellipman.com/articles/microsoft/ssrs/room-availability-calendar-in-business-intelligence-development-studio.html

23 March 2011 EventFinish, CONVERT(VARCHAR(2), tt.[Status]) AS Status, 'Details and other information' AS Tooltip FROM [SLOTDETAILS] sd INNER JOIN [TIMETABLE] tt ON tt.[SlotId] = sd.[SlotId] and tt.[SetId] = sd.[SetId] INNER JOIN [CONTACT] c ON c.[ContactId] =...

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

MySQL parameters in Excel 2007 PivotTableshttps://www.joellipman.com/articles/database/mysql/mysql-parameters-in-excel-2007-pivottables.html

24 August 2011 AS ActivityWeek, CASE COUNT(*) WHEN 1 THEN '(1 Event)' ELSE '(Multiple Events)' END AS DataAccuracy FROM StaffActivities s INNER JOIN Users u ON u.UserID=s.StaffUserID INNER JOIN Resources r ON r.ThisResourceID=s.CategoryID INNER JOIN Teams t ON...

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

T-SQL Record Separatorhttps://www.joellipman.com/articles/database/t-sql/t-sql-record-separator.html

11 October 2011 DATEADD(day, 6, GETDATE()), 103) AS 'WeekEnd', SD.[SetId] AS 'Set' FROM [pretendDatabase].[pretendSchema].[SLOTDETAILS] sd INNER JOIN [pretendDatabase].[pretendSchema].[TIMETABLE] tt ON tt.[SlotId] = sd.[SlotId] and tt.[SetId] = sd.[SetId] INNER JOIN...

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

Slideshow div layer through a windowhttps://www.joellipman.com/articles/web-development/mootools/slideshow-div-layer-through-a-window.html

11 September 2012 a slideshow from scratch. How? The idea is: Use two main div layers, I'm going to refer to them as "window_slide" and "inner_window". Slide divs to be added inside the "inner_window". Move the slides in from right to left with a transition. Push...

• Type: Article
• Author: Joel Lipman
• Category: MooTools Framework
• Language: *

T-SQL concatenate an incremental row numberhttps://www.joellipman.com/articles/database/t-sql/t-sql-concatenate-an-incremental-row-number.html

24 May 2013 VARCHAR), 3) AS EmployeeNo, RIGHT('000' + CAST(q.Employee AS VARCHAR), 3) + '01' AS QualificationRef FROM Qualifications q INNER JOIN Employee e ON RIGHT('000' + CAST(e.ID AS VARCHAR), 3)=q.Employee -- yields EmployeeNo QualificationRef...

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

PHP & MySQL Search Enginehttps://www.joellipman.com/articles/web-development/php/php-a-mysql-search-engine.html

09 March 2011 $start = '(^|)'; $end = '($|)'; return preg_replace( "/$start(.*?)$end/se", "StripSlashes('\\1').". "search_highlight_inner(StripSlashes('\\2'), \$terms_rx).". "StripSlashes('\\3')", $text ); } # highlight terms within search results function...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB

SSRS Hide results table if emptyhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-hide-results-table-if-empty.html

29 March 2011 the equipment information: SELECT DISTINCT re.[RoomId] ,re.[SiteId] ,re.[EquipId] ,eq.[Description] FROM [ROOMEQUIPMENT] re INNER JOIN [EQUIPMENT] eq ON eq.EquipId=re.EquipId WHERE re.RoomId=@GivenRoom AND re.SetId=@setId This seems to have problems...

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

Before and After, Highs and Lowshttps://www.joellipman.com/articles/microsoft/ssrs/before-and-after-highs-and-lows.html

03 August 2011 WeekRun, DATEPART(year, ExecutionLogStorage.TimeStart) AS YearRun, COUNT(Catalog.Name) AS Counter FROM ExecutionLogStorage INNER JOIN Catalog ON ExecutionLogStorage.ReportID = Catalog.ItemID WHERE (Catalog.Type = 2) AND (ExecutionLogStorage.TimeStart...

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

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

08 August 2011 ,a.[TimeRendering] ,a.[Source] ,a.[Status] ,a.[ByteCount] ,a.[RowCount] FROM [ReportServer].[dbo].[ExecutionLog] a INNER JOIN [ReportServer].[dbo].[Catalog] b ON a.ReportID = b.ItemID The Top 5 Most Frequent -- Top 5 Most Frequent: SELECT TOP 5...

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

T-SQL Conversion failed when converting the varchar to data type inthttps://www.joellipman.com/articles/database/t-sql/t-sql-conversion-failed-when-converting-the-varchar-to-data-type-int.html

14 May 2013 THEN 5011 WHEN emp.ContributionValue=3 THEN 5012 ELSE 9999 END FROM [dbo].[DMExtractEmployeeTable] emp INNER JOIN [dbo].[DMExtractReferenceTable] ref ON RIGHT(emp.[PayCode],3) = ref.RefMappedValue AND ref.[RefSheet] = 'myPayrollCategory' AND...

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

Joes FREE Website Thumbnailer (JWT)https://www.joellipman.com/component/content/article/joes-free-website-thumbnailer.html?catid=40

28 June 2011 thumbnail size formats. v0.2 (29/06/2011) - Resize GUI feature enabled - "Take a picture" now only takes a screenshot of the inner GUI. - Added credits: Sean (ScreenCapture.ahk) v0.1 (28/06/2011) - Added documentation and help 2.0 (auto-troubleshoot). -...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

List MediaWiki Articleshttps://www.joellipman.com/articles/cms/mediawiki/list-mediawiki-articles.html

22 September 2011 PageCategory, (SELECT GROUP_CONCAT(TRIM(REPLACE(ccg.GroupName_Friendly, '_', ' '))) FROM custombu_category_restrictions ccr INNER JOIN custombu_category_groups ccg ON ccg.BUKBGroupID=ccr.GroupAllowedID WHERE REPLACE(ccr.CategoryName, ' ', '_') IN...

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

How to Display Report Execution Time in SSRS (milliseconds)https://www.joellipman.com/articles/microsoft/ssrs/how-to-display-report-execution-time-in-ssrs.html

17 November 2011 TOP 1 c.Name, e.TimeStart, e.TimeDataRetrieval + e.TimeProcessing + e.TimeRendering AS TotalTime FROM [ExecutionLog] e INNER JOIN [Catalog] c ON c.ItemID=e.ReportID WHERE c.Name='My Amazing Report' -- just change the value here to the name of your...

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

Returning Oracle Stored Procedure Resultset in SSRShttps://www.joellipman.com/articles/microsoft/ssrs/returning-oracle-stored-procedure-resultset-in-ssrs.html

19 January 2012 'DD-MON-YYYY')) || ')' "p_STUDENT_DETAILS", NVL(a.student_id, b.person_id) "p_STUDENT_REF" FROM student_accounts a INNER JOIN student_details b ON a.student_id = b.person_id WHERE a.student_id = p_STUDENT_REF; -- ending that second begin I had after my...

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

SITS: Export field code and namehttps://www.joellipman.com/articles/web-development/xml/sits-export-field-code-and-name.html

12 August 2014 and click on the chevrons ("»") next to the field to apply this to Enter the dictionary code, the entity code and then the inner SRL text which should be |, if you try to apply you should be prompted to convert to use gold characters: Test the XET...

• Type: Article
• Author: Joel Lipman
• Category: Extensible Markup Language
• Language: *

Zoho Creator: Change Radio into Tabshttps://www.joellipman.com/articles/crm/zoho/zoho-creator-change-radio-into-tabs.html

22 October 2021 One theoretical way around this could be that I restyle the "::after checked", hide the circle line and somehow style the inner dot to overlay or serve as background on the tab. But that was a bit too much CSS for my head so instead, I'm going to add...

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