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!

Crystal report Cross tab

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (1)