Hello,

I'm trying to get a report to give me our sales orders based on the category of the order and also based on the parts inside the order.

Orders are places into categories based on what products they are associated with. Categories A, B and C. Parts are also placed into categories based on what products they belong in. Also Categories A, B and C.

I want the report to give me results on all orders in the C category and all orders that contain C parts (but are not in the C category for the order) I have a formula in the report record field saying something like this:

{Table.OrderLabel} = "C" or
{Table.PartLabel} = "C".

This is correctly giving me all orders in the C category.  It is not correctly giving me the results for orders not in the C category but have C labeled parts.

It WILL list the orders that contain C parts, but it will completely void out any other parts associated with that order. It will only show the C parts, giving me wrong net dollars since there should be more parts listed within that order.

I hope my explanation makes sense. I'm sure there is a way to do this, i just can't figure it out :(

Thank you,
Steve

Thank you Ryan. You did understand my explanation perfectly.

I'm not fully understanding the problem;

Edited by rkrowland - 01 Feb 2012 at 5:56am

Thanks again guys. And yes Ryan, I had meant Group 1 was being miscalculated.

I think you need some more parenth and always use the isnull condition first

Edited by DBlank - 02 Feb 2012 at 6:18am