How to Add a Derived Column To Existing CR

[JohnBates]

Hi Crystal experts,

I have a simple report that displays columns for Qty Ordered and Qty Shipped.

I want to add a new column called Net Qty. I suppose it will require a formula to compute (Qty Ordered minus Qty Shipped).

This should be so easy, but I can't seem to find how to insert a new column.

Can anyone help me ? I'm using Version 8.

Thanks alot,
John

 

[IdoMillet]

Insert, Field Object, Formula Fields...

Cheers,
- Ido CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[synapsevampire]

You can also do this using SQL Expressions.

In SQL Server it would look like:

{table.Qty Ordered} + {table.Qty Shipped}

This will place the processing on the database, improving performance.

Now you can place that SQL Expression field anyplace on the report, and use it in aggreates (sums, etc).

-k