下載Stimulsoft Reports Flex最新版本

此示例顯示如何從代碼連接到XML或SQL數(shù)據(jù)庫。要從代碼創(chuàng)建和顯示查看器，您需要調(diào)用StiViewerFx.initialize（） 靜態(tài)方法。在應(yīng)用程序的initialize事件中調(diào)用此方法。還要加載報表模板文件并將其分配給reportString變量：

<mx:Application
    xmlns:mx="//www.adobe.com/2006/mxml" layout="absolute"
    minWidth="1024" minHeight="768" backgroundColor="#e8e8e8"
    initialize="onInitialize()" xmlns:viewer="stimulsoft.viewer.*">
 

private function onInitialize(): void
{
    StiViewerFx.initialize();
 
    var request: URLRequest = new URLRequest(demoFile);
    var loader: URLLoader = new URLLoader();
    loader.addEventListener(Event.COMPLETE, onLoadComplete);
    loader.load(request);
}
 
private function onLoadComplete(event: Event): void
{
    var loader: URLLoader = event.target as URLLoader;
    reportString = loader.data as String;
}

要創(chuàng)建XML數(shù)據(jù)連接，需要使用StiXmlDatabase類。在構(gòu)造函數(shù)的參數(shù)中，您應(yīng)該傳遞數(shù)據(jù)連接名稱，部分傳遞給XSD架構(gòu)和XML數(shù)據(jù)文件的路徑。然后使用report.dictionary.databases.add（）方法將創(chuàng)建的數(shù)據(jù)連接對象添加到報表中。如果需要清除報表中的現(xiàn)有數(shù)據(jù)連接，可以使用report.dictionary.databases.clear（）方法：

private function onConnectToXMLClick(): void
{
    // Create new report object
    var report: StiReport = new StiReport();
    // Load report from XML string
    report.loadReportFromString(reportString);
    // Create new XML database with same name "Demo"
    var database: StiXmlDatabase = new StiXmlDatabase("Demo", "reports/data/Demo.xsd", "reports/data/Demo.xml");
    // Clear all existing databases in report 
    report.dictionary.databases.clear();
    // Add database to report
    report.dictionary.databases.add(database);
    // Show report in Viewer dialog window
    report.showDialog();
}

要創(chuàng)建MySQL數(shù)據(jù)連接，操作將是相同的，除了您需要使用StiMySqlDatabase類。在構(gòu)造函數(shù)的參數(shù)中，您應(yīng)該傳遞數(shù)據(jù)連接名稱和別名，連接字符串和標(biāo)志以進(jìn)行密碼管理：

private function onConnectToMySqlClick(): void
{
    // Create new report object
    var report: StiReport = new StiReport();
    // Load report from XML string
    report.loadReportFromString(reportString);
    // Create new MySql database with same name "Demo"
    var database: StiMySqlDatabase = new StiMySqlDatabase("Demo", "",
        "Server=localhost;Port=3306;Database=db_name;Uid=root;Pwd=;", false);
    // Clear all existing databases in report 
    report.dictionary.databases.clear();
    // Add database to report
    report.dictionary.databases.add(database);
}

下面的屏幕截圖中，您可以看到示例代碼的結(jié)果。

購買Stimulsoft正版授權(quán)，請點擊“”喲！