I am building a report that shows the details of every order we have processed in a month.
In addition to the cost of each item, there is a "processing fee" of $1.50.
This flat fee gets charged on every order, regardless of the contents of the order.
The order details come from a single flat file, but the processing fee is *not* part of the flat file.
In Crystal Reports, I created a formula that simply contains:
If I drag that formula onto the Group Header, it shows up as $1.50
Now ... in the Report Footer, I want a grand total of processing fees.
When I place a Summary field into the report footer, this field (proceFee) does not appear in the list of fields to choose from.
I thought maybe Crystal Reports doesn't know this constant is formatted as a number, so I modified the formula to say "numberVar x := 5;"
Still no luck.
How can I calculate the sum of all processing fees when the processing fee is not part of the data?
I really don't want to add this field to the data file because I will have to do that each month when the new data file arrives.