Crystal Cross Tab Report

Hello! It's great to see your interest in Crystal Cross Tab Reports.

In Crystal Reports, when you set up a Cross Tab Report with row grouping based on the "Itemcode," it is indeed possible to display another field like "Description" in the adjacent column. Here's how you can achieve this:

1. Adding the Description Field: You can add the "Description" field as a summarized field in your cross-tab report. This can be done by including the "Description" field in the Details section of your report and then summarizing it in the cross-tab by placing it in the summarized fields area.

2. Setting up the Cross-Tab: Ensure that the "Itemcode" is in the row grouping and that the "Description" field is placed in the next column in the cross-tab layout. You may need to adjust the cross-tab settings to ensure the data is presented as desired.

3. Formatting: Once you have added the "Description" field to the cross-tab report, you can format the column as needed to display the descriptions effectively alongside the corresponding item codes.

By following these steps, you should be able to include the "Description" field next to the "Itemcode" in your Crystal Cross Tab Report. If you encounter any specific challenges or need further assistance with the setup, feel free to provide more details, and I'll be happy to help further. Best of luck with your report customization!

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Ramco Ramco1y ago
Hi Foster

Can you elaborate further. Any video or showing GUI to do the same thing

Thanks
0
Emily Foster1y ago
Hello! It's great to see your interest in Crystal Cross Tab Reports.

In Crystal Reports, when you set up a Cross Tab Report with row grouping based on the "Itemcode," it is indeed possible to display another field like "Description" in the adjacent column. Here's how you can achieve this:

1. Adding the Description Field: You can add the "Description" field as a summarized field in your cross-tab report. This can be done by including the "Description" field in the Details section of your report and then summarizing it in the cross-tab by placing it in the summarized fields area.

2. Setting up the Cross-Tab: Ensure that the "Itemcode" is in the row grouping and that the "Description" field is placed in the next column in the cross-tab layout. You may need to adjust the cross-tab settings to ensure the data is presented as desired.

3. Formatting: Once you have added the "Description" field to the cross-tab report, you can format the column as needed to display the descriptions effectively alongside the corresponding item codes.

By following these steps, you should be able to include the "Description" field next to the "Itemcode" in your Crystal Cross Tab Report. If you encounter any specific challenges or need further assistance with the setup, feel free to provide more details, and I'll be happy to help further. Best of luck with your report customization!
0