Skip to Content
0

Cross tab rows are not repeating

Oct 26, 2017 at 04:03 PM

28

avatar image
Former Member

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

avy6f.png (64.7 kB)
hqrro.png (10.6 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Abhilash Kumar
Oct 27, 2017 at 06:47 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Oct 26, 2017 at 08:25 PM
0

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

Show 3 Share
10 |10000 characters needed characters left characters exceeded
Former Member

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?

xjgmp.png (19.8 kB)
0
Former Member

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.

Field Object Control

Regards,

Anish

0
Former Member

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

0