Creating reports and dashboards | Stimulsoft community forum

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