Crystal Report Cross Tab Report

Question

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

Emily Foster · Answer

Hi there! It's great to hear that you're working with Crystal Reports Cross Tab Report. To display the Account name alongside the Account code in the rows of your report, you can use a feature called "Concatenation" in Crystal Reports. To achieve this, you can create a formula field that combines the Account code and Account name together. Here's a simple example of how you can do this: 1. Open your Crystal Report. 2. Go to the "Field Explorer" pane. 3. Right-click on "Formula Fields" and select "New." 4. Give your formula field a name, for example, "AccountCodeAndName." 5. In the formula editor, enter the following formula: {YourTableName.AccountCodeField} & " - " & {YourTableName.AccountNameField} Make sure to replace `"YourTableName"` with the actual name of your table and `"AccountCodeField"` and `"AccountNameField"` with the respective field names. 6. Save the formula and place it in the row section of your Cross Tab Report. By following these steps, you should now see the Account code and Account name displayed together in the rows of your Cross Tab Report. This approach helps provide more context and clarity to the data being presented. I hope this explanation helps you achieve the desired outcome in your Crystal Report. If you have any more questions or need further assistance, feel free to ask!

Crystal Report Cross Tab Report

Answers (1)