Issue with total using Matrix

Riddick61 · February 2020

https://forum.fast-report.com/en/uploads/658/4PTTGXLIVO55.png

I am using Designer of FastReport.Net and as source I use an xsd where the columns that I added to the matrix are defined as decimal type just like this:

<xs:element name="Importo_x0020_capitale_x0020_2" type="xs:decimal" id="T8-14" nillable="true"/>

and yet the total by column is just a concatenation between 2 string as you can see in the pic attached here.

(200 + 300 = 200300 and not 500)

I had the same issue with total by row but here I solved doing a convert to Int32 as Anatoly suggested but here I do not know how to solve this.

Thanks in advance.

Anatoly · February 2020

Can you send your data? I will check it and try to solve your problem.

Riddick61 · February 2020

Hi Anatoly,

In this xsd all field are typed, some as string and some as decimal.

From this xsd I created an xml file with dummy values just to create the datasource XML database.

In a console app in c#, I injected the data into the report in this way:

// "Garanzia" "T8"

var drGaranzia = ds.Tables[8].NewRow();

drGaranzia[4] = "MORTE";

// "Importo capitale 1" type="xs:decimal" "T8-13"

drGaranzia[13] = 150000D;

// "Importo capitale 2" type="xs:decimal" "T8-14"

drGaranzia[14] = 20000D;

// "Importo tasse annuo" type="xs:decimal" "T8-11"

drGaranzia[11] = 400D;

ds.Tables[8].Rows.Add(drGaranzia);

var drGaranzia2 = ds.Tables[8].NewRow();

drGaranzia2[4] = "INVALIDITA' PERMAMENTE";

// "Importo capitale 1" type="xs:decimal" "T8-13"

drGaranzia2[13] = 350000D;

// "Importo capitale 2" type="xs:decimal" "T8-14"

drGaranzia2[14] = 40000D;

// "Importo tasse annuo" type="xs:decimal" "T8-11"

drGaranzia2[11] = 600D;

ds.Tables[8].Rows.Add(drGaranzia2);

rep.Load(@"C:\Prove su FastReport\ModuliContraentePolizza.frx");

rep.RegisterData(ds);

rep.Prepare();

simpleExport.Export(rep, @"c:\Prove su FastReport\ModuliContraentePolizza.pdf");

This works as you've seen in the previous email (attached pic where is showed the matrix with the values)

As attachment you will find xsd and xml file.

https://forum.fast-report.com/en/uploads/419/5ZS5WVFR47SR.zip

I thank you for your help.

Riddick61 · February 2020

Hi, Anatoly

did you have had some chance to take a look at data I sent you, yet?

Thanks.

Anatoly · February 2020

Sorry, I can't deal with your problem.

Riddick61 · February 2020

ok, thanks Anatoly.

copperluke1 · July 2020

안녕, 잘 했어 기사의 내용을 관리하는 방식과 웹 사이트의 모양과 느낌을 이해해야합니다. 당신은 정말로 위대한 일을하고 있습니다

커네티컷 이민 변호사

Issue with total using Matrix

Comments

Leave a Comment