Jump to content

Filter across two tables for report


Devin
 Share

This topic is 2323 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I'm needing to do a sub summary report.

I've got for this example two Tables.. Orders and Lineitems.

In the Orders Table their is 

orderID and status.b

and the lineItems has orderID, sku, qty.

With a relationship between the two Tables that match "orderID".

The status.b is number filed that will contain a 0, 1 or 2. Deepening on the status of that order.

 

What I want to do is build a report that gives me a sub summary of all the sku items and the qty sum of only the records were the status.b = 0 in the table Orders.

I can build the report now but getting the filtering to work is where I'm stuck. 

 

Thanks

Link to comment
Share on other sites

This topic is 2323 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.