TNG - Tips & Tricks
Working with TNG's SQL-based Reports (A Guide to my Report Library)
Please read first
- Go to my reports page. Remember (or write down) the name (R.....)
of the report which you would like to enter on your own TNG website.
- Locate and run the appertaining "RR" report to
obtain the requested report definition. Read the additional
(report-specific) documentation which comes with the
"RR" report's result. Copy the definition (beginning
with SELECT...) into the clipboard.
- Enter the administration area of your TNG website. Goto
"reports", create a new report and paste the definition
(from step before) into the SQL field. Type in a report name and
description. Save the new report.
(Attention: Be sure after copy & paste that there
are no "invisible" carriage returns/line feeds inside TNG's
SQL field. This may be the reason if a SQL statements works fine with
phpMyAdmin (or similar tools) but TNG gives an error message.)
- Test the report. If everything works fine, make the report public
(if you like).
Be careful with reports on living people's data! Some of
my reports have the "living" field included. If you remove
it, living people's data in the report output will be visible to the
public! As long as the "living" field is part of the report
definition, users who are not logged in can't see any living people's
data. (Test it on your own before making the report public!)
Modifying Report Definitions, Creating Your Own Report Definitions
- For developing and testing your own SQL statements, you can use
the MySQL Query Browser (to be installed on your computer) or phpMyAdmin (to be installed
on your website; maybe your web provider has it already done).
- MySQL documentation (Reference Manual): see http://dev.mysql.com/doc/; Chapters
"Language Structure", "Functions and Operators",
"SQL Statement Syntax" (-> SELECT!).
Copyright © http://www.ahnendaten.de/tng/
Letzte Aktualisierung am 30. September 2007