Column names based on Summarised fields in Crystal
Posted on 2009-07-09
I'm new to Crystal Reports and am trying to convert previous pivot tables compiled in Excel into Crystal to automate reporting processes. However, I have come across an issue that is proving a bit of a "show stopper"!
One Excel pivot I produce shows how student's fees and subsequent invoiced amounts are totalled by cost centre and fee type, it looks like this::
Row Sum of Fees Sum of Invoiced Sum of Fees Sum of Invoiced
COST CENTRE £x.xx £x.xx £x.xx £x.xx
I have created a crosstab in Crystal (Report Footer section) and placed all data into the Design section. The nearest equivalent crosstab I can compile in Crystal looks like this:
Row Exam Tuition
COST CENTRE £x.xx £x.xx
It does not state which figure is "Fees" and which one is "Invoiced" and doesn't make figures go across the page as I wish them to. I have exhausted efforts in trying to change this using crosstab formatting options in Crystal hence this post. Is it at all possible to replicate the Excel layout above in Crystal?