Creating reports and dashboards | Stimulsoft community forum

Hi,

The following do work with version 2008.3.313 from 01.12.2008 but not with the current version 2010.1 from 28.12.2009:

I have several bands in my report and 2 pages. On the first page I show a textitem with a sum in it.
Like: Sum(PurchInvoice_GroupedItems.Amount)
I named it "Teilsumme".

On the second page I try to calculate with this item:
Sum(PurchInvoice_OtherItems.Amount)+
(TryDecimalParse(Teilsumme.Text)?decimal.Parse(Teilsumme.Text):0)

With the new version 20010.1 "Teilsumme" is empty.
With the old version 2008.3 "Teilsumme" contains the correct value.

If I try to use the sum direct (like Sum(PurchInvoice_OtherItems.Amount)+Sum(PurchInvoice_GroupedItems.Amount))
the value of Sum(PurchInvoice_GroupedItems.Amount) is doubled.

I hope you understand my problem.


What I also recognize in the new version is: If I doubleclick on a item it takes 5 seconds to open the dialog. The old version was much faster (1-2 sec).


Best regards
Ralf

Hi Ralf,

Could you please send us a sample report template and if possible data for it as well?

Thank you.

Just sent it.

Happy new year
Ralf

Hi Ralf,

Thank you for your Email.

Please try the following expression:

Totals.Sum(DataBand1,PurchInvoice_GroupedItems.Amount)

Happy New Year!

Thank you.

Thank you Edward for the hint.

I tested it right now and came to another problem:

In my databand I had set a filter. So Totals.Sum(...) doesn't work here.
So I tried SumIf. But this doesn't work either.

My expression now:

{(Totals.Sum([Purchase.Business.PurchInvoice_TattooGroupList],[Purchase.Business.PurchInvoice_TattooGroupList].Count) != 0) ?
SumIf([Purchase.Business.PurchInvoice_Pos],[Purchase.Business.PurchInvoice_Pos].Amount,[Purchase.Business.PurchInvoice_Pos].KindOfCostId == 2)/
Totals.Sum([Purchase.Business.PurchInvoice_TattooGroupList],[Purchase.Business.PurchInvoice_TattooGroupList].Count):0}

Any ideas?

For me using the reference to the textitems was the intuitiv way.
Why doesn't work that anymore or why can I change the names or give them an alias if I don't can use them?

best regards Ralf

Hello,

We need some time to check the issue and find the answer.

Thank you.

Hi,

anything new about this topic?

regards Ralf

Hi Ralf,

Obviously expression with a DataBand will not work inside of the databand's filter. Please consider using sum by all datasource in the filter's expression:

Totals.Sum(PurchInvoice_GroupedItems,PurchInvoice_GroupedItems.Amount)

It will definitely work inside of the Filter expression.

Thank you.