Skip to Content

Cross tab rows are not repeating

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Oct 27, 2017 at 06:47 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 26, 2017 at 08:25 PM

    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

    Add comment
    10|10000 characters needed characters exceeded