calculate summ of column values at one page

[vitaliy.urazov]

Hello!

Could you give an example how to calculate sum of values in one column at one page in order to have summary row of page at all pages.

Thanks.

[HighAley]

Hello, Vitaliy.
[quote="vitaliy".urazov]Could you give an example how to calculate sum of values in one column at one page in order to have summary row of page at all pages.[/quote]
This feature works in the latest version of Stimulsoft Reports.Fx for Flex. For that you need in the Footer Band open text editor and select Summary Running - Page. Or please use cSum function.

Thank you.

[vitaliy.urazov]

Hi

I tried both cases, but, unfortunately, it seems like it doesn't work. I always get zero as a result of function cSUM.

I have additional settings on cell format: its number, it doesn't use local settings and use .(dot) as decimal separator.

Where could be a problem?

[HighAley]

Hello.

Please send us a simple report template with data which reproduces the problem.

Thank you.

[vitaliy.urazov]

Hello.

Please send us a simple report template with data which reproduces the problem.

Thank you.

See attached report.

I use following code to populate report with data:

Code: Select all

				var table: DataTable = new DataTable("OrderInfo");
				var column: DataColumn = new DataColumn("first_row", StorageType.StringType);
				table.columns.add(column);
				column = new DataColumn("client_info", StorageType.StringType);
				table.columns.add(column);
				column = new DataColumn("supplier_info", StorageType.StringType);
				table.columns.add(column);
				column = new DataColumn("number", StorageType.StringType);
				table.columns.add(column);
				column = new DataColumn("date", StorageType.StringType);
				table.columns.add(column);
				column = new DataColumn("boss_name", StorageType.StringType);
				table.columns.add(column);
				
				var row:DataRow;
				row = table.addNewRow();
				
				.... ....

				var dataSet: DataSet = new DataSet("DataSetName");
				dataSet.tables.add(table);
				
				table = new DataTable("prod_rows");
				column = new DataColumn("name", StorageType.StringType);
				table.columns.add(column);
				column = new DataColumn("amount", StorageType.DecimalType);
				table.columns.add(column);
				column = new DataColumn("cost_no_nds", StorageType.StringType);
				table.columns.add(column);
				column = new DataColumn("summ_no_nds", StorageType.DecimalType);
				table.columns.add(column);
				column = new DataColumn("nds", StorageType.StringType);
				table.columns.add(column);
				column = new DataColumn("nds_summ", StorageType.StringType);
				table.columns.add(column);
				column = new DataColumn("summ_nds", StorageType.StringType);
				table.columns.add(column);
				column = new DataColumn("unit", StorageType.StringType);
				table.columns.add(column);


                               start loop

					row = table.addNewRow();
					row.setValue("name", product.name);
					row.setValue("amount", o[1]);
					row.setValue("summ_no_nds", costWithoutNDS*o[1] ); // costWithoutNDS is Number object

                              end loop

There is one strange thing. While Summ function works good, cSumm doesn't.

Thanks

[HighAley]

Hello.

There was a problem when the format of text box was not General.
The issue is fixed.
Please check our next prerelease from 25-11-2011.

Thank you.

[vitaliy.urazov]

Hello!

Is it possible to:

1. add another decimal separator? for example sign minus: 234-22
2. add space as a group separator? example: 22 343


Thanks.

[HighAley]

Hello, Vitaliy.[quote="vitaliy".urazov]Is it possible to:

1. add another decimal separator? for example sign minus: 234-22
2. add space as a group separator? example: 22 343[/quote]
We made some improvements in that direction.
Please, check our next prerelease. It will be available today.

Thank you.

[vitaliy.urazov]

Hello, Vitaliy.[quote="vitaliy".urazov]Is it possible to:

1. add another decimal separator? for example sign minus: 234-22
2. add space as a group separator? example: 22 343

We made some improvements in that direction.
Please, check our next prerelease. It will be available today.

Thank you.
[/quote]

Sounds good!
Thanks!

[Andrew]

Hello,

Let us know about the result.

Thank you.