Нужен reporting tool для mysql (WEB)

newyorker · Post by **newyorker** » 03 Jul 2008 05:00

Есть база mysql. Крутится она на хостинге php+apache.
Есть ли какой то reporting tool который сможет генерировать репорты и чтобы эти репорты можно было смотреть через web?
Переход на другой хостинг (например с поддержкой java) нежелателен но возможен.

Спасибо!

newyorker · Post by **newyorker** » 03 Jul 2008 14:42

вопрос слишком сложный или слишком простой?

ekriv · Post by **ekriv** » 03 Jul 2008 16:16

newyorker wrote:вопрос слишком сложный или слишком простой?

Reporting tool usualy requires additional Application server.
Nobody will install it for you on shared web hosting.
Search for BIRT and Pentaho - free reporting tools.

newyorker · Post by **newyorker** » 03 Jul 2008 16:21

ekriv wrote:
newyorker wrote:вопрос слишком сложный или слишком простой?
Reporting tool usualy require additional Application server.
Nobody will install it for you on shared web hosting.
Search for BIRT and Pentaho - free reporting tool

A kak naschet
http://www.jaspersoft.com/ ?

ekriv · Post by **ekriv** » 03 Jul 2008 16:37

newyorker wrote:
ekriv wrote:
newyorker wrote:вопрос слишком сложный или слишком простой?
Reporting tool usualy require additional Application server.
Nobody will install it for you on shared web hosting.
Search for BIRT and Pentaho - free reporting tool

A kak naschet
http://www.jaspersoft.com/ ?

It isn' t free and I'm sure it requires application server.

newyorker · Post by **newyorker** » 03 Jul 2008 16:47

ekriv wrote:
newyorker wrote:
ekriv wrote:
newyorker wrote:вопрос слишком сложный или слишком простой?
Reporting tool usualy require additional Application server.
Nobody will install it for you on shared web hosting.
Search for BIRT and Pentaho - free reporting tool

A kak naschet
http://www.jaspersoft.com/ ?
It isn' t free and I'm sure it requires application server.

a razve BIRT and Pentaho - oni ne trebuut application server ?

Thanks!

ekriv · Post by **ekriv** » 03 Jul 2008 17:31

newyorker wrote:
ekriv wrote:
newyorker wrote:
ekriv wrote:
newyorker wrote:вопрос слишком сложный или слишком простой?
Reporting tool usualy require additional Application server.
Nobody will install it for you on shared web hosting.
Search for BIRT and Pentaho - free reporting tool

A kak naschet
http://www.jaspersoft.com/ ?
It isn' t free and I'm sure it requires application server.

a razve BIRT and Pentaho - oni ne trebuut application server ?

Thanks!

But they are free.

newyorker · Post by **newyorker** » 03 Jul 2008 17:58

Esche odin kandidat. Kto nibud proboval?
http://www.hkvstore.com/phpreportmaker/phprptmkr2.asp

ekriv · Post by **ekriv** » 07 Jul 2008 21:01

ekriv wrote:
newyorker wrote:вопрос слишком сложный или слишком простой?
Reporting tool usualy requires additional Application server.
Nobody will install it for you on shared web hosting.
Search for BIRT and Pentaho - free reporting tools.

http://www.eclipse.org/birt/phoenix/

BIRT Project
Business Intelligence and Reporting Tools

BIRT Overview

* Report Introduction
* The Anatomy of a Report

Report Introduction

BIRT is an Eclipse-based open source reporting system for web applications, especially those based on Java and J2EE. BIRT has two main components: a report designer based on Eclipse, and a runtime component that you can add to your app server. BIRT also offers a charting engine that lets you add charts to your own application.

The BIRT Project currently supports two releases 2.1.3 (Included in many comercial applications) and 2.2 (Latest). We encourage you to download BIRT, try it, and give us your feedback though the newsgroups and Bugzilla.

With BIRT, you can add a rich variety of reports to your application.

* Lists - The simplest reports are lists of data. As the lists get longer, you can add grouping to organize related data together (orders grouped by customer, products grouped by supplier). If your data is numeric, you can easily add totals, averages and other summaries.
* Charts - Numeric data is much easier to understand when presented as a chart. BIRT provides pie charts, line & bar charts and many more. BIRT charts can be rendered in SVG and support events to allow user interaction.
* Crosstabs - Crosstabs (also called a cross-tabulation or matrix) shows data in two dimensions: sales per quarter or hits per web page.
* Letters & Documents - Notices, form letters, and other textual documents are easy to create with BIRT. Documents can include text, formatting, lists, charts and more.
* Compound Reports - Many reports need to combine the above into a single document. For example, a customer statement may list the information for the customer, provide text about current promotions, and provide side-by-side lists of payments and charges. A financial report may include disclaimers, charts, tables all with extensive formatting that matches corporate color schemes.

The Anatomy of a Report

BIRT reports consist of four main parts: data, data transforms, business logic and presentation.

* Data - Databases, web services, Java objects all can supply data to your BIRT report. BIRT provides JDBC, XML, Web Services, and Flat File support, as well as support for using code to get at other sources of data. BIRT's use of the Open Data Access (ODA) framework allows anyone to build new UI and runtime support for any kind of tabular data. Further, a single report can include data from any number of data sources. BIRT also supplies a feature that allows disparate data sources to be combined using inner and outer joins.
* Data Transforms - Reports present data sorted, summarized, filtered and grouped to fit the user's needs. While databases can do some of this work, BIRT must do it for "simple" data sources such as flat files or Java objects. BIRT allows sophisticated operations such as grouping on sums, percentages of overall totals and more.
* Business Logic - Real-world data is seldom structured exactly as you'd like for a report. Many reports require business-specific logic to convert raw data into information useful for the user. If the logic is just for the report, you can script it using BIRT's JavaScript support. If your application already contains the logic, you can call into your existing Java code.
* Presentation - Once the data is ready, you have a wide range of options for presenting it to the user. Tables, charts, text and more. A single data set can appear in multiple ways, and a single report can present data from multiple data sets.