Download
1 / 19
190 likes | 279 Views
about | navigator xlreport. info@ncg-sweden.se +46 8 611 76 20 www.ncg-group.com. about | what is xlreport ?. xlreport collects, put together and presents information from the companies databases
E N D
about | navigatorxlreport info@ncg-sweden.se +46 8 611 76 20 www.ncg-group.com
about | what is xlreport? • xlreport collects, put together and presents information from the companies databases • xlreport can collect information from all modern sql-databases (sql server, oracle, informix, sybase m. fl.) • xlreport place the information in spreadsheets in microsoft excel, the worlds most popular spreadsheet program • xlreport is a genuine end user tool for reporting and decision support
1. xlreport reads and translate spreadsheet 4. and place the result in right cells i ms excel 2. then creates (sql-)queriesto the database 3. xlreport receives the answers about | how xlreport works in microsoft excel creates report layouts and linked diagrams xlreport database
about | why xlreport? • xlreport improves quality by eliminating the error that occur when manually entering data • xlreport minimize the time (it´s always a time pressure when data shall be presented, especially within group of companies) • xlreport gives more time to analysis since the production of data not trespass the analysis (how are we performing today?) • xlreport increase the possibilities since you in the report get direct access to microsoft excel’s powerful functionality
about | quick to get started • those who already are skilled using microsoft excel learns fast how to design reports in xlreport • wizard for report design • ”toolbox” to xlreport for further support for report design
about | report types in xlreport? • fixed reports with predefined number of rows and columns • specification reports with predefined number of columns and number of rows depending on selection criteria • control break reports that breaks and generates separate sub reports according to specified order • zoom function with linked reports for deeper analysis • statistic reports with 8 sort levels where microsoft excel’s sub sum functionality is used (for example hit lists) • adhoc questions where number of rows and columns are depending on the question
about | the information consumers need • to be able to updated ”his” reports with actual data easily • finished layout for further presentation for management group, internal department meeting etc. click on a specific icon on the desktop, choose menu option ”xlreport” in microsoft excel and run the report
about | the report designers need • On his own be able to create and maintain the report library based upon information from the database microsoft excel gives great flexibility for complicated calculations of rations etc. since all report design in performed in microsoft excel existing knowledge in microsoft excel can be used
about | authority administration authority control • users/user groups • authority control to values • authority control to reports • parameter controlled user identity (windows-user or db-user) • distribution of report templates and software through the database (for customers with many lan)
