vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| -- What is it? A web based report writer. Lotta benefits.... Reports are available over the web - all you need is a web browser and a URL for the client. Reports are built with HTML/Javascript and easy to use macro's. No E4GL, CGI-Wrapper, or whatever coding required. Reports can be built up from other baser reports - wha la, report designers don't need to know the database tables or how to use them once the base reports are made. Features... (from the main documentation): " A report generator allows you to easily create reports with little to no programming required. One can quickly add a report for other users in the company to use. Since the report generator described herein is web based, you can make these reports part of your company's intranet portal. Features available in the latest report generator: * Addition of the @dur() macro which measures report generation time in seconds * Ability to manage buffer/tables accessible to the report generator via a web interface The following are used to make Denkh useful as a content management system! Now Denkh can drive your portal as well be a web based report generator! * One can use @emb(ReportName,) to run reports without inputs or queries. * One can directly run a report without queries via HTMLRpt.html?.... * One can directly run a report without inputs via HTMLRpt.html?... * Report no longer defaults <table> and </table> to contain record and summary sections. * Place these in the report definitions for Page Header and Page Footer. Previous features: * @fmt() supports numeric, time, and string formats for the given parameter (ie Easy output formatting, regardless of data type) * @tblsubtotal() can have private internal subtotal accumulators * @drill() that allows the user to "drill" from one report into another via a hyperlink * Column headings for each field can be specified for each report layout * Side-labels for each field can be specified for each report layout * Page totals, sub-totals & totals (without turning into a pretzel) * Since it is on the web, Preview or print to screen with optional paper printing later on * Open Source so you can modify look and feel, as well research "how it does it." * Use HTML Editors to develop your report sections (then cut and paste the code in and out of the editor) * Dynamic queries defined by the user * Format reports using HTML/CSS2 for a more polished look * Ability to include embedded reports within reports (a report repository) * Ability to embed data fields from the query into the report * Ability to embed page breaks into the report * Ability to ask the report user questions for report parameters * Ability to restrict which tables the report generator can reach * Ability to look into Progress, Oracle, and ODBC based databases * Web based so it can be reached easily by people (include in your portal!) * Call out to Progress 4GL programs from within a report (good for integration) * Use session variables within a report (good for integration) * Include date and time within a report * Include user's input in the output of the report * Ability to access rowid of records in report (good for integration) * PDF/MS Word documentation * Report examples/Source Code examples * Easy to use report listing system with search by name functionality" -- What is new? @prg() fix in place. When sending arguments in the @prg() macro with , and ) or (, the macro will cut off the argument. Introduction of a login screen to aid with securing reports. Introduction of the @secure() macro that will secure reports to be viewed by limited groups of users. Introduction of the @sessionid() macro to aid with session management should it be needed. Can be used in conjunction to the @prg() macro. Web based user login creation, modification, and deletion. Web based profile creation, modification, and deletion. Documentation about security with Denkh HTML Reporter. -- Details on security here: http://www.amduus.com/OpenSrc/SrcLib...20Reporter.pdf http://www.amduus.com/OpenSrc/SrcLib...20Reporter.doc Sorry, main documentation not fully updated yet. -- What is the license? Denkh open source and is licensed under the BSD license. The license is located in the source code and in the documentation. Basically it is free to use, free to re-distribute, provided you give credit to Amduus Information Works, Inc. Denkh requires Webspeed which is licensed by Progress, or Blue Diamond which it's self is dependent on Progress character client licenses. -- Where can I download it? http://www.amduus.com/OpenSrc/SrcLib....191.22.42.zip -- Is it being used in Production? This current version is not. But previous versions are. I shall soon find out. -- Gotchas? There are table changes in RptTemplate1 and new tables from the previous versions. I suggest creating a new database, then connecting to both making a delta. Apply the delta to the pre-existing database and re-compile code. Should take no more than 1 hour to upgrade. See Denkh/schema for more information and definitions with sample data. -- Scott Auge Founder Amduus Information Works, Inc. http://www.amduus.com |