I have a cross tab report that is pulling orders from a DB with the following criterion:
"Estimated Book Date" that's between to specified dates OR
"Complete Date" that's between the same to specified dates.
The row is Estimated Book Date grouped by month. The summarized fields are “estimated revenue” for all of the orders. This field sums up all orders for that month but excludes the orders that are marked complete. The other summarized field is “actual revenue” which is a total of all orders with a complete date between the specified dates.
So, basically, I am retrieving date that would have two different dates, estimated book date and complete date, but need to have the estimated book dates be the rows but also include the information from the complete dates in a summarized field that’s within the same row. I’ve tried a formula on the row (if not {orders.complete} then {orders.estBookDate}). This doesn’t get a desired result as I have a row that doesn’t have a label but has numbers. I know this is happening because that row contains orders that have an estimated book date between the specified dates but also has a complete date which is a different month from the estimated book date. How can I prevent that blank row from showing up and put those numbers in the correct row?
Any ideas?
"Estimated Book Date" that's between to specified dates OR
"Complete Date" that's between the same to specified dates.
The row is Estimated Book Date grouped by month. The summarized fields are “estimated revenue” for all of the orders. This field sums up all orders for that month but excludes the orders that are marked complete. The other summarized field is “actual revenue” which is a total of all orders with a complete date between the specified dates.
So, basically, I am retrieving date that would have two different dates, estimated book date and complete date, but need to have the estimated book dates be the rows but also include the information from the complete dates in a summarized field that’s within the same row. I’ve tried a formula on the row (if not {orders.complete} then {orders.estBookDate}). This doesn’t get a desired result as I have a row that doesn’t have a label but has numbers. I know this is happening because that row contains orders that have an estimated book date between the specified dates but also has a complete date which is a different month from the estimated book date. How can I prevent that blank row from showing up and put those numbers in the correct row?
Any ideas?