Skip to Content
avatar image
Former Member

Cross-tab - Repeat Row Name

How can I get the Row Names in a cross-tab to repeat on every record? This would be useful for users that export the report to Excel and want to use column filters.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Sep 03, 2008 at 04:44 PM

    Brent,

    If you create the same grouping in the report as you have for the crosstab rows then you can create a formula using the replicatestring function to accomplish this.

    For instance of the rows are based on Country and Region then create a formula similar to the following and replace the country field with the formula as the row field in the crosstab;

    replicatestring( + chr(13), distinctcount( , ) ) +

    This will replicate the country once for every region in that country with a carriage return at the end and adds an extra replication for the row total

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Graham Cunningham

      That was a good idea. Unfortunately, there are two issues. The first is that Crystal must have a bug and won't export the report to Excel when the first row name is suppressed. I get a not exported error. Second, if the cross-tab has more than one summarized field, I am still left with records w/o a row name.

  • Nov 04, 2009 at 04:23 PM

    Please re-post if this is still an issue

    Add comment
    10|10000 characters needed characters exceeded