Creating a Unique Column 1

[rwn]

The Criteria below is all based on a unique Order Number. I have 7 selection drop downs on a form that a user can select some or all of the 7 Tank Numbers and enter a unique Batch # for each Tank Number. For example: Order Number 12345
1st selection the user Selects Tank 1200 and its Batch Number is 2.
2nd selection the user Selects Tank 4000 and its Batch Number is 1.
3rd selection the user Selects Tank 5000 and its Batch Number is 3.
No more Tank Selection are required for this Order Number 12345.
For example: Order Number 6789
1st selection the user Selects Tank 3000 and its Batch Number is 2.
2nd selection the user Selects Tank 4000 and its Batch Number is 1.
3rd selection the user Selects Tank 1200 and its Batch Number is 2.
No more Tank Selection are required for this Order Number 6789.

So actually there are 4 Batches in Tank 1200 - 3 Batches in Tank 5000 - 3 Batches in Tank 3000 and 2 Batches in Tank 4000.

I need to be able to create a unique column for each Tank and show the corresponding Batch Number Totals for each Tank for that Order.

Thank you for your thoughts and advise!

 

[lbass]

You need to explain what fields you are working with. It appears you have a field {table.ordernumber}. Do you also have a field {table.tanknumber} that returns Tank 1200, Tank 3000, etc.? And it appears you have a field {table.batchnumber}.

You show an example of summarizing batches across orders and then say that you want to show the batches per order--two different things. Please clarify.

-LB

 

[rwn]

Sure, be glad to or is there a way to upload the report?

 

[rwn]

Here are the fields:

BatchesByTank.Tank1; Batch#1.
BatchesByTank.Tank2; Batch#2.
BatchesByTank.Tank3; Batch#3.
BatchesByTank.Tank4; Batch#4.
BatchesByTank.Tank5; Batch#5.
BatchesByTank.Tank6; Batch#6.
BatchesByTank.Tank7; Batch#7.


The BatchesbyTank.Tank(s) can be either one of these 4000; 1200VAC; 1200; 4000VAC; 4000; 5000 or 7500. So each Tank can be see more than once. The Batch# is the number that needs to total based on the specific column of Tank 1200 for example.


Then from my example above which is below;1st selection the user Selects Tank 1200 and its Batch Number is 2.
2nd selection the user Selects Tank 4000 and its Batch Number is 1.
3rd selection the user Selects Tank 5000 and its Batch Number is 3.
No more Tank Selection are required for this Order Number 12345.
For example: Order Number 6789
1st selection the user Selects Tank 3000 and its Batch Number is 2.
2nd selection the user Selects Tank 4000 and its Batch Number is 1.
3rd selection the user Selects Tank 1200 and its Batch Number is 2.
No more Tank Selection are required for this Order Number 6789.

 

[lbass]

Are you showing me 14 fields, or two fields, each with seven instances?

It might help to see a few rows of data as they would display if you placed them in the detail section.

-LB

 

[rwn]

Fields Below.
Group Header = BatchesByTank.LineNumber
Detail Section =
BatchesByTank.Order Number;
BatchesByTank.Tank1; BatchesByTank.Batch#1; BatchesByTank.Tank2; BatchesByTank.Batch#2; BatchesByTank.Tank3; BatchesByTank.Batch#3; BatchesByTank.Tank4; BatchesByTank.Batch#4; BatchesByTank.Tank5; BatchesByTank.Batch#5; BatchesByTank.Tank6; BatchesByTank.Batch#6; BatchesByTank.Tank7; BatchesByTank.Batch#7.

Need to Group Footer Total BatchesByTank.Batch#(s) by Line Number.
Each BatchesByTank.Tank 1 through 7 each have 7 instances that can be shown. They are: 1200 or 1200VAC or 3000 or 4000VAC or 4000 or 5000 or 7500. A Tank can have only one of these values shown for each Order Number. The other Tanks will have one of these value showing two. So if a Tank is selected more than once, as in 1200 is in Tank1 and Tank2 and Tank3, with the Batch # for each one being 1 per. Then the total for 1200 needs to be 3.

I hope this helps.

 

[lbass]

Sorry, I can't follow this.

-LB

 

[rwn]

I understand, it would have better for you to see the report. I did find the resolution. I created a unique formul for each Tank Line 7 formulas for each line with 7 lines for a total of 49 formulas. I was then able to show the data by tanks.