Calculated Values in Text Boxes - Reports

  • Thread starter Thread starter John
  • Start date Start date
J

John

Hello,
I am desperately trying to generate calculations in a
report text box. Here is a simple version of what I am
attempting

I have generated a report with:
BowlGame Soda Food Cost
RoseBowl 2 3 X
FiestaBowl 5 7 y

I have other tables that are called RoseBowl and
FiestaBowl, respectively, which contain the individual
soda and food costs. I need to get the total cost X and
Y in my report based on the costs that are in each
individual table for the bowl games?
 
John said:
I am desperately trying to generate calculations in a
report text box. Here is a simple version of what I am
attempting

I have generated a report with:
BowlGame Soda Food Cost
RoseBowl 2 3 X
FiestaBowl 5 7 y

I have other tables that are called RoseBowl and
FiestaBowl, respectively, which contain the individual
soda and food costs. I need to get the total cost X and
Y in my report based on the costs that are in each
individual table for the bowl games?
Click to expand...


You're using the word table but in your example they seem
like fields in a table. If that's so, then the cost text
box can just use an expression like:

=Soda + Food

If you also want a grand total in a text box in the report
footer section, then this text box can use the expression:

=Sum(Soda + Food)
 
-----Original Message-----
You're using the word table but in your example they seem
like fields in a table. If that's so, then the cost text
box can just use an expression like:

=Soda + Food

If you also want a grand total in a text box in the report
footer section, then this text box can use the expression:

=Sum(Soda + Food)
Click to expand...
Thanks Marsh,
I think I was unclear. But, when I say tables, i meant
tables. There are tables that have a bunch of
information. One for each bowl game. In these tables is
the actual cost of a food and soda item. The costs are
different per bowl game and therefore need to be
calculated seperately in this one report. So, the
trouble for me is referencing these other tables in the
one report that has the example info I list above.
Please let me know if this question makes more sense.
Regards,
John
 
John said:
I think I was unclear. But, when I say tables, i meant
tables. There are tables that have a bunch of
information. One for each bowl game. In these tables is
the actual cost of a food and soda item. The costs are
different per bowl game and therefore need to be
calculated seperately in this one report. So, the
trouble for me is referencing these other tables in the
one report that has the example info I list above.
Please let me know if this question makes more sense.
Click to expand...


I'm sorry, but I'm afraid that I'm even more confused now.
This sounds like you have a separate table for each game,
but these tables only have one record, which would be an
extremely illogical data structure. Even if I've missed the
boat with this interpretation, you have definitely violated
the rules of normalization. The problem you originally
asked about is almost certainly caused by keeping this data
in separate tables instead of using a single table that
includes a field to indicate the game.
 
Back
Top