Assuming often is required, the following 37 results were found.
-
row and paste your expression in the "Fill > BackgroundColor" properties row... Done! Borders: I'm putting this here because often enough, if I'm going to make the report pretty with alternating rows, I'm probably going to look at the cell borders as...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
be a space in between the two words "Academic" and "Week" otherwise the system will only understand the carriage return and often return it as "AcademicWeek"). Other Search(es) Format a column alias with new line Using carriage return in column names...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server
- Language: *
-
special character is 3 easy steps: Hold down the ALT key (preferably the one on the left of the spacebar and not the Alt Gr often found on the right of the spacebar) then press the numbers in the numeric pad (while still holding down the ALT key), then...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: *
-
summing the remaining columns? Correction, sum will only give me the total time but what if a report has been run twice more often then another, then is it slower? Not necessarily. Like all measures in bytes, I would like a thousand separator, and lose...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
In view of the fact that this error pops up in so many systems I take over, I have often gone down the wrong path following the red herring as it were when in fact the answer to this is very common. Why? Bespoke systems are the usual suspects....
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
of the article as it is what you should do before running a DELETE FROM statement but I've added it here as I use it quite often: SELECT s.sessionId, ssf.sessionId, sst.sessionId FROM `Session` s LEFT OUTER JOIN `SessionStaff` ssf ON...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
Run the first query again and no rows should be returned. Quick Joomla One I use this reluctantly but often necessarily. SET @stringtoFind=' '; SET @stringtoReplaceWith=' '; UPDATE `MYTABLE_content` SET `introtext` = REPLACE(`introtext`, @stringtoFind,...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
these kind of words will return results of similarly typed/sounding words. How? Here's just a splurge of SQL but I use this often enough: UPDATE `myTable` t SET t.`myColumn`=REPLACE(t.`myColumn`, 'À', 'A'); UPDATE `myTable` t SET...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
to be the same size as the numbers but not overlap any list item beneath it. By increasing the size of the asterisk, this often increases the line-height and causes the overall line height to change for other objects in the same row. The problem...
- Type: Article
- Author: Joel Lipman
- Category: Cascading Stylesheets
- Language: *
-
on how create an multi-level ordered list that indents and aligns correctly. Why? I'm finding that I need to do this quite often for some clients who want to include their terms and conditions in quote/invoice templates and want the HTML to be indented...
- Type: Article
- Author: Joel Lipman
- Category: Cascading Stylesheets
- Language: en-GB
-
it took me an age to find out how I could do it. This is when using a MySQL query within a PHP script. The process is used often to do a statistics table or top ten chart of your data (eg. movies, music, etc). My aim is to do the following: retrieve...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: *
-
// close connection curl_close($ch); Things I stumbled upon regarding SSL and cURL Posted data for third-party apps is often required via SSL so this may come in handy curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, 0); curl_setopt($ch, CURLOPT_SSL_VERIFYPEER,...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
This will create custom parameters/argument suffixes you can add which represent a whole string of words that you may use often but don't feel like typing every time. (follow these to the letter or it will simply reset your custom option): type /prefer...
- Type: Article
- Author: Joel Lipman
- Category: Graphic Design
- Language: *
-
or prospective tenant/landlord suggests using an escrow service to complete the transaction. These escrow websites often may look official, but are actually run by fraudsters. They’ll take your money and never send you the product. Payment for...
- Type: Article
- Author: Joel Lipman
- Category: IT Support
- Language: *
-
to find these in Google so referring to my own website, this is a doddle for me to find each time. Why? I have to do this so often that it deserves an article. Though writing a whole page for this is probably unwarranted so I may rename this article...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: en-GB
-
Business Intelligence Development Studio 2008 Often happens to me and not sure why. You open the project and the window panel for the Report Data containing the parameters and datasets isn't there. I spent a bit of time enabling/disabling toolbars...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
Note that the following queries include the nested version because I find myself needing to group concatenate more often from another table then using data from the same table. MySQL SELECT ( SELECT GROUP_CONCAT(column_to_return_as_string) FROM...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB