Crystal report Cross tab

Question

Hi In Crystal Tab Report i am displaying Account code in Rows. But i want to display Account name with it also. But both in separate columns Thanks

Daniel Wright · Answer

Hello! It's great to hear about your interest in Crystal report Cross tab functionality. It seems like you have a specific requirement regarding displaying Account code and Account name in separate columns within your Cross tab report. To achieve this in Crystal Reports Cross tab, you can follow these steps: 1. Ensure that your Cross tab report is already displaying the Account code in rows. 2. Add a new column in the Cross tab to display the Account name. You can do this by inserting a new Cross tab column. 3. Edit the formula for the new column to show the corresponding Account name based on the Account code. You can use a formula to look up the Account name based on the Account code. Here's a simplified example of how you can achieve this in a Crystal report Cross tab: // Create a formula to display the Account name based on the Account code // Assuming you have a dataset with AccountCode and AccountName fields StringVar AccountName; if {YourDataset.AccountCode} = "123" then AccountName := "Account Name 1" else if {YourDataset.AccountCode} = "456" then AccountName := "Account Name 2" else AccountName := "Other Account"; AccountName By using a formula like the one above in a new column in your Cross tab, you can display the Account name alongside the Account code. I hope this helps you achieve the desired layout in your Crystal report Cross tab. If you have any more questions or need further clarification, feel free to ask!