Crystal Report Cross Tab Report

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!

1 Reply

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

Emily Foster1y ago
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!
0