Hey Anthony,
Thanks for buying my books and supporting the forum! If more people followed your lead, I could afford to spend more time creating great content for this site.
Click here for more information on the
Crystal Reports EncyclopediaRe your question, this is pretty techinical and can be a bit tough to answer over a forum. When you get the book from Amazon, check out the Advanced Tutorials starting on page 497. They will give you lots of good tricks for customizing cross-tabs.
For a cross-tab to have different data on each row, you need a formula to identify each row and which metric it gets. Here is an example formula caled {@MetricType}:
If {field}="type1" Then
"abc"
Else
"xyz";
This categorizes each row and also gives it a label that can be displayed in the cross-tab.
Second, you need to use this formula to determine which metric to calculate for a row. Something like this:
EvaluateAfter({@MetricType});
If {@MetricType}="abc" Then
X*12
Else
X/2;
Of course, use formulas that are applicable to your situation. In the cross-tab report, put the {@FormulaType} formula in the Rows area and put the metric calculation in the Columns area.
Play around with these ideas and see if it gets you what you need.