I have a cross-tab in my report.
In the row selection the are two values, Date and Code. Because I have selected the two row values, Crystal has automatically grouped on Date. The result being the date is only shown once when the value changes.
We need to export this report to Excel for further analysis, so we need all the values in all the rows to be displayed.
I cannot see any tick box to allow this, so I guess if it is possible, it will required some formula.
I toyed with the idea of concatenating the two values into a single value so we only have one row value, but we need the values seperated in the exported file for the analysis to work.
I have noticed lots of people of the net have asked the same question, but I have not been able to find a workable solution.
We are using CR 2008 and Crystal for VS2010, but niether seem to have a solution.
Any an dall help would be greatly appreciated.