Skip to Content
0
Jul 30, 2023 at 10:31 AM

Crystal Reports: Issue with Displaying Exact Database Field Value in Main Report Preview

356 Views

Hi SAP Community,

I'm facing a peculiar issue with Crystal Reports, and I'm hoping to get some assistance to resolve it. In my report, I'm trying to display the "tblTrp.sn" field value exactly as it is in the Main Report View. However, the value keeps showing up with random colors like "RED" or "LIME," which is not the expected behavior.

Visual Studio & SAP Version:

image.png

image.png

Here are the details of the problem:

Database Table: tblTrp

Field to Display: tblTrp.sn

Expected Value: The values in the "tblTrp.sn" field are in the format "N2300XXXXXX." For example, "N2300123456."

Current Issue: Instead of displaying the actual "tblTrp.sn" value "N2300XXXXXX", it shows the value in random colors like "RED," "LIME," etc.

Attempts Made:

I have tried different approaches to resolve this issue, including:

Using the Crystal Reports TRIM() function to remove any extra spaces.

TRIM({tblTrp.sn})

Using the ToText() function to convert the value to text explicitly.

ToText({tblTrp.sn})

However, none of these attempts have worked, and the issue persists.

Additional Information:

I have confirmed that the data in the database is correct and stored as "N2300XXXXXX."

The report is connected to the correct database, and other fields display data correctly.

image.png

image.png

image.png

image.png

image.png

I would greatly appreciate any insights, suggestions, or solutions to help me display the exact value of "tblTrp.sn" in the Main Report View without any additional formatting or random colors.

Attachments

image.png (32.7 kB)
image.png (11.5 kB)
image.png (3.7 kB)
image.png (10.8 kB)
image.png (28.6 kB)
image.png (40.0 kB)
image.png (26.0 kB)