SQL – How to format decimal to space delimited currency $ 1 234 567.89
Learn how to format a decimal value in SQL Server with this example showing how to convert a decimal value like 1234567.89 into a space-delimited currency, such as $ 1…
VALUE
SQL – How to insert new line/line break in string
Learn how to add line breaks in SQL strings using CHAR() function and subqueries with STUFF and FOR XML PATH."This article provides a solution for adding line breaks or newlines…
SQL – How to decode HTML entities when using FOR XML PATH
Learn how to decode HTML entities in SQL queries using the FOR XML PATH statement with this article that provides a solution for converting special characters back to their original…
Crystal Reports – Display running total as 0 when null value
How to display a NULL value as a zero in Crystal Reports? Learn two ways to achieve this by following our step-by-step guide.
Crystal Reports – How to display selected parameter values
How to Display Selected Parameter Values in Crystal Reports
Crystal Reports – How to format number as percentage
Learn how to format numbers as percentages in Crystal Reports using these easy step-by-step instructions.
Crystal Reports – How to fix ‘Division by zero’ error
Learn how to fix the "Division by zero" error in Crystal Reports. Find the formula causing the issue and add a check to prevent it.
Crystal Reports – How to convert string date to real date value
Convert string date to real date value in Crystal Reports with the help of DateValue function.How to convert string date to real date value? This article provides solution by using…
Crystal Reports – How to display boolean true/false as tick
How to Display Boolean True/False Values as Tick and Cross in Crystal Reports