Add values from multiple text boxes

[HighAley]

Hello.

Sorry, there is no Inventory2000Data.mdb so we can't render your report. But we will try to guess.

Please, try to create a variables (TotalSum) and use next expression:

Code: Select all

{TotalSum += Sum (round(Parts.SqInch*(Parts.InvParts.Cost*Parts.InvParts.WASTE),2))}

After this you should show the value of the TotalSum variable.

If you still need our help, please, send us all necessary data for your report template.

Thank you.

[jrSD]

AAACCCKKKKKk!! I still am not getting it. The first attachment I posted in the thread has the mdb database included in the compressed file. I am submitting it again.
"TotalSum" would be the name of the variable. I get that, and if I make the value a hard number, the variable worked correctly, though when I add the code:
{TotalSum += Sum (round(Parts.SqInch*(Parts.InvParts.Cost*Parts.InvParts.WASTE),2))}
as the value or expression, I come up with errors.

I will be so grateful for additional help.

[Alex K.]

Hello,

Please check the modified report in the attachment.

Thank you.

[jrSD]

THANK YOU VERY MUCH!!!!

[Alex K.]

Hello

We are always glad to help you!
Let us know if you need any additional help.

Thank you.

[shiva]

Can you please explain how you did it, I am struggling to do the following.
I have calculated a summary value in a footer band for a group based on a condition of a column value, I want to use this value further in the same band and add and subtract values calculated in other fields. Is it possible?

[Lech Kulikowski]

Hello,

You can use variables for calculations and then use it in necessary expressions.

Thank you.

[shiva]

Can you give a simple example where a variable stores the summary value with if condition and is stored in a variable, it gives me some error to parse. Can I use a simple + or - to add and subtract this derived value to another column using the variable. A screenshot will be helpful.
Thanks,

[shiva]

To elaborate further I put this in the variable
SumIf (Datasetname.column name, Datasetname.columnname1 == true) +Datasetname.columnname3...how do I refer to name of the databand, it gives me errors like not accepting the number of arguments etc. please advise.

[Lech Kulikowski]

Hello,

You should use the data source name or use the following expression in the text expression:

If the issue still present, please send us a sample report with test data which reproduces the issue for analysis.

Thank you.