Cloud
Облачный сервис для быстрого и эффективного анализа и визуализации данных для вашего бизнеса без необходимости создания своих приложений и программирования.
Using SQL Data Sources
Наши примеры проектов и шаблоны отчётов помогут Вам разобраться в основах работы с нашими продуктами.Reports can pull data from SQL databases, with the connection handled on the server through the onBeginProcessData event.
Preparing the data. Read or create the data source, register it in the report dictionary, synchronize the schema, and render with the supplied records.
Handling
Preparing the data. Read or create the data source, register it in the report dictionary, synchronize the schema, and render with the supplied records.
$viewer->onBeginProcessData = function (StiDataEventArgs $args) {
if ($args->connection == 'MyConnectionName')
$args->connectionString = 'Server=localhost; Database=northwind; UserId=root; Pwd=;';
if ($args->dataSource == 'MyDataSource')
$args->queryString = 'SELECT * FROM MyTable';
};
$viewer->process();onBeginProcessData— fires on the server as the report requests its data, keeping credentials off the client.$args->connection / connectionString— identifies the named connection and lets you supply its connection string.$args->dataSource / queryString— identifies the data source and lets you override its SQL query.
Handling
onBeginProcessData on the server keeps database credentials out of the client; you can override the connection string and query for each named connection and data source.