Reference to a textoitem doesn't work

[sector7g]

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

[Edward]

Hi Ralf,

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

Thank you.

[sector7g]

Just sent it.

Happy new year
Ralf

[Edward]

Hi Ralf,

Thank you for your Email.

Please try the following expression:

Totals.Sum(DataBand1,PurchInvoice_GroupedItems.Amount)

Happy New Year!

Thank you.

[sector7g]

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

[Andrew]

Hello,

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

Thank you.

[sector7g]

Hi,

anything new about this topic?

regards Ralf

[Edward]

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.