Jump to content

SubSummary with Repeating fields


Scott Pon

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

Recommended Posts

I have a order entry database. The original programmer (a long long time ago, in a galexy far far away...) decided to use repeating fields (see another universe). One of the repeating fields is a part number.

The objective is to write a report that will give the count of orders that use that part number.

I have a field "Count of Orders" that is a summary count on "sales order numbers"

I create a layout that shows the part number and order number. Then I have a Trailing grand summary that has the count.

However that will only count the found records. So I tried to use the "subsummary when sorted by:" Part Number but that did not show ANY Counts. Did I do that wrong? Could the repeating field be screwing this count up?

Thanks.

Scott

Link to comment
Share on other sites

This topic is 7215 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
×
×
  • Create New...

Important Information

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