weborb and/or DataTable

[brianj774]

Hi,

I'm evaluating this product for inclusion in ours, and I am trying to determine how to best make connection to my MSSQL data. I see that the 2010.3 version does not support connection to OleDB sources, but only XML and mysql. But, I've also seen mention by Vladimir of "For connecting data to a report, you must convert data to the XML format or to DataTable and DataSet structures, and then register data in the report."

First, could anybody point me at some resources for that conversion?

Second, is anyone here using WebOrb to transport the data, perhaps automatically doing the above-mentioned conversion?

Thanks ever so much!

[brianj774]

I can see from the example below, that it might be possible for me to build something that would take a weborb ActiveRecord, and convert it into a dataTable/dataSet, perhaps in a re-usable way. Can anyone confirm or deny this? Does anyone have any experience in working with this idea ?

Example 2:

Code: Select all

var table: DataTable = new DataTable("Customers");
var column: DataColumn = new DataColumn("CustomerName", StorageType.StringType);
table.columns.add(column);

table.addNewRow().sett("CustomerName", "John Smith");
table.addNewRow().sett("CustomerName", "Antonio Moreno");
table.addNewRow().sett("CustomerName", "Elizabeth Brown");

var dataSet: DataSet = new DataSet("DataSetName");
dataSet.tables.add(table);

var report: StiReport = new StiReport();
report.regData("DataSetName", "DataSetName", dataSet);
report.dictionary.synchronize();
report.design();

[Vladimir]

Hello,

Unfortunately, we do not have specific data adapters and examples for working with WebORB protocol. You need to convert data from WebORB to XML or DataSet (as you indicated above).

Thank you.

[brianj774]

Hello,

So, I've begun to write a data transformation function for my weborb based dataset. The big problem right off the bat, is that I'm not seeing any "DataTable", "DataSet", or "DataColumn" objects available to flex. What do I need to do to add them in ? If I just copy paste the code above, it wont even compile.

[Vladimir]

Hello,

This is an error. We set the visibility for all necessary classes. Fix will be available in the next prerelease build on January 25.

Thank you.

[brianj774]

For future reference, here is my function to convert a weborb queryResult (returned as an object) into a "dataTable" for comsumption by the report software:

Code: Select all

		private function dataTableGet(dataset:Array, dgItem:Object):DataTable {
			// we've been given an array of objects (returned from weborb)
			// now, convert it into a stimulsoft dataTable
			
			
			var t:DataTable = new DataTable(dgItem.String1);
			var cList:Array = dgItem.String2.toUpperCase().split(",");
				
			var c:DataColumn;
			var r:DataRow;
			var aPropList:Array;
			var item:Object;
			
			for( var i:int = 0; i < dataset.length; i++) {
				
				item = dataset[i];
				
				//Make sure we only do this part the first trip through...
				if (aPropList == null) {
					aPropList = new Array();
					
					for (var p:String in item) {
						
						// make sure that we only add the columns that we NEED, as
						// defined in the metadata
						if(ArrayUtil.arrayContainsValue(cList,p.toUpperCase())) {
							aPropList.push(p);
						}
					}
					
					aPropList.sort(); // make sure we always get the dataset columns in the same order.
					
					for (var k:int = 0; k < aPropList.length; k++) {
						// setup our columns
						var type:String =  getQualifiedClassName(item[aPropList[k]]);
						switch(type) {
							case 'int':
								c = new DataColumn(aPropList[k], StorageType.IntType);
								break;
							case 'Date':
								c = new DataColumn(aPropList[k], StorageType.DateTimeType);
								break;
							case 'Number':
								c = new DataColumn(aPropList[k], StorageType.DecimalType);
								break;
							case 'String':
								c = new DataColumn(aPropList[k], StorageType.StringType);
								break;
							default:
								c = new DataColumn(aPropList[k], StorageType.BooleanType);
								break;
						}
						t.columns.add(c);
					}
				}
				
				// the entire above if block is just a setup routine..
				// now, for each item, build the rows...
				
				r = t.addNewRow();
				
				for (var j:int = 0; j < aPropList.length; j++) {
					r.sett(aPropList[j], item[aPropList[j]]);
				}
			}
			return t;
		}
		
		

[Vladimir]

Hello,

Thank you very much for providing solution, we will recommend it to our customers.

Have a nice day!

[brianj774]

An update to my 'dataTableGet' function, to deal with the fact that stimulsoft's tool doesn't work with raw date objects...my function has a dependency on a sprintf utility function, but it could be worked around easily enough without that.

Code: Select all

		private function dataTableGet(dataset:Array, reportItem:TblReport):DataTable {
			// we've been given an array of objects (returned from weborb)
			// now, convert it into a stimulsoft dataTable
			
			
			var t:DataTable = new DataTable(reportItem.SBaseView);
			var cList:Array = reportItem.SColumnList.toUpperCase().split(",");
				
			var c:DataColumn;
			var r:DataRow;
			var aPropList:Array;
			var item:Object;
			
			for( var i:int = 0; i  " + sDate);
							
							r.sett(aPropList[j], sDate);
									
							
							break;
						default:
							r.sett(aPropList[j], item[aPropList[j]]);
							
					}
					
					
					
						
				}
			}
			return t;
		}
		
		

[Vladimir]

Hello,

In this case, you can use the following conversion:

Code: Select all

...
  case 'Date':
      r.setValue(aPropList[j], StiDateTime.fromDate(item[aPropList[j]]));
...

Also, we have made some ​​improvements, now Date object will work correctly. The update will be available in prerelease build on June, 2.

Thank you.