Report Builder 2.0 - Hide Series1https://joellipman.com/articles/microsoft/ssrs/report-builder-20-hide-series1.html

06 May 2010 guys but I've searched the WWW for a solution and couldn't find it. The work around I've documented is a "solution" to my situation and environment. Our setup is: SQL Server 2008 Report Builder 2.0 BMC Service Desk Express 9.8 DataSet1: Incident # Group...

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

Change the login link in MediaWikihttps://joellipman.com/articles/cms/mediawiki/change-the-login-link-in-mediawiki.html

22 September 2010 usual I have searched the WWW but I obviously don't how to use Google because I couldn't find an answer. My situation is this: We have an internal wiki knowledge base using MediaWiki version 1.14. Some articles are available for public, some are...

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

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

29 March 2011 I'm doing the below is nothing similar to what I googled (probably a bad sign but time is ticking and no one has forever). Situation: I have a report which I've already completed and pretty chuffed with. It shows the details on a user-specified room...

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

Inserting incremental weeks in MySQLhttps://joellipman.com/articles/database/mysql/inserting-incremental-weeks-in-mysql.html

15 April 2011 Situation: I have a silly database table (not mine) storing CMIS Facility week numbers and their starting dates. For those of you unfamiliar with this system, the reason week numbers are different to normal people's week numbers is because these are...

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

CSS keeping the footer at the bottomhttps://joellipman.com/articles/web-development/css/css-keeping-the-footer-at-the-bottom.html

25 April 2011 "push" div layer. Loosely based on Ryanfait: Make a Footer Stick to the Bottom of the Page Aim: Header Left Right Footer Situation The header displayed fine. The left and right columns finally got them side by side. But the footer that has a background...

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

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

28 June 2011 do anything else while it's sitting there taking pictures; unless you have more than one screen. It's automation. The situation is that the program takes a picture of whatever that section of the screen is displaying. I made this program stay on top of...

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

SSRS Querying on either of 2 Parametershttps://joellipman.com/articles/microsoft/ssrs/ssrs-querying-on-either-of-2-parameters.html

19 July 2011 situation is that we are replacing a website-application with a single SQL Server Reporting Services (SSRS 2008 R2) report. We're using Business Intelligence Development Studio (BIDS VS2008) with Team Foundation Server (TFS VS2010) and connecting to an...

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

Sort order a dropdown list in MS InfoPath without programminghttps://joellipman.com/articles/microsoft/infopath/sort-order-a-dropdown-list-in-ms-infopath-without-programming.html

21 July 2011 So this is for Microsoft Office Infopath 2007 (SharePoint 2007). The situation is that I started creating a SharePoint List (datasheet) and when I made my form dropdown read from the list, it just put elements in the order that I entered them in the...

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

SSRS Parameters in Oracle Stored Procedurehttps://joellipman.com/articles/microsoft/ssrs/ssrs-parameters-in-oracle-stored-procedure.html

02 September 2011 invalid character ORA-06512: at "SYS.DBMS_UTILITY", line 114 ORA-06512: at line 1 (System.Data.OracleClient) The Situation I'm using Business Intelligence Development Studio 2008 to develop a Reporting solution on a Windows XP workstation. We are...

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

Excel PivotTable Filter List Orderinghttps://joellipman.com/articles/microsoft/excel/excel-pivottable-filter-list-ordering.html

05 September 2011 there are a lot of solutions out there, none of which applied to what we meant and lots of people in the same boat. The Situation We have an Excel report which summarizes for our guys at the top, all the activities and time spent by staff. There are...

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

SSRS External Images don't displayhttps://joellipman.com/articles/microsoft/ssrs/ssrs-external-images-dont-display.html

19 September 2011 Situation We want some photos taken from another website of ours to display in our report. These are not stored locally on the Reporting Server because other services use these photos on our Intranet and we only want one location to upload the photos....

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

Stop Excel Row Height Self-Adjust on Refreshhttps://joellipman.com/articles/microsoft/excel/stop-excel-row-height-self-adjust-on-refresh.html

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

SSRS Zero Paddinghttps://joellipman.com/articles/microsoft/ssrs/ssrs-zero-padding.html

10 November 2011 mainly because it meant modifying the SQL query. The 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...

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

SSIS Convert a string into a datehttps://joellipman.com/articles/microsoft/ssis/ssis-convert-a-string-into-a-date.html

14 March 2013 article is not a solution but a page of various methods and date conversions which I try and use depending on the situation. This is a quick article on how I got time conversion working in an SSIS package which read from a text file. Note that the...

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

SSRS Stop Scrolling Behindhttps://joellipman.com/articles/microsoft/ssrs/ssrs-stop-scrolling-behind.html

08 April 2014 will error): Save and test on the ReportServer. Background: If you need to visualize how I could have ended up in such a situation, here's the design mode of the report (apologies for the red censoring but this allows the images to be used in further...

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

Border settings not saving in SSRShttps://joellipman.com/articles/microsoft/ssrs/border-settings-not-saving-in-ssrs.html

24 March 2011 may sound silly to some but I've written a note because I spent time googling and still didn't find an answer. My situation is that I wanted to put an expression to format the border (empty cells have a border and non-empty don't). This was so that a...

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

SSRS Use T-SQL Like with a Parameterhttps://joellipman.com/articles/microsoft/ssrs/ssrs-use-t-sql-like-with-a-parameter.html

04 April 2011 must have been so obvious to everyone else that nobody bothered to write an article on it... till now. Situation I have a report that returns room bookings based on a user and given a date range. The problem is that there are a few thousand users and...

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

Set default parameter dates to start and end of monthhttps://joellipman.com/articles/microsoft/ssrs/set-default-parameter-dates-to-start-and-end-of-month.html

05 April 2011 Situation The requirement in a lot of my reports in SSRS has always been a date range rather than just the one date. The user must be allowed to select all results between two dates instead of just specifying the one day. If the second parameter...

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

Oracle SQL - Convert given list (CSV) into Rowshttps://joellipman.com/articles/database/pl-sql/oracle-sql-convert-given-list-csv-into-rows.html

30 August 2011 that worked for me. Taken from the Oracle forums @ https://forums.oracle.com/forums/thread.jspa?messageID=6861756 Situation I have one column of values that I've suffixed a comma to but I want to display this as a rows in a table. This is for Oracle...

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

First and Last Entry on a Page using Modulus Remainderhttps://joellipman.com/articles/web-development/php/first-and-last-entry-on-a-page-using-modulus-remainder.html

26 September 2011 when looping through a loop, which entry was first and which was last. This is incredibly useful for pagination. The Situation I want the script to start writing a DIV layer in the code at the start of the loop (and at every first entry of a page). I...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: *