Created formulas not displaying in Cross-Tab Report Wizard

[aszejna]

Hi Team,

I'm using the report wizard to create a cross tab report and I'm having trouble getting newly created formulas to appear in the box which lists all the report/database fields.

When I create a formula, based on a base table for example, the formula appears and I can drag and drop it into the summary/detail part of the cross tab report and the formula field is displayed in the cross tab report.

When I create a formula that is based on another formula however, the newly created formula does not appear as a valid field for me to use in my cross tab report (it simply does not display).

What I'm trying to accomplish is to basically derive a percentage in the cross tab report, ie: (displayed_value/sum(all_displayed_values)) * 100.

I've read a previous thread that I can use something like this: Sum({table.type}, {table.hours}) % Sum({table.type}) - I haven't tried this yet and I will (hopefully it's what I'm after), but I'm just wondering why my created formula fields are not appearing as a valid field that I can drag and drop into my cross tab reports.

Many Thanks!!!


Arek

 

[kenhamady]

You can't do percentages in Cross-tabs, because an formula that uses a total is not eligible for a Cross-tab field.

If you don't mind hard-coding the columns you can create something like a cross-tab using a summary report with conditional columns. See my FAQ on common formulas, and look at #12 on Manual Cross-tabs. Ken Hamady

http://www.kenhamady.com/

On-site custom Crystal Reports Training and Consulting.
Quick Reference Guide to using Crystal in VB.