How to repeat group values in a cross-tab.
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.
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.
ASKER
Thanks for the reply.
I would add, that whilst it may be simple to split the fields, or manuually fill the missing data, in Excel. This report / procedure will be undertaken several times a day, every day, so performing any manual tasks will very soon become extremely tedious. Hence me trying to find a way to do this without forcing the end user to perform any manual tasks.
I would add, that whilst it may be simple to split the fields, or manuually fill the missing data, in Excel. This report / procedure will be undertaken several times a day, every day, so performing any manual tasks will very soon become extremely tedious. Hence me trying to find a way to do this without forcing the end user to perform any manual tasks.
Is the report just the cross tab?
Does it expand horizontally?
Have you tried using a manual cross tab?
mlmcc
Does it expand horizontally?
Have you tried using a manual cross tab?
mlmcc
ASKER
Hi, Yes the report contains just the cross-tab, apart from the usual header, footer, logo etc.
No the width is fixed, there are four summaries per row, and this is fixed.
What do you mean by a manual cross-tab? I wasn;t aware in Crystal Reports that there is more than one type of cross-tab.
No the width is fixed, there are four summaries per row, and this is fixed.
What do you mean by a manual cross-tab? I wasn;t aware in Crystal Reports that there is more than one type of cross-tab.
A "manual" cross tab is really just a report but you suppress the details and show the group footers for the data.
mlmcc
mlmcc
ASKER
OK, never thought of the manual cross-tab, will have alook at that.
Thanks
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
In my case, as the columns were fixed in the horizontal plane, using a PIVOT in the original SQL worked well for me.
Although I am not sure it would work well in all situations.
I do no know why SAP do not simply put a tick box of whether to hide the duplicate values, there appear to many requests for this feature on the web.
Although I am not sure it would work well in all situations.
I do no know why SAP do not simply put a tick box of whether to hide the duplicate values, there appear to many requests for this feature on the web.
Sorry I missed the link for dynamic pivot table:http://www.simple-talk.com/blogs/2007/09/14/pivots-with-dynamic-columns-in-sql-server-2005/
You don't need this example if the columns are fixed, but it might be useful for other scenarios
You don't need this example if the columns are fixed, but it might be useful for other scenarios
But I would have thought that for an Excel user it would be a simple step to split the columns up again.