I have a problem that I hope I can explain it well. Im am using CR10 and a ODBC[RDO} connection. The report is based off of the theory that if someone is issued a tag by mail then they are charged a fee of $2.50. If a tag is not issued to them by mail then they are charged just $1.00. But within the data coming down from the database, there are instances where there was a tag issued by mail, but the customer was charged $1.00. And there are cases as well where there was not a tag issued by mail, but the customer was charged $2.50. The data coming in from the database is correct, I have already checked that portion of the program. The problem that I am having is that there are three different conditions that must be met within the same program. I have all of the conditions met and getting the right totals, but the problem lies in all of the conditions being displayed at same time on the report in the correct places when certain conditions are met. Here is an example of how the report is suppose to run.....
(cnt of tag type)(tag type)(mailfee) (Y or N) (mailfee Tot.)
----------------------------------------------------------
(cnt of $1.00 fee) (tag type) ($1.00) ($1.00 Total)
(cnt of $2.50 fee) (tag type) ($2.50) ($2.50 Total)
----------------------------------------------------------
(total cnt) (Total of fees)
This is the design layout of the program. The preview looks like this with numbers.......
Example 1
1 1P $1.00 N $1.00
4 1P $2.50 Y $10.00
-----------------------------------------------------
1 1P $1.00 $1.00
0 1P $2.50 $10.00
-----------------------------------------------------
1 1P TOTAL $11.00
This is the way the report looks when the conditions are simple. But there are conditions that are not as simple that is causing the problem. Like......
Example 2
2 1P $1.00 Y $2.00
4 1P $1.00 N $4.00
-----------------------------------------------------
6 1P $1.00 $6.00
0 1P $2.50 $0.00
-----------------------------------------------------
6 1P $6.00
There is also another complicated scenerio in which there was not a tag mailed, but there is a charge of $2.50 anyway like...
Example 3
4 1P $2.50 N $10.00
2 1P $2.50 Y $5.00
-----------------------------------------------------
0 1P $1.00 $0.00
6 1P $2.50 $15.00
-----------------------------------------------------
6 1P $15.00
I have all of the correct numbers and results figured within the program, but the problem i am running into is applying them correctly in the program. For instance, when i get the the correct totals in example 1 correct, it throws off the totals in Example 2 and 3. When I get the correct totals in Example 3 it throws off the totals in example 1 and 2. And when I get the correct totals in example 2 it throws off the totals in 1 and 3. Can someone please help. If you need more clarity please let me know and I can try to clarify a little better.
Thanx in advance guys!
(cnt of tag type)(tag type)(mailfee) (Y or N) (mailfee Tot.)
----------------------------------------------------------
(cnt of $1.00 fee) (tag type) ($1.00) ($1.00 Total)
(cnt of $2.50 fee) (tag type) ($2.50) ($2.50 Total)
----------------------------------------------------------
(total cnt) (Total of fees)
This is the design layout of the program. The preview looks like this with numbers.......
Example 1
1 1P $1.00 N $1.00
4 1P $2.50 Y $10.00
-----------------------------------------------------
1 1P $1.00 $1.00
0 1P $2.50 $10.00
-----------------------------------------------------
1 1P TOTAL $11.00
This is the way the report looks when the conditions are simple. But there are conditions that are not as simple that is causing the problem. Like......
Example 2
2 1P $1.00 Y $2.00
4 1P $1.00 N $4.00
-----------------------------------------------------
6 1P $1.00 $6.00
0 1P $2.50 $0.00
-----------------------------------------------------
6 1P $6.00
There is also another complicated scenerio in which there was not a tag mailed, but there is a charge of $2.50 anyway like...
Example 3
4 1P $2.50 N $10.00
2 1P $2.50 Y $5.00
-----------------------------------------------------
0 1P $1.00 $0.00
6 1P $2.50 $15.00
-----------------------------------------------------
6 1P $15.00
I have all of the correct numbers and results figured within the program, but the problem i am running into is applying them correctly in the program. For instance, when i get the the correct totals in example 1 correct, it throws off the totals in Example 2 and 3. When I get the correct totals in Example 3 it throws off the totals in example 1 and 2. And when I get the correct totals in example 2 it throws off the totals in 1 and 3. Can someone please help. If you need more clarity please let me know and I can try to clarify a little better.
Thanx in advance guys!
![[profile]](/data/assets/smilies/profile.gif "[profile] [profile]")