Jump to content

Summary fields in sub summary part


NewFM85User
 Share

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

Recommended Posts

Hi,

I have 2 tables. Orders table and Template table. Orders are created every issue from template table.

But the customers can modify the order for that issue. Both these tables are related by issue ID.

I want to create the the report to campare the total count of actual order of booklets every issue Vs the count of booklets customers are supposed to order.

When I place the summary fields from both the tables in sub summary part on the report, it shows the total for just one table, the other subtotal is the total of last order.

How can I get the subtotals of both the fields?

Please advise.

Thanks for your help.

Link to comment
Share on other sites

These parts are not clear:

Orders are created every issue from template table.

What does a record in the Template table represent?

Both these tables are related by issue ID.

Is there a table of Issues?

the count of booklets customers are supposed to order.

Which would be where?

Link to comment
Share on other sites

This topic is 4344 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.