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

Jignesh Kumar · Answer

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:

Joel Wright · Answer

Hello Ramco, @Doodle Baseball Please submit specific images in the Crystal Cross Tab report.

Sophia Carter · Answer

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.

Column Display Format

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (3)