Difference between revisions of "Report Rows And Footer"
(→Compatibility with other Mods: mod conflicts with the CSV Reports for Admin Only mod) |
(New version 12.0.0.2) |
||
(22 intermediate revisions by 3 users not shown) | |||
Line 1: | Line 1: | ||
− | + | {{V12_cust_text}} | |
− | {{ | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | }} | ||
{{TNGmod | {{TNGmod | ||
− | | mod_name = Reports | + | | mod_name = Reports-Floating results |
− | | mod_summary = Adds run-time options for | + | | mod_summary = Adds additional run-time options for reports. For details see revision history. |
| mod_validation = | | mod_validation = | ||
− | | download_link = | + | | mod_last_update = 25 Oct 2018 |
− | + | | download_link = [[Media:modname_v12.0.0.2.zip|v12.0.0.2]]{{Tv120}} | |
− | [[Media: | + | <div>See the [[#Revision_History|Revision History]]</div> |
| download_stats = | | download_stats = | ||
| mod_author = [[User:Robinrichm|Robin Richmond]] | | mod_author = [[User:Robinrichm|Robin Richmond]] | ||
− | | mod_url = [ | + | | mod_url = [https://www.robinrichmond.com/family/ Robin Richmond's Genealogy Database] |
− | | mod_contact = [ | + | | mod_contact = [https://www.robinrichmond.com/family/mod_support.php My Mod Support form] |
− | | mod_support = [ | + | | mod_support = [https://www.robinrichmond.com/family/mod_support.php My Mod Support form] or [http://tng.community/ TNG Community Forums] |
− | | mod_version = | + | | mod_version = v12.0.0.2 |
− | | min_TNG_ver = | + | | min_TNG_ver = 12.0 |
− | | max_TNG_ver = at least | + | | max_TNG_ver = at least 12.0.2 |
| TNG_file_list = showreport.php, cust_text.php English | | TNG_file_list = showreport.php, cust_text.php English | ||
| related_mods = | | related_mods = | ||
| notes = | | notes = | ||
}} | }} | ||
− | + | == Purpose of the Mod == | |
+ | To provide flexibility in the display of TNG reports, adds run-time options for reports to | ||
+ | # Control the number of result rows displayed on a page, and | ||
+ | # Allow for multiple side-by-side HTML tables, so that more data from narrow reports can be shown on the screen. | ||
+ | The report display program also now | ||
+ | # Indents the report description and SQL code for readability. | ||
+ | # Doesn't print the report "Description" label if there is no description. | ||
+ | # Omits the buttons, form fields, and the page navigation widget from the pretty-print display. | ||
+ | # Moves the "Matches i to j of n" message next to the page navigation buttons like most TNG search results. | ||
{| style="margin-right:0.5 em;" align="right" | {| style="margin-right:0.5 em;" align="right" | ||
| __TOC__ | | __TOC__ | ||
|} | |} | ||
+ | == Mod Parameters == | ||
+ | All four Mod Parameter determine whether end-users (i.e. non-administrators) see certain options. All options are always available to site administrators. Mod Parameter 2-4 deal with new options, so it may be useful to review at least the first 4 [[#Visualizations|Visualizations]] below before reading about the Mod Parameters. | ||
− | + | # $displayCSVLink (true) determines whether to show the CSV Download load link to end-users. This mod effectively implements the functionality of the [[CSV Reports for Admin only]] mod, which conflicts with this mod. | |
− | + | # $showSideBySideOptions (true). The options that control side-by-side report tables can be a bit confusing, and they only work for fairly narrow tables. As a result, some TNG administrators may want to hide them from end-users. | |
− | # | + | # $displayWrapOneTableOption (true). Even if the $showSideBySideOptions parameter is (true), the site administrator may want to hide option 4 (Wrap one table on each printed page), largely because it doesn't work in all browsers. |
− | + | # $repeatrateParam (25). The option to repeat headings every so many lines can also be hidden from end users - in most circumstances. The "Repeat Headings" option is critical for the "Wrap one table on each printed page) option to work well, so is is always displayed if the user selection the "Wrap one table on each printed page) option. | |
− | # | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | == | + | == Compatibility == |
− | + | Among the published mods that change showreport.php, this mod | |
− | + | * Is compatible with | |
+ | *# [[Bug Fix-Showreport PersonID]] | ||
+ | *# [[Living Color Mod]] | ||
+ | *# [[Public Access Control]] | ||
+ | *# [[Reports Action Queries]] | ||
+ | * Is not compatible with | ||
+ | *# [[Report Footer]] - But since the columns defined by this mod float below the previous column if the screen isn't wide enough to accommodate them, the columns effectively serve the same purpose as the headings in [[Report Footer]] | ||
+ | *# [[CSV Reports for Admin only]]. However, when the first Mod Parameter described above is set to False, this mod implements the functionality of [[CSV Reports for Admin only]] - that is, it hides the CSV download link from non-admins. | ||
− | == | + | == Related Mods == |
− | * | + | * This mod uses "Field Buttons", which are visible only if the '''''optional''''' [[Field Buttons]] mod is installed. |
− | + | * [[Reports-Floating Editor]] is similar in that is allows objects on the screen to float side-by-side on wider screens, but [[Reports-Floating Editor]] affects only the report editor, whereas this mod affects only showreport.php, which runs reports and shows results. | |
− | * | + | * This mod saves data that ''can'' be used by the [[Show Mod Names]] utility mod, but is '''not dependent on'''' [[Show Mod Names]]. |
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
+ | == Installation == | ||
+ | This mod uses the standard installation procedure. {{RobinInstallationBoilerplate}} | ||
== Visualizations == | == Visualizations == | ||
− | + | {| border="1" cellspacing="1" cellpadding="2" class="wikitable" | |
+ | |- | ||
+ | | style="border:thin solid black;vertical-align:top;" | Fig.1 '''showreport.php <span style="color: | ||
+ | red"> BEFORE</span>''' | ||
+ | # The report description indentation and wrapping are a little odd | ||
+ | # There is a big gap between the report description and the SQL statement | ||
+ | # The SQL statement wraps differently from the report description | ||
+ | # The entire SQL statement is probably not always needed | ||
+ | # The "Matches i to j of n" message is not adjacent to the page navigation buttons like it is in most TNG pages. | ||
+ | [[Image:reports-floating_results-before1.jpg]] | ||
+ | |- | ||
+ | | style="border:thin solid black;vertical-align:top;" | Fig.2 ''' showreport.php <span style="color: red"> AFTER</span>''' | ||
+ | # The description and SQL query now wrap with indentation, and only part of the SQL code is show, with a like to show more. | ||
+ | # There is a new "Results per page" field, with field buttons (see the [[Field Buttons]] mod) | ||
+ | # A "Side-by-Side Results Tables" button provides options to place two or more (relatively narrow) results tables side-by-side. | ||
+ | # There is a new option to "Repeat headings every" so many lines. For long tables, it is sometimes useful to redisplay the table headings so that the headings are always visible. | ||
+ | # * The "Matches i to j of n" message ''is'' now adjacent to the page navigation buttons like it is in most TNG pages. | ||
+ | [[Image:reports-floating_results-after2.jpg]] | ||
+ | |- | ||
+ | | style="border:thin solid black;vertical-align:top;" | Fig.3 '''showreport.php <span style="color: red"> AFTER</span>''', focusing on the SQL code<br/> | ||
+ | [[Image:reports_rows_and_columns-after-sql.png]] | ||
+ | |- | ||
+ | | style="border:thin solid black;vertical-align:top;" | Fig.4 '''showreport.php <span style="color: red"> AFTER </span> ''' This screen clip combines TNG's "Pretty-print" mode and the Print Preview function in a web browser to illustrate that | ||
+ | # The "Comma-delimited CSV file" button is suppressed in "Pretty-print" mode, | ||
+ | # The page navigation buttons are now suppressed in "Pretty-print" mode, | ||
+ | # If the Web page requires more than one printed page, the column headings are now repeated on each printed page. | ||
+ | [[Image:reports-floating_results-after3-pages.png]] | ||
+ | |- | ||
+ | | style="border:thin solid black;vertical-align:top;" | Fig.5 '''showreport.php <span style="color: red"> AFTER </span>''' The "Side-by-Side Results tables" Options Multi-Column Options<br/> | ||
+ | # In the 'Single Result table' box (Option 1), the "Results per page" option is exactly the same field as the "Results per page" option on the simpler screen. | ||
+ | # There is a "Fewer Options" button to get back to the simpler screen without the side-by-side options. | ||
+ | # In the "Floating side-by-side tables" box (Option 2 and 3), there are two ways to specify how many result rows appear in each table when you have side-by-side tables. | ||
+ | #* Option 2 takes the "Results per page" option from the simpler screen, and divides that many results into the number of side-by-side results tables that you want. | ||
+ | #* Option 3 presumes that you wan the as you | ||
+ | [[Image:reports-floating_results-fig5.jpg]] | ||
+ | |- | ||
+ | | style="border:thin solid black;vertical-align:top;" | | ||
+ | Sometimes it is better to generate results tables that float, using options . Other times it is better to use HTML <columns> tag to squeeze down the report columns a bit, forcing the results to be formatted into side-by-side results tables. See the visualizations below for a description of the differences between the options that "Allow the result tables to float" and that <i>"Force</i> side-by-side results tables. | ||
+ | |- | ||
+ | | style="border:thin solid black;vertical-align:top;" |'''showreport.php <span style="color: red"> AFTER </span>Two results tables ''floating'' side-by-side'''<br/> | ||
+ | If 'A' (i.e. 'all') were selected for the number of results per page, the | ||
+ | [[Image:reports-floating_results-after5-2col.png]] | ||
+ | |- | ||
+ | | style="border:thin solid black;vertical-align:top;" | '''showreport.php The "Force side-by-side results tables" option <span style="color: red"> AFTER:</span>'''<br/> | ||
+ | [[Image:reports-floating_results-after6-repeat.png]] | ||
+ | |} | ||
− | == | + | == Revision History == |
− | {| border=" | + | {| border="1" cellspacing="1" cellpadding="2" class="wikitable" |
− | + | ! Mod Version !! TNG Version !! Date !! Note | |
− | ! Mod Version | + | |- style="vertical-align:top;" |
− | ! TNG | + | |[[Media:modname_v12.0.0.2.zip|v12.0.0.2]] |
− | ! Date | + | | 12.0 - 12.0.2+ |
− | ! Note | + | | 11-Dec-2018 |
+ | | | ||
+ | Made compatible with TNGv12<br> | ||
+ | Adds run-time options for reports to | ||
+ | <ol style='margin-top:0;margin-bottom:0l'> | ||
+ | <li>Generate multiple result tables that can float side-by-side if the screen is wide enough | ||
+ | <li>Control the number of rows in each table</li> | ||
+ | </ol> | ||
+ | |- style="vertical-align:top;" | ||
+ | |- | ||
+ | | [[Media:reports-floating_results_v11.0.0.2.zip|11.0.0.2]] | ||
+ | | 11.0+ | ||
+ | | 15-May-2017 | ||
+ | | | ||
+ | : - Removed the second line from the cust_text.php target location search string | ||
+ | : - Implemented Field Buttons for the Rows Per Page fields | ||
+ | : - Added several options to format and display tables | ||
+ | : - Changed the prompts for the new display parameters | ||
|- | |- | ||
− | | 11.0.0 | + | | 11.0.0.1 |
− | | 11.0 | + | | 11.0+ |
| 15-May-2017 | | 15-May-2017 | ||
| New mod. | | New mod. | ||
Line 106: | Line 151: | ||
| [[User:Robinrichm|Robin Richmond]] | | [[User:Robinrichm|Robin Richmond]] | ||
| Mod developer | | Mod developer | ||
− | | | + | | v11.0.0.1 |
− | | 11.1 | + | | 11.1.1 |
| English | | English | ||
|} | |} | ||
− | + | [[Category:Mods for TNG v12]] | |
[[Category:Mods for TNG v11]] | [[Category:Mods for TNG v11]] | ||
[[Category:showreport.php mods ]] | [[Category:showreport.php mods ]] | ||
[[Category:Cust text.php English mods]] | [[Category:Cust text.php English mods]] |
Revision as of 18:35, 18 January 2019
The latest version of this mod uses the guidelines for TNG v12+ cust_text.php files. If you are using TNGv12+, and any cust_text.php file in this mod is marked with a Bad Target error, you need to update your cust_text.php files before you can install this mod. [Show instructions]
If you upgraded to TNGv12+, and did not update your cust_text.php files as instructed in the upgrade readme script, then you must use the TNG Mod Manager to update them. To do so:
[See details in the TNGv12 Change Impacts Article][Hide the instructions] |
|
Reports-Floating results | ||
---|---|---|
Summary | Adds additional run-time options for reports. For details see revision history. | |
Validation | ||
Mod Updated | 25 Oct 2018 | |
Download link | v12.0.0.2
See the Revision History | |
Download stats | ||
Author(s) | Robin Richmond | |
Homepage | Robin Richmond's Genealogy Database | |
Mod Support | My Mod Support form or TNG Community Forums | |
Contact Developer | My Mod Support form | |
Latest Mod | v12.0.0.2 | |
Min TNG V | 12.0 | |
Max TNG V | at least 12.0.2 | |
Files modified | showreport.php, cust_text.php English | |
Related Mods | ||
Notes |
Purpose of the Mod
To provide flexibility in the display of TNG reports, adds run-time options for reports to
- Control the number of result rows displayed on a page, and
- Allow for multiple side-by-side HTML tables, so that more data from narrow reports can be shown on the screen.
The report display program also now
- Indents the report description and SQL code for readability.
- Doesn't print the report "Description" label if there is no description.
- Omits the buttons, form fields, and the page navigation widget from the pretty-print display.
- Moves the "Matches i to j of n" message next to the page navigation buttons like most TNG search results.
Mod Parameters
All four Mod Parameter determine whether end-users (i.e. non-administrators) see certain options. All options are always available to site administrators. Mod Parameter 2-4 deal with new options, so it may be useful to review at least the first 4 Visualizations below before reading about the Mod Parameters.
- $displayCSVLink (true) determines whether to show the CSV Download load link to end-users. This mod effectively implements the functionality of the CSV Reports for Admin only mod, which conflicts with this mod.
- $showSideBySideOptions (true). The options that control side-by-side report tables can be a bit confusing, and they only work for fairly narrow tables. As a result, some TNG administrators may want to hide them from end-users.
- $displayWrapOneTableOption (true). Even if the $showSideBySideOptions parameter is (true), the site administrator may want to hide option 4 (Wrap one table on each printed page), largely because it doesn't work in all browsers.
- $repeatrateParam (25). The option to repeat headings every so many lines can also be hidden from end users - in most circumstances. The "Repeat Headings" option is critical for the "Wrap one table on each printed page) option to work well, so is is always displayed if the user selection the "Wrap one table on each printed page) option.
Compatibility
Among the published mods that change showreport.php, this mod
- Is compatible with
- Is not compatible with
- Report Footer - But since the columns defined by this mod float below the previous column if the screen isn't wide enough to accommodate them, the columns effectively serve the same purpose as the headings in Report Footer
- CSV Reports for Admin only. However, when the first Mod Parameter described above is set to False, this mod implements the functionality of CSV Reports for Admin only - that is, it hides the CSV download link from non-admins.
Related Mods
- This mod uses "Field Buttons", which are visible only if the optional Field Buttons mod is installed.
- Reports-Floating Editor is similar in that is allows objects on the screen to float side-by-side on wider screens, but Reports-Floating Editor affects only the report editor, whereas this mod affects only showreport.php, which runs reports and shows results.
- This mod saves data that can be used by the Show Mod Names utility mod, but is not dependent on' Show Mod Names.
Installation
This mod uses the standard installation procedure. [Show Installation Details]
Requirements
- A working TNG installation.
- An installed current version of the Mod Manager.
- You should backup files listed in the panel on the right.
Procedure
- Remove and delete previous version of this mod.
- Backup the files updated by this mod. They are listed in the panel at the upper right.
- Download the .zip file, Extract its .cfg file to the mods folder.
- Follow the normal automated installation for Mod Manager, as shown in the example Mod Manager - Installing Config Files.
Problems?
- Try using the Mod Manager Remove capability
- Contact me through My Mod Support form.
Visualizations
Fig.1 showreport.php BEFORE
|
Fig.2 showreport.php AFTER
|
Fig.3 showreport.php AFTER, focusing on the SQL code |
Fig.4 showreport.php AFTER This screen clip combines TNG's "Pretty-print" mode and the Print Preview function in a web browser to illustrate that
|
Fig.5 showreport.php AFTER The "Side-by-Side Results tables" Options Multi-Column Options
|
Sometimes it is better to generate results tables that float, using options . Other times it is better to use HTML <columns> tag to squeeze down the report columns a bit, forcing the results to be formatted into side-by-side results tables. See the visualizations below for a description of the differences between the options that "Allow the result tables to float" and that "Force side-by-side results tables. |
showreport.php AFTER Two results tables floating side-by-side If 'A' (i.e. 'all') were selected for the number of results per page, the |
showreport.php The "Force side-by-side results tables" option AFTER: |
Revision History
Mod Version | TNG Version | Date | Note |
---|---|---|---|
v12.0.0.2 | 12.0 - 12.0.2+ | 11-Dec-2018 |
Made compatible with TNGv12
|
11.0.0.2 | 11.0+ | 15-May-2017 |
|
11.0.0.1 | 11.0+ | 15-May-2017 | New mod. |
Sites using this mod
If you download and install this mod, please add your site to the table below.
URL | User | Note | Mod-Version | TNG-Version | User-language |
---|---|---|---|---|---|
Robin Richmond's Genealogy Database | Robin Richmond | Mod developer | v11.0.0.1 | 11.1.1 | English |