Cross tab rows are not repeating

[former_member440205]

Hi All,

I have a crosstab question, where I want to show both rows for column A. Instead in current report only show column A once, column B and C both shows twice. Any feedback greatly appreciated!

Thanks,

Frankie

[abhilash_kumar]

Hi Frankie,

Here's what you need to do:

1. Create a formula with this code:

{ColumnA} & {ColumnB}

//Replace Column A and Column B in the formula above with the actual database field names.

2. Replace the existing field in Row#1 of the Crosstab with this formula field

3. Highlight this Row field and click 'Group Options' > Options tab > Check 'Customize Group Name Field' > Choose from Existing Field > Select Column A from the drop-down (or whichever is the correct database field for Column A) and click OK.

-Abhilash

[former_member182342]

Hi Frankie,

Please go to the Format Result object Element property of the column A. -> General -> hide and hide if duplicate property whether it is check or uncheck,

Please let me know if you still face an issue then share the crystal report screenshot.

Regards,

Anish

[former_member440205]

Hi Anish,

Cross tab - Can tell me where about to locate "Format Result object Element property? I'm using crystal report 2008. are you referring to below?

[former_member182342]

Hi Frankie,

Just select the column A from Crosstab and right click in the structure mode. There you can find the Format Result object Element property and check the General -> hide and hide if duplicate property.

Regards,

Anish

[former_member440205]

I think it's the version that Im using which is 2008. Not seeing "Format Result Object Element" anywhere.