Crystal Reports: Exporting to Excel omits column headershttps://www.joellipman.com/articles/microsoft/excel/crystal-reports-exporting-to-excel-omits-column-headers.html

03 June 2010 same width as their respective column heading. Remove any ruler gridlines that don't truly serve a process (even if they're just for margin purposes)

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

Blank columns issue when exporting to Excel (Data Only) from Crystal Reportshttps://www.joellipman.com/articles/microsoft/excel/blank-columns-issue-when-exporting-to-excel-data-only-from-crystal-reports.html

15 June 2010 formatted so they are much wider than the actual size of the data can cause blank columns. Make sure the field width is just wide enough to display the longest data value. Cause 3: Fields and objects in the same column do not have the same text...

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

UTF8 Unicode PHP MySQL for International Charactershttps://www.joellipman.com/articles/web-development/php/utf8-unicode-php-mysql-for-international-characters.html

22 October 2010 is a note to myself but also to anyone out there who's spent as long as I did looking for a solution to this. Maybe it's just me but this is the scenario: Joomla works fine with international characters A Module Extension I wrote for Joomla! displayed...

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

SQL Queries for Statisticshttps://www.joellipman.com/articles/database/mysql/sql-queries-for-statistics.html

13 December 2010 0 if not logged in) and of course the Timestamp (DateTimeStamp). Here is a page of some MySQL queries I can do based on just those 5 columns: MediaWiki: number of unique guests, students and staff by month. Also associates a UserID to the wikimedia_user...

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

Returned a data type that is not validhttps://www.joellipman.com/articles/database/t-sql/returned-a-data-type-that-is-not-valid.html

06 January 2011 I'd put a note on this error. Bearing in mind that this is a general data type error and not just because I tried to convert a date in SQL format to a Month name. An error occurred during local report processing. An error has occurred during report...

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

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

07 January 2011 again I've spent a whole morning going in the wrong direction with a convincing SQL script. This article is just a note on when using Business Intelligence Development Studio (BIDS) or Report Builder 2.0 and when previewing the report, the parameters...

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

Merge the content of two similar tables in MySQLhttps://www.joellipman.com/articles/database/mysql/merge-the-content-of-two-similar-tables-in-mysql.html

11 January 2011 and its design is property of SomeoneElse.com Note how I don't use the `id` columns of the tables as I'm quite content with just the two columns I requested. And for those of you that don't know, the alias "AS" is optional in MySQL (think it's optional...

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

Formatting a date in an MDX queryhttps://www.joellipman.com/articles/database/t-sql/formatting-a-date-in-an-mdx-query.html

11 January 2011 and trying to specify default date as today's in the format DD/MM/YYYY. Googled this but couldn't find an answer, then I just replaced "=NOW()" [yields: 01/01/2011 01:00:00] with "=Today()" [yields: 01/01/2011] and this did the trick. English Ordinal...

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

URL passed settings in Reporting Serviceshttps://www.joellipman.com/articles/microsoft/ssrs/url-passed-settings-in-reporting-services.html

11 February 2011 &rc:Toolbar=False To hide just the parameters (default is True) http:///ReportServer/Pages/ReportViewer.aspx?%2fMYREPORTS%2fDemos%2fRB+Report+for+Me&rs:Command=Render &rc:Parameters=False To change the Rendering modes (defaults to HTML4.0)...

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

Creating a Profile Plugin for Joomla 1.6https://www.joellipman.com/articles/cms/joomla/creating-a-profile-plugin-for-joomla-16.html

27 April 2011 an avatar (and sync with 3rd party avatar). Not riveting stuff but something that all my clients want. Fortunately for me, I just created one plugin which I can install on any number of Joomla 1.6 sites and it does all this for me... Neat huh? Folder...

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

Newbies guide to be the local computer guyhttps://www.joellipman.com/hardware/newbies-guide-to-be-the-local-computer-guy.html

28 April 2011 if you can post a flyer in their window or on their cash wrap. Initially, charge a nominal fee…maybe something like $30/hour just to build up a client base and get some referalls. Put up a Web site describing your services. It makes you look more legit...

• Type: Article
• Author: Joel Lipman
• Category: IT Support
• Language: *

Basic Webpage Controls with JavaScript / COMhttps://www.joellipman.com/articles/automation/autohotkey/basic-webpage-controls-with-javascript-com.html

05 July 2011 MsgBox % COM_Invoke(pwb, "document.getElementsByTagName[input].item[3].value") Controlling the WebPage So far we have just retrieved information from the webpage. Now lets start controlling the webpage. Note - if the JavaScript doesn't end with a...

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

Unix Date Format Specifiershttps://www.joellipman.com/articles/linux/unix-date-format-specifiers.html

05 July 2011 could just remember to search wikipedia for "Date (Unix)" or search my site for "Unix". This was easier. Source: Wikipedia: Date (Unix) Format specifiers (format string starts with +) Specifier Description Values/Example Day %a weekday, abbreviated Mon...

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

SSRS / MDX Date Querieshttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-mdx-date-queries.html

03 August 2011 31/12/2011 I'll add to this if I use others. Apologies for the European formats but this is what I work with so I like to just copy and paste from this article.

• 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 be category field: So is this doing what I wanted? Well NO. I have a table with the same report mentioned several times but just in a different week. I want a returned table structured as follows: Report Name Run Last Week Run This Week...

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

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

05 September 2011 to "Row Labels" (put it at the top as parent) Right-click on the pivotTable on one of the values of the row label you just moved Select "Sort" Select "More Sort Options" Select "Ascending or Descending" and select "Month" (or name of field) from the...

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

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

19 September 2011 of uploading 10000+ images into a Sharepoint database though we are still considering it; so this article is more about just getting external images to display when they are provided over an authenticated URL (You shouldn't be having any issues with...

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

Alternative method of displaying Unicode in Autohotkey GUIhttps://www.joellipman.com/articles/automation/autohotkey/alternative-method-of-displaying-unicode-in-autohotkey-gui.html

29 September 2011 yes you could just use the Unicode version of Autohotkey. If you're looking for some up and down arrows which is all I wanted, then you don't have to use Unicode and you can use the Chr() function: msgbox % Chr(24) ; upwards arrow msgbox % Chr(25) ;...

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

Joes Network Transmission Detector (JTD)https://www.joellipman.com/component/content/article/joes-network-transmission-detector-jtd.html?catid=40

29 September 2011 run off USB). Source files included for you to check. No signups, etc required, have fun! What's it detecting? Currently it just reads the size of packets sent and received. This allows me to test websites for example and compare page loads. It's more...

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

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

11 October 2011 replace NULL with lots of hyphens (if you want lots of dashes/hyphens as separators) or replace with whatever character. I just put NULL because I wanted an empty row. My final query This displays all room bookings for today and the next 6 days. Note...

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