Articles - Joel Lipman .Com

SSRS Border Problem

: Joel Lipman; SQL Server Reporting Services; 20 January 2014; Hits: 8250

What?
A very quick note on why borders may be misbehaving in SSRS. This note corrects the situation at Design time. This is where you are trying 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 just one border???

How?

: Joel Lipman; Databases; 09 January 2014; Hits: 6071

What?
Practice makes perfect. Or in my case, any practice is a start. This article serves as a quick note on how to use regular expressions within SQL statements:

How?
For the following examples, I am pretending to select rows from a table called `STUDENTS`.

: Joel Lipman; MySQL; 05 December 2013; Hits: 2890

What?
This article is to remind me how to create a blank weekly timesheet which reads the duration of events from a database and auto-completes your timesheet.

Why?
I'm being tasked to work with EPM (Microsoft Enterprise Project Management) more and more. Similar systems have popped out that support some form of time recording and activity logging. The example below however is within a LAMP/MySQL environment but the SQL basics are here to help me adapt it to whatever environment people keep throwing at me.

What I want:

copy raw

ThisDate    ThisDay     StartTime  TimeOut  TimeIn  EndTime  TotalTimeToday TotalTimeWeek
----------- ----------- ---------- -------- ------- -------- -------------- -------------
2013-12-02  Monday      09:00      12:00    13:00   17:00    7:00           7:00
2013-12-03  Tuesday     08:45      12:00    13:30   17:45    7:30           14:30
2013-12-04  Wednesday   09:00      12:30    13:30   17:00    7:00           21:30
2013-12-05  Thursday    10:00      12:15    12:45   17:15    7:45           29:15
2013-12-06  Friday      07:00      12:00    13:00   16:30    8:30           37:45
2013-12-07  Saturday    -          -        -       -        0:00           37:45
2013-12-08  Sunday      03:00      04:00    -       -        4:00           41:45

ThisDate ThisDay StartTime TimeOut TimeIn EndTime TotalTimeToday TotalTimeWeek
----------- ----------- ---------- -------- ------- -------- -------------- -------------
2013-12-02 Monday 09:00 12:00 13:00 17:00 7:00 7:00
2013-12-03 Tuesday 08:45 12:00 13:30 17:45 7:30 14:30
2013-12-04 Wednesday 09:00 12:30 13:30 17:00 7:00 21:30
2013-12-05 Thursday 10:00 12:15 12:45 17:15 7:45 29:15
2013-12-06 Friday 07:00 12:00 13:00 16:30 8:30 37:45
2013-12-07 Saturday - - - - 0:00 37:45
2013-12-08 Sunday 03:00 04:00 - - 4:00 41:45

Category: MySQL :: Article: 541

: Joel Lipman; Oracle PL/SQL; 05 December 2013; Hits: 15426

What?
A quick note on how I got round one this one.

Why?
Often enough, our requirement is that the latest record from another table is associated with the current row, and often enough we get the latest by ordering the dataset of the subquery. In T-SQL and MySQL, this is not so much of an issue.

I get this error when having to use an ORDER BY clause in a subquery within an Oracle 11g environment.

How?
Consider the following:

: Joel Lipman; Joomla; 24 November 2013; Hits: 11769

What?
This is an extract from a forum which solved our problem for why the ReCaptcha part disappears from the user registration form. We have Joomla 2.5.16 installed and no new updates for a plugin that comes with Joomla 2.5 install.

How?
Source: Joomla! • View topic - Cannot get recaptcha to display on registration form...
There are two solutions I have found that fix the problem:

: Joel Lipman; SQL Server Reporting Services; 22 November 2013; Hits: 9660

Applies to:

Microsoft Business Intelligence Development Studio 2008 (BIDS)
Microsoft SQL Server 2008 R2

What?
This article describes solutions to the error:

Subscriptions cannot be created because the credentials used to run the report are not stored, or if a linked report, the link is no longer valid.

How?

: Joel Lipman; Joomla; 17 November 2013; Hits: 5438

What?
This is a quick note on one reason you may get the above error in a Joomla CMS environment.

copy raw

Call to a member function mark() on a non-object in /public_html/index.php

Call to a member function mark() on a non-object in /public_html/index.php

How?
Not really a solution here because this is indicating that the system can't find the core framework files. Yes the bad news is you have lost your site. The good news is that it's only the core files and component files. Here are some tips when restoring the site to return it to as it was.

Category: Joomla :: Article: 536

: Joel Lipman; Excel; 15 November 2013; Hits: 6000

What?
This is a quick article on how to convert some cells in Microsoft Excel to number values...

Why?
OMG. Seriously Microsoft! I have spent an hour trying to convert a column of currency values to a number using Microsoft Excel 2010. Since when did MS Excel stop understanding what a NUMBER was?

I have a column full of currency values which I want to convert, specifically Philippine pesos to British pounds (sterling). When I multiply the Philippine peso by the conversion rate, it returns #VALUE!

How?
The problem is that I have a column which includes the currency symbol as per the following image:

: Joel Lipman; SQL Server Reporting Services; 11 November 2013; Hits: 4115

What?
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:

copy raw

Message from webpage

Subscriptions cannot be created because the credentials used to run the report are not stored, or if a linked report, the link is no longer valid.

Message from webpage
Subscriptions cannot be created because the credentials used to run the report are not stored, or if a linked report, the link is no longer valid.

Why?
The problem happens 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?

Category: SQL Server Reporting Services :: Article: 533

: Joel Lipman; SharePoint; 07 November 2013; Hits: 5504

What?
This is a quick article on how to change your profile picture in your company's sharepoint site. Sounds straightforward but without being allowed to upload images or edit other profiles, each user has to do this with the permissions they've been given.

Why?
Because I can

How?

: Joel Lipman; iOS; 03 November 2013; Hits: 10554

Applies to:

Apple iOS 7
Apple iTunes 11.1.3.8
Microsoft Windows 7 Professional

What?
Just so many articles out there that did not help me. This article is how I finally did mine.

Why?
I had paid for some apps on my old phone and realized that if I didn't do a "restore", then I would have to install and pay for them all again. My purchased music was in the cloud so those could be re-downloaded on to the new phone (not fun).

The Apple documentation iOS: Transferring information from your current iPhone, iPad, or iPod touch to a new device was as useful as a Microsoft KnowledgeBase article. In that, it restored all my photos and the default Apple apps, but missed out all my other apps (and audio).

How?
Note that the restore can be done when the new phone prompts you to set it up but you could do the below again at anytime (as I discovered). The steps below apply after having gone through the process of setting up the phone and finishing on the "Get Started" (including Touch ID).

: Joel Lipman; Web-Development; 28 October 2013; Hits: 6186

What?
A quick reminder on basic regular expressions.

Match Any Character — Dot
The dot operator '.' matches any single character in the current character set. For example, to find the sequence--'a', followed by any character, followed by 'c'--use the expression:

copy raw