Column Display Format

Question

Hi

  In Crystal Cross Tab report i have column group by date on monthly basis. I want 04/2019 to be displayed as Apr-2019.

Thanks

Answer 1

Hello Ramco,

• Open Your Cross Tab Report in Crystal Reports.

• Right-click on the column header (date field) in the Cross Tab.

  ToText({YourDateField}, "MMM-yyyy")
  

   

• Click Save & Close and then OK.

• Refresh the report, and the date should now appear as Apr-2019 instead of 04/2019.

• Select "Format Field" from the menu.

• In the "Display String" formula editor, enter the following formula:
   

Answer 2

Hello Ramco, @Doodle Baseball

Please submit specific images in the Crystal Cross Tab report.

Answer 3

Hi! It seems you're looking to format the date display in a Crystal Cross Tab report column from "04/2019" to "Apr-2019." This kind of formatting adjustments can typically be done in Crystal Reports by customizing the date format in the field.

To achieve the desired date format "Apr-2019," you can follow these steps:

1. Select the date field in the Crystal Cross Tab report.

2. Right-click on the date field and choose "Format Field."

3. In the "Format Editor" window, go to the "Date" tab.

4. In the "Date Format" section, select the custom date format option.

5. Enter the date format as "MMM-yyyy" (MMM for abbreviated month name and yyyy for 4-digit year).

6. Click OK to apply the changes.

By setting the date format to "MMM-yyyy," Crystal Reports should display the date column as "Apr-2019" instead of "04/2019" in your Cross Tab report.

If you encounter any issues or need further assistance, feel free to provide more details, and I'd be happy to help further.