ericfmyers
Technical User
I have a multi table report and all was fine in the details until I added in one last table. The main table is set like so:
Container
{Container.ContainerNumber}
{Container.CustomerName}
{Container.ProductID}
{Container.QTY}
The details are grouped by {Container.CustomerName} then by {Container.ContainerNumber}. The details list the {Container.ProductID} and {Container.QTY}. The {Container.QTY} is then summed up for each group.
On the report it looks like this:
CustomerName ABC123
Container Number 12345
Product ID QTY
_test1_ 1
_test2_ 2
Sub total 3
Container Number 12346
Product ID QTY
_test3_ 1
_test4_ 2
Sub total 3
Total 6
This all works fine until I add in the next table:
User
{User.ContainerNumber}
{User.ProductID}
{User.UserName}
{User.Date}
They are linked by ContainerNumber. But the User Table has multiple instances for each {User.ProductID} so it messes up the QTY like so:
CustomerName ABC123
Container Number 12345
Product ID QTY User
_test1_ 1 Bob
_test1_ 1 Ted
_test2_ 2
Sub total 4
Container Number 12346
Product ID QTY User
_test3_ 1
_test4_ 2 Mary
_test4_ 2 Ted
Sub total 5
Total 9
I don't really need the User's name I just want to know if someone is on it or not. So I could use a True/False statement for that. I know I could add another group but then it still messes up my totals at the end. Is there a way to keep the details to a number that matches the original table? Is there a link option that would accomplish this?
Thanks.
Container
{Container.ContainerNumber}
{Container.CustomerName}
{Container.ProductID}
{Container.QTY}
The details are grouped by {Container.CustomerName} then by {Container.ContainerNumber}. The details list the {Container.ProductID} and {Container.QTY}. The {Container.QTY} is then summed up for each group.
On the report it looks like this:
CustomerName ABC123
Container Number 12345
Product ID QTY
_test1_ 1
_test2_ 2
Sub total 3
Container Number 12346
Product ID QTY
_test3_ 1
_test4_ 2
Sub total 3
Total 6
This all works fine until I add in the next table:
User
{User.ContainerNumber}
{User.ProductID}
{User.UserName}
{User.Date}
They are linked by ContainerNumber. But the User Table has multiple instances for each {User.ProductID} so it messes up the QTY like so:
CustomerName ABC123
Container Number 12345
Product ID QTY User
_test1_ 1 Bob
_test1_ 1 Ted
_test2_ 2
Sub total 4
Container Number 12346
Product ID QTY User
_test3_ 1
_test4_ 2 Mary
_test4_ 2 Ted
Sub total 5
Total 9
I don't really need the User's name I just want to know if someone is on it or not. So I could use a True/False statement for that. I know I could add another group but then it still messes up my totals at the end. Is there a way to keep the details to a number that matches the original table? Is there a link option that would accomplish this?
Thanks.