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

15 June 2010 and Position and then setting the XY coordinates. Use the horizontal and vertical rulers as a reference when specifying height, width, and XY coordinates. Export the report to Excel and all the fields in the section appear in the same column. Extra...

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

Room Availability Calendar in Business Intelligence Development Studiohttps://joellipman.com/articles/microsoft/ssrs/room-availability-calendar-in-business-intelligence-development-studio.html

23 March 2011 Fields!Time.Value) Make the object in the cell a block (which I made big and then didn't allow cell to increase/decrease height). This way when it's printed out (backgrounds won't print by default) the occupied blocks will show up....

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

Win32 Constantshttps://joellipman.com/articles/automation/autohotkey/win32-constants.html

05 July 2011 = $00020000 Const DT_WORD_ELLIPSIS = $00040000 ;#End Region ;#Region Rebar Styles Const RBS_TOOLTIPS = $0100 Const RBS_VARHEIGHT = $0200 Const RBS_BANDBORDERS = $0400 Const RBS_FIXEDORDER = $0800 Const RBS_REGISTERDROP = $1000 Const RBS_AUTOSIZE = $2000...

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

Three boxes, two roll over, one falls outhttps://joellipman.com/articles/web-development/css/three-boxes-two-roll-over-one-falls-out.html

21 January 2013 called "yoo_sync". Some clever scripts (both mootools and jquery) using the equalize method to make div layers the same height, and in this case, the same width. It isn't so much a miscalculation of 100% divided by 3 that leaves 1 pixel left over, more...

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

DJI Phantom FC40 - Fun at the raceshttps://joellipman.com/articles/_other-misc/quadcopters/dji-phantom-fc40-fun-at-the-races.html

17 September 2014 Not Near People: I could not risk flying low so I took a measure of about 3 people high and stood so I could see the height of our 1 marshall's head. To be honest, the reason I wasn't using my propeller guards was that I clean forgot which was rather...

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

Android: Function to let user take photo or choose existinghttps://joellipman.com/articles/google/androidos/android-function-to-let-user-take-photo-or-choose-existing.html

04 November 2014 myPhotoImage.setImageBitmap(BitmapFactory.decodeFile(picturePath)); } } Just in case The ImageView I have (minus the width, height, margins, etc): Additional To check if the user has a camera beforehand, apparently...

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

Joes Revolver Map (JRM) Downloadshttps://joellipman.com/component/content/article/joes-revolver-map-jrm-downloads.html?catid=92

07 September 2015 name actually works... - Trimmed any spaces from posted data and html code. - Used revolvermaps.com selection of "width x height" values. - Date Uploaded: Fri, 30th Jul 2010 1.1- Separated all parameters to be configured in the Joomla admin panel -...

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

Joes Google Map (JGM) Downloadshttps://joellipman.com/component/content/article/joes-google-map-jgm-downloads.html?catid=92

07 September 2015 VersionPlatform ChangeLogOptions1.1- Added parameters: Width, Height - Added parameters: Zoom Level, Heading, Tilt - Added parameters: Marker 1: Latitude, Longitude - Added parameters: Marker 1: HTML to display, Replace Marker Image - Added parameters:...

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

Zoho Templates - Font size is inexplicably tinyhttps://joellipman.com/articles/crm/zoho/zoho-templates-font-size-is-inexplicably-tiny.html

22 February 2019 effect. Class .page: I actually like using this class because it's pretty descriptive. Unfortunately setting the width/height in cm was causing havoc to my template. Specifying only a font-size, font-family, margins and page-break-after was pretty much...

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

CSS Printing - Page Break Inside with Headers and Footershttps://joellipman.com/articles/web-development/css/css-printing-page-break-inside-with-headers-and-footers.html

22 February 2019 this is what I had to do: @page { size: A4; margin: 0cm 0cm 0cm 0cm; } .page { page-break-after: always; width:21cm; height:29.7cm; margin:0mm 0mm 0mm 0mm; padding:3cm 1cm 2cm 1cm; display: table; }

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

Zoho Creator: Two submit buttons on a non-stateless form with 2 different redirectshttps://joellipman.com/articles/crm/zoho/zoho-creator-two-submit-buttons-on-a-non-stateless-form.html

27 July 2021 } .zc-Save_and_Close-group label{ cursor:pointer; outline:none; text-align:center !important; white-space:nowrap; line-height:19px; height:31px; background-color: #6B47F4; color:#fff !important; font-weight: 400 !important; font-size: 14px !important;...

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

Zoho Creator: Public URL of an Image field / Upload to Shopify APIhttps://joellipman.com/articles/crm/zoho/zoho-creator-public-url-of-an-image-field-upload-to-shopify-api.html

17 October 2021 {access_token}" Yields something like the following response: { "image": { "position": 1, "width": 3024, "height": 3024, "alt": null, "id": 12345678901234, "product_id": 9876543210987, "created_at": "2021-10-17T21:45:56+01:00", "updated_at":...

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