on 09-03-2008 3:59 PM
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.
Please re-post if this is still an issue
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Graham,
I tried your suggestion and it almost worked. Viewing on the screen in Crystal, it did display the row name repeated the correct number of times. However, they didn't quite line up.
The main problem though was when exported to Excel (Data Only), It placed row names concantenated together all on one row next to the total for each.
When exported to regular Excel, it placed them all in one merged box.
So, unfortunately either way the user would not be able to use Excel to filter.
Brent,
This might look a little cloogy in the report but you could reverse the row fields. For instance if you had Country and Region then have the region as the first row and country as second. You could in fact add the country as the row field 2x in the first and 3 position to get the correct subtotals and then suppress the first row name field.
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.
User | Count |
---|---|
85 | |
10 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.