Flash-Mysql-Report

Interrogation et Génération d états personnalisés Mysql via le web

Data display and sorting, grouping

Displaying datas in spreadsheet format

Sunday, 29 November 2009 22:30 administrator
E-mail Print PDF

The same report in table format

Spreadsheet generated by Flash-Mysql-Report

Spreadsheet generated by Flash-Mysql-Report

(1) Viewing the question (if no filter is defined that does not appear online)
(2) header field names (background color adjustable)
(3) Data from the state (colored lines configurable)

 

Goto online Demo

Last Updated on Sunday, 17 January 2010 01:48
 

Html report

Sunday, 29 November 2009 22:28 administrator
E-mail Print PDF

Html output

Example of a state where we want a list of employees whose names begin with the letter "A" and whose date of birth is between two dates.

Html Output with the Mysql generator

 

(1) the text of the question
(2) header field names (color configurable)
(3) Details of the data (background colors of lines configurable)
(4) Page navigation (number of records per page customizable)
(5) Summary of state conditions (color settings and turn the module available)

Last Updated on Sunday, 17 January 2010 01:47
 

Sorting and grouping data

Sunday, 29 November 2009 22:26 administrator
E-mail Print PDF
Flash-Mysql-Report allows you to perform grouping fields

As an example, here we will request the number of employees in our company by differentiating men and women.

Group By Mysql Data

  • Add first field Employes.sexe, by passing the window of available fields to the fields selected with the button (>)
  • Select the line Employes.sexe in the right window (2), then right-click, the menu appears contextualized (3) , select count

 

Grouping Mysql Data

 

  • The right window shows In-> Employes.Sexe, Flash-Report-Mysql will do the counting of this field
  • Note that the field Employes.Sexe is available again in the left list
  • Reselect the window in the left (1) and made the move in the chosen fields (2)
  • The drop-down menu "Data sorted by" is set to "nothing"
    Click on the menu "Data sorted by" and select Employes.Sexe

    You just set the condition of re-grouping.

Go to online demo

Flash Report: mysql will do the counting for each employee Employee.sexe your table.

Here are your final state in HTML output.

Grouping Data in Mysql Generator

 

 

Last Updated on Sunday, 17 January 2010 01:46
 

Data Display

E-mail Print PDF



1) Fields available (not yet used in the state)
(2) Champs selected
(3) sorting data
(4) > add a button, add a field available after selecting it in (1)
(4) >> add all available fields
(5) < remove a chosen field, after selecting it in (2)
(5) << remove all selected fields
(6) choice of output format of your report (pdf or spreadsheet)
(7) Enable the output of the state (taking into account the conditions specified in the conditions tab)