Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Crystal Reports Function

Posted on 2013-12-26
1
Medium Priority
?
458 Views
Last Modified: 2013-12-26
I do not understand what the function Chr(13) is doing in this sample formula:

"Region(s) selected for this report: " & Join({?Region}, ", ") & Chr(13) &
"The order Date Range is from " & Date(Minimum({?Date Range})) & " to " & Date(Maximum({?Date Range}))

Can someone provide some background on the function Chr(13)?

Thank you.
0
Comment
Question by:garyjgs
1 Comment
 
LVL 101

Accepted Solution

by:
mlmcc earned 2000 total points
ID: 39740692
CHR returns the ASCII character associated with the number.

Chr(65) = A

Chr(13) is the carriage return character.  It is simply forcing the remaining text to the next line on the display regardless of other considerations like the width of the text box.

mlmcc
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
Loops Section Overview

571 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question