Include a carriage return in a column headinghttps://www.joellipman.com/articles/microsoft/sql-server/include-a-carriage-return-in-a-column-heading.html

07 July 2014 character references "CHAR(10)" [line feed] and "CHAR(13)" [carriage return] but to do this in the name of the column heading, the answer is a much simpler one, in your SQL statement, simply place your cursor where you want the carriage return and press...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server
• 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 on the exported report when we followed that suggestion. Consider the following report in design view, only the circled headings would appear on the exported report: The solution I found that worked for me, was to make all the heading boxes the same...

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

Change div height to fit contenthttps://www.joellipman.com/articles/web-development/css/change-div-height-to-fit-content.html

19 December 2016 to: CSS HTML What? A quick article on how to get a div layer to increase height based on how a heading fits on a page. What? I have a heading like this: The code of this is: A long heading that wraps over several lines When I shrink the browser, I get a...

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

Parse a HTML Table into a ListViewhttps://www.joellipman.com/articles/web-development/html/parse-a-html-table-into-a-listview.html

30 March 2013 to parse Haystack := CodeContainingMyHTMLTable ; determine markers (character positions) Needle1a := " My Unique Table Heading" ; Needle1a is a marker for a unique value in the whole content Needle1b := " " ; Needle1b is a marker for a value located...

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

Upgrading Joomla CMS version 3.x to Joomla CMS 5.xhttps://www.joellipman.com/articles/cms/joomla/upgrading-joomla-cms-version-3-x-to-joomla-cms-5-x.html

04 February 2025 administrator panel, go into each category and hit save and close starting with the parent categories first Copying article heading images from SP Page Builder to normal Joomla Articles SELECT new.`id`, old.`id`, json_extract(old.`attribs`,...

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

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 data value. Cause 3: Fields and objects in the same column do not have the same text alignment For example, the column heading text object is aligned to the right, while the database field is aligned to center. To ensure all objects have the same...

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

Accessing a MySQL Database with Business Intelligence Development Studiohttps://www.joellipman.com/articles/database/mysql/accessing-a-mysql-database-with-business-intelligence-development-studio.html

05 January 2011 specify the query as you would with any SQL query. (to create the dataset) Select the Report Type (for just a table with a heading row at the top, select "Tabular") > Next Click on "Details" until everything is added. > Next I'm boring and old-school so...

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

SSRS Hide results table if emptyhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-hide-results-table-if-empty.html

29 March 2011 when the room didn't contain equipment (or the admins had not added the equipment info on the system), it just showed the heading "Equipment". Iteration in T-SQL? Unlike good old MySQL where you can do iteration within the query (SELECT...

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

Registered Users Cannot Login - Super Users Canhttps://www.joellipman.com/articles/cms/joomla/registered-users-cannot-login-super-users-can.html

26 February 2014 zero. Login to your database using phpMyAdmin, open the table with the suffix "_assets" and order the data (clicking on the heading of the column) by their parent_id. If you see more than one record with a value of 0, then change it to 1. If it's name...

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

Joes Search Module (JSM)https://www.joellipman.com/component/content/article/joes-search-module-jsm.html?catid=40

09 March 2015 results page. There should be several additional options to your search that will be displayed under the "Search Only:" heading and then a list of components. Find the value of the checkbox by viewing the HTML source and you should see something like...

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

Joes Google Map (JGM) Downloadshttps://www.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: *

Amazon Kindle: Send PDFs to your Kindlehttps://www.joellipman.com/amazon/kindle/amazon-kindle-send-pdfs-to-your-kindle.html

29 June 2022 are shown under the Content Other options shown include Devices, Preferences, and Privacy Settings. Click on the Devices heading to show the Device Summary Under Device Summary, you will be shown a host of information related to your device, which...

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

Zoho Projects: Get All Eventshttps://www.joellipman.com/articles/crm/zoho/zoho-projects-get-all-events.html

22 July 2024 // // *********************************** // get Zoho Projects information v_BaseURL = "https://projectsapi.zoho.com"; v_Heading = ""; // // get all portals v_EndpointPortals = v_BaseURL + "/restapi/portals/"; r_Portals = invokeUrl [ url:...

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

Zoho Analytics: Create a Monitoring System with Imageshttps://www.joellipman.com/articles/crm/zoho/zoho-analytics-create-a-monitoring-system-with-images.html

25 July 2024 Value" Repeating the above for a few more widgets (or cloning the first widget and then changing the filter and heading label), I now have a dashboard that has the following: Done! Source(s): IconExperience - Professional Icons » V-Collection » Browse...

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