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

Eliana Blake · Answer

Hi there! In a Crystal Cross Tab report where columns are grouped by date on a monthly basis, you can customize the display format to show "04/2019" as "Apr-2019." This can be achieved by adjusting the date format settings in your Crystal Reports software. Here's a general overview of how you can modify the date format in Crystal Reports: 1. Open your Crystal Cross Tab report in design mode. 2. Locate the column that displays the dates (in this case, "04/2019"). 3. Right-click on the date column and select "Format Field" or navigate to the properties pane where you can find the date format settings. 4. Look for the date formatting options, which may include choosing a custom date format. 5. In the custom date format, you can specify the format you desire. For instance, you can use "MMM-yyyy" to display the month abbreviation followed by the year (e.g., "Apr-2019" for "04/2019"). By applying this customization to the date format settings, you should be able to transform the display from "04/2019" to "Apr-2019" within your Crystal Cross Tab report. I hope this helps you achieve the desired display format in your report! If you have any more questions or need further assistance, feel free to ask.

Column Display Format

Answers (1)