Creating reports and dashboards | Stimulsoft community forum

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:
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.

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.

Hello,

Please check the modified report in the attachment.

Thank you.

THANK YOU VERY MUCH!!!!

Hello

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

Thank you.

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?

Hello,

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

Thank you.

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,

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.

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.