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 Following up on my article on correcting disappearing headers, a further issue with our web-report is that even an export to Excel (Data Only) from Crystal Reports 9, created extra columns. This issue could not be replicated on the client machine (ie....

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

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 If you've been to the point where you're exporting a report to Excel, and only some of the column headers appear, then try this: I googled this for ages and found different suggestions here and there but none of them produced consistent results. One...

• Type: Article
• Author: Joel Lipman
• Category: Excel
• 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 Test1 Room 08:00:00 08:00:00 2011-03-23 08:00:00.000 Test2 Room 08:00:00 09:30:00 2 Note that [Test1 Room] will appear as a row but have no slots booked against it. [Test2 Room] will both appear as a row and have 3 slots taken up (if you left the above...

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

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

19 September 2011 2008 R2 Reporting Server (SSRS) running on Windows Server 2003 Team Foundation Server 2010 (TFS) Problem #1: Image does not appear within SSRS When previewing the report in BIDS, the photo appears fine. If we deploy the report to our Reporting Server...

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

Background Gradient Disappears on Long Pageshttps://www.joellipman.com/articles/web-development/css/background-disappears-on-long-pages.html

20 November 2012 on the site, the contents background (white) shows. When I visit a very long page on the site, the contents background disappears and reveals the overall background (blue) making the text very hard to read. Why? Took me a while to figure out what was...

• Type: Article
• Author: Joel Lipman
• Category: Cascading Stylesheets
• Language: *

XML Schema Referencehttps://www.joellipman.com/articles/web-development/xml/xml-schema-reference.html

13 August 2014 Elements Element Explanation all Specifies that the child elements can appear in any order. Each child element can occur 0 or 1 time annotation Specifies the top-level element for schema comments any Enables the author to extend the XML document with...

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

Zoho CRM: Make Upload File Field Mandatoryhttps://www.joellipman.com/articles/crm/zoho/zoho-crm-make-upload-file-field-mandatory.html

18 December 2024 What? A quick article on making an "upload file" field mandatory. Why? Because for some reason, it wouldn't appear as selectable when I tried using a layout rule. Probably everyone else has figured this out and I'm just late to the party. How? Through...

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

ZohoCRM: ZDK Client Script to retrieve Contact Emailhttps://www.joellipman.com/articles/crm/zoho/zohocrm-zdk-client-script-to-retrieve-contact-email.html

20 July 2022 other event you can use this in inline editing mode in is the Canvas mode. Error(s) Encountered Contacts doesn't seem to appear in Client Script IDE. Didn't for me but then it isn't too hard to guess what the module name is.

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

GDPR Privacy Policyhttps://www.joellipman.com/static-items/gdpr-privacy-policy.html

14 February 2019 that disparages or discredits JoelLipman.com. All other trademarks not owned by JoelLipman.com or its subsidiaries that appear on this site are the property of their respective owners, who may or may not be affiliated with, connected to, or sponsored by...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *

Setting up your store to use SSLhttps://www.joellipman.com/articles/ecommerce/setting-up-your-store-to-use-ssl.html

11 September 2009 and press return. If it has been installed correctly the store should reload and a padlock will appear in the status bar of your browser software. If, on the other hand you get any warning messages or other errors please contact your hosting company to...

• Type: Article
• Author: Joel Lipman
• Category: eCommerce Systems
• Language: *

Installing phpBB3 for Joomla with a RocketTheme templatehttps://www.joellipman.com/articles/cms/joomla/installing-phpbb3-for-joomla-with-a-rockettheme-template.html

28 September 2009 added, return to inside the category ROKBB3 so that you can see that the Affinity module been added (an extra row will have appeared). In the bottom right where you selected Affinity, select "Global configuration" in the long dropdown and then click on...

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

Change default order of weblinkshttps://www.joellipman.com/articles/cms/joomla/change-default-order-of-weblinks.html

15 November 2009 User (9 July 2011): As an update for those of us brave enough to use the upgraded CMS, I have looked into this and it would appear that Joomla! CMS have not changed this. I'd imagine it quite low priority. This is easier to tweak in the upgrade. The...

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

Windows 7: System Clock is constantly going out of synchttps://www.joellipman.com/articles/microsoft/windows-os/windows-7-system-clock-is-constantly-going-out-of-sync.html

28 January 2010 server is ticked Select an option from the dropdown menu starting with the first Click on the Update now button Text will appear beneath the button If you get an error, then select a different server from the dropdown If you get the text The clock was...

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• Language: *

Windows Live Messenger: Error 80048820https://www.joellipman.com/articles/microsoft/windows-os/windows-live-messenger-error-80048820.html

08 March 2010 server is ticked Select an option from the dropdown menu starting with the first Click on the Update now button Text will appear beneath the button If you get an error, then select a different server from the dropdown If you get the text The clock was...

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

Is it a scam? Gumtree.com's warning signshttps://www.joellipman.com/hardware/is-it-a-scam-gumtreecoms-warning-signs.html

12 October 2010 Any emails which combine urgency with a need for personal details should be treated with caution, no matter whom they appear to be from. Website pages can be easily faked. «CompanyName» and most other companies will never send out such emails. If you...

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

SQL Calendar in Business Intelligence Development Studiohttps://www.joellipman.com/articles/database/t-sql/sql-calendar-in-business-intelligence-development-studio.html

14 January 2011 have mon-sun along the top), "Order" in rows (order is which week in the month), and the Date and Note in the details (will appear in each cell per day). Grouping by weeks: Now we finish with the report wizard and returned to the designer. Right-click...

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

Joes Quicklist Weblinks (JQW)https://www.joellipman.com/component/content/article/joes-quicklist-weblinks-jqw.html?catid=40

03 July 2011 page until all thumbnails have been generated. Switch "STOP Thumbnail Service" to "YES" Logout NB: Thumbnails will first appear blue as the service downloads/queues them. Adding a weblink: Add your Joomla! weblink as per usual Switch "STOP Thumbnail...

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

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

11 September 2012 I want to create a div layer that I can see through (like a window with no glass) and for all the flashy stuff, to only appear within the boundary of the parent div layer. Why? I'm making a slideshow from scratch. How? The idea is: Use two main div...

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

Search a database with SOUNDEXhttps://www.joellipman.com/articles/database/search-a-database-with-soundex.html

11 October 2012 restrict this by schema otherwise occurrences in tables where the column is ** ** the referred to in a view, will appear twice: ** ** Change: ** ** WHERE DATA_TYPE IN ('char', 'nchar', 'varchar', 'nvarchar', 'text', 'ntext') ** ** To: ** ** WHERE...

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

Battery Constantly Drained on iPhonehttps://www.joellipman.com/articles/apple/battery-constantly-drained-on-iphone.html

27 November 2012 and knew how to close apps running in the background (double-click "home" button and hold down app until red minus buttons appear, tap red button)... I wouldn't usually take notice but I think this is a brilliant example where trying to fix the problem...

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