Adding Non ODBC Columns to an ODBC Cross-Tab Report

[marabou]

I wondered if anyone could help me out with this.

I need to add columns to a cross tab report which is using data from Oracle 8i. However these fields are not within the database and it seems that you cannot add formula fields as columns in Crystal 8.

Also, I wondered if it was possible to have two lines for the report columns. One where the data is grouped into months, and underneath that the Count of Sales, Cancellations and Net (the latter being the field which is not in the DB).

EG.
(line1) | JANUARY | FEBRUARY |
(line2) |Sales|Cancels|Net|Sales|Cancels|Net|
(data) | 4 | 2 | 2 | 7 | 2 | 5 |


Thanks in advance

 

[kenhamady]

You can't add formula columns to a cross-tab at all. You can use a formula field as a cross-tab Row/Column or summarized field. However, you can't use the cells of a cross-tab as input for a forumla. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)

 

[marabou]

Thanks for the info, I will have to try something else instead

 

[kenhamady]

One option is to build a pseudo cross-tab using conditional formula fields for colums, and then group for the rows.

With this technique you can write formulas with your columns. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)

 

[marabou]

Thanks, I will try that