Creating reports and dashboards | Stimulsoft community forum

Hi...

Really hoping somebody can help.
I have a report connected to a SQLite datasource. I ahve a number of fields in the report.
I have added a text box to my report and I want to add two existing fields on the report together.

QUESTION: How can I add two existing fields together in a textbox on my report


eg:
textbox1 = {SQLitequery1.YetToSpend}
textbox2 = {SQLitequery1.TotalSpent}
textbox3 = ??????????

I have tried
- {textbox1 + textbox2} - Fails with error: Operator '+' is not defined for types 'Stimulsoft.Report.Components.StiText' and 'Stimulsoft.Report.Components.StiText'.
- {textbox1.value + textbox2.value} - Fails with error: 'value' is not a member of 'Stimulsoft.Report.Components.StiText'.


Thanks,
Rory

Hello,

Please try to use the following expression:
{SQLitequery1.YetToSpend + SQLitequery1.TotalSpent}

Thank you.

Hi Aleksey

I explained it poorly.

Is it possible to just refer to the textbox value and not have to refer again to the datafield that is populating the previous textbox.
Can I refer to the textbox2 value and not the {SQLitequery1.TotalSpent} field?


Thanks

Hello,

This is restriction of using named template components in report. During report rendering exist two instance of each component (minimum two instance). One instance - component in report template. Second instance - component which created for rendered report. During creation of second instance report engine calculate expressions and write it to second instance. When you write expression like this:
{Text1.Text}
you call instances from report template which does not contain calculated values from expressions.

You can:
1. Instead of "{Text1.TextValue}" expression use the same expression as in Text1.Text property, or
2. Use variables. In this case you can calculate value in variable, and then use this variable in expressions.

Thank you.

HI,
I tried to show a calculate field in a Databand. For this, I add two numeric fields ( Field1, Field 2) in the databand and a new text objet in the databand for calculate Field1 + Field 2
In the expression text objet I write the next expression and It does not work:

{ Datasource1.Amount1 + Datasource1.Amount2 }

This expression also fails:

{ Datasource1.Amount1 * 5 }

Could you document the possible expressions with string and numeric fields? It is not clear.

Thanks. We note a lot of improvements from 6 months ago

Notes:
Firebird 2.5 Database connection

Hello,

Please send us a simple report with test data which reproduces the issue for analysis.

Thank you.

I solved this problem when I realized that all fields in my datasource (Firebird 2.5) were all Strings. I edited the string fields to double and now it works. Now, the question is ...

Why php Stimulsoft does not keep fields types when you create the datasource? . It is a problem because we need always to remember to change all numerics fields in the datasource.

Thanks for the quick response.

Hello,

Could you explain your issue in more details?
Also, please clarify which version are you use?

Thank you.

Since the datasource that we connect to Firebird 2.5 returns all the fields in String format, when we design a databand with 2 fields, supposedly numeric, we can not perform calculations with them. Stimulsoft php forces us to edit in the datasource, the string fields to numerics (double).

Datasource1.Amount1 and Datasource1.Amount2 are StringField in the datasource. If you put a new text object and edit it with this expression. The report fails.
{ Datasource1.Amount1 + Datasource1.Amount2 }

But... if you edit this two fields to "double" in the Datasource , Report works fine.

Hello,

Please clarify which version are you use?

Thank you.