to start the
Contents
1. The reports is created and opened into the report editor Each field could be set as wanted Object position Eloat Fix relative to top of band 5 Fix relative to bottom of band Stretch with overflow Size and position in layout From page top Height From left Width psgsdk com 41 NET Reports 3 0 3 4 1 3 2 List Excel After you have the data cursors available select the MS Excel workbook option and press Create report cancel previous next Select the fields and press Next NET Reports report to Ms Excel wizard date Title Customers List Columns Headers page amp pages v autocenter Auto fit in columns Number of columns V Repeat columns 1 4 _ Landscape ia Portrait cancel previous finish oet the Excel page and column headers here psgsdk com Administrator manual NET Reports report to Ms Excel wizard Press Finish to create the Excel export script file Press Finish 3 4 1 3 3 CrossTab Have the data cursors from the server chose CrossTab and press Create report button Wizard Crosstab Report Title Monthly sales Page Column MONTH QUARTER REGION C MONTH Data DATE 0 CONTACT C ADDRESS C EMPLOYEE VALUE Y CITY sc REGION QUANTITY UNITPRICE VALLE Y PRODUCT EMPL2. 18 03 2011 194421 Companyname Contacttitia Address Al reds Futierksie Sales sentative Obere Str 57 Trujillo Emparedados y Owner Awda de la Constituci n 2222 M xico D F helados Matadems 2312 120 Hanover Sq Christina Bergund Barguy gen Lulea Forsterstr 57 Mannheim Freden 2 Kleber Sirasbou Ban Owner Laurence Lebihan 12 des Bouchers Marseile Bottom Ddlar Markets Accounting Manager Elizabeth Lncoh 23 Tsarassen Bhd Tanrossen B s Beverages Sales Representative Victoria ehworth Fauntieroy Circus London Cactus Comidas para lavar Sales 1 Patricio Sim Certo 333 Buenos Aree Argentina Centro comerdalModezuma Marketing Manager Frandeco Chang Sierras de Granada 9993 M xico D F Chinese Owner Va Ha 29 Bem Switzerland Com rcio Mineiro Sales Associate Pedro Afonso Aw dos Lusiadas 23 Sno Paulo Srazi Conaolidated Hold nge Sal Representative Elizabeth Brown Berkeley Gardens 12 Brewery London UK Die Wandarnde Kuh Salm Rta M ler Adenauerallea 900 S Germany Drachenblut Delkat Order Adminietrator Sven Ottllab 21 Aachen Germany Du monde entier Owner Janine Lebrune 87 me des Cinquante Otages Nantes France Eostem Connection Sales Agent Devon 35 King Georpe London UK Emal Handel Salsa Manager Roland Mandel Krchgsses 6 Graz Austria Arquibaido Marketing Aria Cruz Rua Orbe 92 Sao Paulo Brazi w Fab
3. Same as the combobox control the difference is that first field gives the value of the control Both comobox and listbox do not work well with integer keys avoid using integer fields as key All variables declared with textbox comobox and listbox can be used later in SQL queries Label Caption Position psgsdk com 35 NET Reports 3 0 oet the label caption 3 4 1 2 SQL procedures Here the SQL queries can be set This part requires SQL language knowledge Available Data Select Orders OrderDate H A Categories mm 4 Orders ShippedDate OrderDetailzs UnitPrice H E CustomerCustomerDemo OrderDetails Quantity a CustomerDemographics Products ProductName H B Customers Categories CategoryName H E Employees O Suppliers CompanyName i T Shippers CompanyName EmployeeTerritories Enployees LastName Empl H E OrderDetails oyees FirstName H E Orders employee Suppliers City H A Products OrderDetails UnitPricex OrderDetails Quantity a98 JJaJUI S9 qe LIP A Region Shippers Main procedure 9 Suppliers m ER Territories RunSQL first select month first orderdate as month quarter first orderdate as quarter first from first into cursor second ReturnSQL second seJnpa2ao ud s 155 1 The used databases access the databases structures here we see only one Northwind but a lot of databases can be used if we have proper con
4. CONTACTTITLE Select needed fields to the list in the right part of the form and press Next psgsdk com 39 NET Reports 3 0 NET Reports Classic Report wizard Report Header Detail Band Companyname Alfreds Futterkiste Report Title Landscape Page Ad Portrait Column label aridlinies color Contacttitle Contactname Sales Representative Maria Anders Ana Trujillo Emparedados y Owner Ana Trujillo Antonio Moreno Taqueria 4 Owner Antonio Morena Cancel Previous Set here some reports items as title columns names page type and press Next NET Reports Classic Report wizard Field COMPANY NAME CONTACT TITLE ADDRESS CITY REGION COUNT AY Sum Max Min Avg Totals amp Group options E Page footer totals Summary band Group by E Remove group field from detail line Add three groups Data should be ordered acordingly inta the SUL statement The wizard can add page groups and totals set them here and press Finish when ready psgsdk com Administrator manual 40 UNE WES NNNM uw System Admin Reports Edit Help Exit Format Report O Report Designer first frx amp Page Footer
5. NET Reports 3 0 Report description Variables Interface SQL Procedures Output Report description page used to add a description to the report that s useful for the end user Edit report Test 1 Report name Report description aae J1oqu un a E wi u a e m D m wu psgsdk com Administrator manual 32 3 4 1 1 Variables interface A visual form editor can be used to define variables that can be filled at runtime Textbox Combobox Listbox Checkbox Label Drag and drop the object on grid shape a parameters list will be visible on the right side of the page 23e J1aqur sa qe eA Time period un un a a a im LL Lr rn psgsdk com 33 NET Reports 3 0 ni EL tu n Name Variable type Date Position 101 oet the variable name and type ComboBox Position Top 147 Table Fields Widths 200 200 0 Set the database table and fields to be used The last field in the list will be used as the value of the control Wiaths set the width of each field into the combobox 0 to hide the key value psgsdk com Administrator manual ListBox Mame Position ms Database biz Fields Phone A ShipperID CompanyName Widths 10 150
6. 03 11 23 11 56 11 03 11 23 11 59 Ms Excel PivotTable Customers List DONE 11 03 11 23 55 20 11 03 11 23 55 21 Print report Customers List Excel DONE 11 03 11 23 55 23 11 03 11 23 55 24 Ms Excel Worksheet Sales Crosstab DONE 11 03 11 23 55 35 11 03 11 23 55 36 CrossTab report 18 03 11 12 33 59 18 03 11 12 33 59 Ms Excel PivotTable 12 startdate 1997 01 01 enddate 1997 12 31 The STATUS is NEW the text below shown the chosen report parameters When the report is ready the status changes to DONE 15 02 1108 21 16 PM Ms Excel PivotTable 15 02 11 08 21 14 PM startdate 1997 01 01 enddate 1997 12 31 Double click on report to open it or right click for a short menu open delete report Check Reports Types for more details 2 4 Report types Different report output types are available as fallows 4 Ms Excel arable 5 Ms Excel WorkSheet 6 DashBoard report 2 4 1 Files Used to return flat files this report can return many files at once The file browser interface is presented here psgsdk com 13 NET Reports 3 0 amp Lookup Tables from 10 02 11 04 16 08 PM Alice Mutton Aniseed Syrup Boston Crab Meat Camembert Pierrot Carnarvan Tigers Chai Chang Chartreuse verte Chef Anton s Cajun Seas Chef Anton s Gumbo Mix Chocolade Cote de Blaye Escargots de Bourgogne Filo Mix Gnocchi di nonna Alice Gorgonzola Grandma s Boysenb
7. AM_ London 4 Bg Davolio Nancy Callahan 05 03 1994 12 00 00 Seattle Davolo 010519921200004M Seattle _ 5400 ee Dodsworth 15 11 1994 12 00 00 London Fuller Andrew Fuller 14 08 1992 12 00 00 AM Tacoma i King Robert King 02 01 1994 12 00 00 London E 10 3000 m Leverling Janet Peacock 03 05 1993 12 00 00 Redmond Suyama 17101993 1200 00AM_ London els Buchanan Steven Callahan Laura Davolio Nancy Dodsworth Anne Fuller Andrew King Robert Leverling Janet Peacock Margaret Suyama Michael Sample from Ms SQL Northwind database 1996 1997 data psgsdk com Administrator manual Administrator manual 20 3 Administrator manual The management of the system requires the NET Reports administrator password Available options are usermanagement reports management user access rights 3 1 Server Install and setup NET Reports 3 0 relays on PSG client server platform Install first the PSG 2 0 server manager Run the PSG servers manager psgsdk com 21 NET Reports 3 0 PSG servers management tool Press Install to install a new PSG server Uninstall and remove Chose the install package zip file for NET Reports server and press Install psgsdk com Administrator manual 22 PSG servers management tool Server name Created
8. 0 1333 London BH Davolio Nancy Callahan 05 03 1994 Seattle lal Dodsworth Anne Davolio 01 05 1992 Seattle Dodsworth 15 11 1994 London Fuller Andrew Fuller 14 08 1992 King Robert King 02 01 1934 London ui Leverling Janet Leverling 01 04 1992 Kirkland Peacock Margaret Peacock 03 05 1993 Redmond 1 Suyama 1710 1993 London Suyama Michael Buchanan Steven Callahan Laura Davolio Nancy Dodsworth Anne Fuller Andrew King Robert FH Leverling Janet Peacock Margaret place objects on the page move and change size using the mouse right click to set the object properties or delete the object Graph object psgsdk com 45 NET Reports 3 0 Properties Il Select the data source datafield X Ax field and graph field For Pie reports type pie and doughnut the Graph field is not necessary 3D Level 0 for plain graph Grid list object Product IT 13 Tes Boston Crab Meat Camembert Pierrot Header tot Be eer CEN products PRODUCTNAM oet the grid parameters for each column and header you may set properties as font name and size psgsdk com Administrator manual 46 The object will be resized vertically at run time to show all items in the list All objects in the page bellow the grid will b
9. 2 550 bottles 24 4 oz tins 15 300 g rounds 16 kg pkg 19 28 7 1 1 18 2 2 22 18 27 24 15 15 6 26 14 3 17 10 15 20 11 24 12 oz bottles 750 cc per bottle 48 6 oz jars 36 boxes 10 pkgs 12 75 d bottles 24 pieces 16 2 kg boxes 10 500 g pkgs 500 g 24 250 ml bottles 24 250 g pkgs 12 100 pkgs 12 8 oz jars 12 500 g pkgs 12 355 ml cans 10 kg pkg 20 2 kg bags 100 250 g bags 9 24 500 g pkgs 12 200 ml jars 17 8 24 250 g jars hJ JB ON b b 01 OO UOUN HS 10 boxes x 20 bags 10 0000 18 4000 34 0000 62 5000 18 0000 19 0000 18 0000 22 0000 21 3500 12 7500 263 5000 13 2500 7 0000 21 5000 2 5000 15 5000 38 0000 12 5000 25 0000 26 0000 4 5000 36 0000 19 4500 31 2300 21 0000 31 0000 19 0000 123 19 42 39 17 69 53 0 15 17 62 38 26 39 21 0 11 20 26 27 15 31 25 30 10 F 25 5 psgsdk com User manual 14 This comes with options to save the file to different formats print or export to CrossTab Pivot Table 2 4 2 Print Report This is a paper based report type By installing a PDF printer driver like http Awww bullzip com you can create PDF files by printing to the PDF driver and Print Preview System Admin MyAccount Partners Reports Edit Help Exit a gt ae
10. ID Integer Customers Shippers CompanyName RequiredDate Datetime Discount Float QuantityPerUnit WideSt 3 E Employees Employees LastName Employees ShippedDate Datetime UnitPrice 1 Eg EmployeeTerritorie Suppliers City ShipVia Integer UnitsInStock Smallint amp Invoices OrderDetails UnitPrice OrderDetai Categories UnitsOnOrder Smalint di Order Details Exte 3 Object ReorderLevel Smallint d Order Subtotals orders ShipAddress WideString Discontinued Boolean FF orderDetails CategoryID Integer A OrderDetails ShipCity WideString Ars sepan Eg Orders Eg Products ShipRegion WideString xai d Orders FF Categories ShipPostalCode WideStr 5 d Product Sales for Shi ntry WideString Picture Blob Ippers shippers hipCountry WideString E Products Ej Employees 5 Integer Products Above Suppliers V CompanyName WideStr dis Products by Catec FlEmployees 3H da Quarterly Orders Phone WideString amp Region gt SupplierID Integer 12 EmployeeID Integer da Sales by Category Yi CompanyName WideStr LastName WideString da Sales Totals by Am ContactName WideStrin FirstName WideString Shippers Pj ple Title WideStrina d Summary of Sales 26 Summ f gt Output Expression Aggregate Alias SortType Sort Order Grouping Criteria Or S E 1 Orders OrderDate gt ostartdate E Territories Orders
11. Install Uninstall and remove Config Press Config to open the new installed server configuration program 3 2 Config Server configuration utility It runs only on server computer started from PSG server manager application Several PSG server s can be installed on the same server computer Here we have the basic options used to configure the NET Reports server as many others are already pre configured for more help option please study the PSG server configuration help that covers all options There are two operations to perform here Windows Service setup Server certificate setup Windows Service setup 23 NET Reports 3 0 PSG Configuration utility EXNETREPORTS stale een Database and application server Server port Set PSG certificate Set certificate View certificate Set NT Service Default certificate should be used only for tests One local certificate can be issued using Utils Tab here Data connection string ODBC Reports PSG server should be restarted to apply changes Test connection string Server port NET Reports uses two ports for data communications one for application communications server port field in previous screen picture one for HELP system server port 10 Those ports should be available by enable access into the firewall and properly routing if the server should be used from a different netw
12. NET Reports 3 0 NET REPORTS 3 0 au doodle nd aliai CE uF Et I E nE CRE hit to 7 Emm ie ee lors irar Ins md Piin al Eten of ET i HEET RE SS SS E P Er Fro el cm omm men cm PLATT psgsdk com NET Reports 3 0 psgsdk com All rights reserved No parts of this work may be reproduced in any form or by any means graphic electronic or mechanical including photocopying recording taping or information storage and retrieval systems without the written permission of the publisher Products that are referred to in this document may be either trademarks and or registered trademarks of the respective owners The publisher and the author make no claim to these trademarks While every precaution has been taken in the preparation of this document the publisher and the author assume no responsibility for errors or omissions or for damages resulting from the use of information contained in this document or from the use of programs and source code that may accompany it In no event shall the publisher and the author be liable for any loss of profit or any other commercial damage caused or alleged to have been caused directly or indirectly by this document Printed September 2012 in whereeve
13. OYEE L 42 psgsdk com 43 NET Reports 3 0 Drag and drop fields to corresponding containers in the right Page filter Row Column Data Press Save when oee CrossTab report for the report result 3 4 1 3 4 Excel PivotTable Have the data cursors from the server chose Excel PivotTable and press Create report button Wizard Crosstab Report Title Page Column MONTH C gt m Col DLIARTER aft F age DATE D Data CONTACT CITY L REGION C QUANTITY 1 Rows Totals UNITPRICE Y VALUE Y Columns Totals C EMPLOYEE Drag and drop fields to corresponding containers in the right Page filter Row Column Data Press Save when oee Ms Excel PivotTable for the report result 3 4 1 3 5 Dashboard A visual editor for the Dashboard report This reports uses more than one data cursor if necessary This sample is a report that present sales and some lists list of products and stock products sales in a period second list of employees employees psgsdk com Administrator manual 44 Report data sources Report type Create report emplayees Modify report Remove report layout Press Create report to open the report editor Te board editor E 1997 Sales Buchanan Steven Callahan Laura Buchanan 17 1
14. ShippedDate P V OrderDetails UnitPric V OrderDetails Quantii V Products ProductNar L Categories Categor V Suppliers CompanyN Shippers CompanyNi Employees LastNamt employee W Suppliers City 4 R OrderDetails UnitPric value_ Select Orders OrderDate Orders ShippedDate OrderDetails UnitPrice E OrderDetails Quantity Products ProductName Categories CategoryName Suppliers CompanyName Shippers CompanyName Employees LastName Employees FirstName As employee Suppliers City OrderDetails UnitPrice OrderDetails Quantity As value From Orders Inner Join OrderDetails On Orders OrderlD OrderDetails OrderlD Inner Join Products On Products ProductlD OrderDetails ProductlD Inner Join eA Pi Reka maton AT ERE M t Each query can be tested by pressing the button It is a good idea to test each query when created 3 Here we set the code that runs last on server RUNSQL sqlname runs the SQL query named lt gt RETURNSQL lt sqlnqme gt return SQL result Between those commands SQL s that collect data from multiple sources can be inserted Available new functions month date field returns month like M201 1 01 from 2011 01 01 quarter date field returns quarter from date like Q201 1 01 Sample RunSQL first select month first orderdate as month quarter first orderdate as quarter first from first i
15. ame CommonName PSG 2 0 Server certificate Owner Country Country Owner Email Email Short description FriendlyName Organization Organization Validity period Start date ValidFrom End Date ValidTo Certificate fle name KEY Password Fill all fields and press Generate button A bigger Bit Count will provide a better encryption but also will need more power Generally 512 is enough but 2048 can be used as well 3 3 Users management Available only for administrator in the client interface under Admin menu as Users Management First set the users accounts Administrator account can not be removed psgsdk com 27 NET Reports 3 0 Web Users User Administrator Description PSG System administrator Active Next set the users groups add users per groups and add rights to users groups The Reports document should be added to the user group access rights This will allow users to access the reports user interface psgsdk com Administrator manual Users Groups Access management 3 4 Reports management This module is used to manage the installed reports found using the client interface as administrator under Reports menu 28 psgsdk com 29 NET Reports 3 0 Reports Management n n Add folder amp 1 CED L H First Delete folder Add report Delete report Edit rep
16. atwurst 2079 00 2376 00 1782 00 4456 44 0 00 1237 30 0 00 3218 54 Tofu 1246 20 0 00 22320 1527 50 0 00 1302 00 0 00 558 00 Tourtiere 271 40 535 30 141 50 149 00 365 05 0 00 402 30 223 50 Tunnbr d 432 00 0 00 253 20 72 00 810 00 0 00 0 00 30 00 Uncle Bob s Organic Dried Pea 0 00 384 00 20 00 1500 00 300 00 0 00 1650 00 1050 00 Yalkoinen suklaa 520 00 0 00 325 00 0 00 0 00 0 00 0 00 406 25 Vegie spread 5510 00 0 00 0 00 0 00 0 00 263 40 1053 60 0 00 Wiimmers gute Semmelknaodel 156 20 1888 50 1010 80 0 00 0 00 1795 50 0 00 299 25 Zaanse koeken 646 00 0 00 229 00 57 00 0 00 237 00 142 50 0 00 2 80 41207 20 39975 90 55699 39 56927 70 59099 00 59464 93 49981 69 111 4 n Records 77 Columns 12 Reports can be filtered on Page filter can be printed or exported to different file types The report data can be reorganized at run time depending on available option CrossTab button Crosstab Report Wizard Page Column T EMPLOYEE MONTH Row Data PRODUCT VALUE MONTH QUARTER DATE ORDERDATE CONTACT ADDRESS CITY REGION QUANTITY UNITPRICE VALUE PRODUCT EMPLOYEE E A x E E E E E E ANTHHAONNNHE NN psgsdk com User manual 16 Or a graph by line can be created with the Graph Button M1997 1 1997 2 M1997 3 M1997 4 M1I997 5 M1997 6 M1997 7 1997 8 MI9897 9 1997 M1997 11 1997 12 Sales NorthWind Total 2 4 4 Ms Excel PivotTable Ms Excel P
17. cryption is SSL3 and uses public private key cryptography In order to implement this a certificate should be used While any certified certificate by a third party like Verisign and others could be used also a non certified certificate could be used here The security level is the same A certified certificate is generally used when the server should be verified by the client that is the real one like on line shops Here the certificate is used first to add good encryption to the system A default certificate is set by default It will be enough for Intranet or local networks To set a new certificate use Set certificate under Server tab Chose a certificate and set the password if the certificate is protected by a password Found on Utils page a certificate utility is available and can be used to create a self signed certificate that can be used to secure the PSG server psgsdk com 25 NET Reports 3 0 PSG Configuration utility EANETREPORTS Registration Installed documents Versions Available PSG commands SQL commands International Captions Table Certificate utility Set dient interface program File name other auxiliar files Client Relative Path Use Certificate to create a new certificate and go back to the server page to set it as default psgsdk com Administrator manual 26 Certificate Utility BitCount 512 bit Host Commnon N
18. e moved down accordingly 3 5 Users access rights Found on client interface under Reports menu This can be used to set access to reports for users or users groups Per User Group User Reports Mer First Name A Customers List oO Customers List Excel Lookup Tables cn Sales Crosstab Sales Dashboard U Sales PivotTable User Groups Reports Customers List Excel 1010101 o o1 101010 1 TE a eae psgsdk com
19. er your credits user and password and press Ok ask your system administrator for details 2 2 User interface The user interface is a reports explorer with two main areas Reports that can be used the tree list on top see Running reports for details The used reports results the bottom grid list psgsdk com NET Reports 3 0 System Admin Reports Edit Help Exit administrator NorthWind Customers List Customers List Excel f Lookup Tables Sales Crosstab Sales PivotTable 11 03 11 11 11 43 PM 11 03 11 11 11 56 PM 11 03 11 11 55 20 PM 11 03 11 11 55 23 PM 11 03 11 11 55 35 PM 11 03 11 11 11 45 PM 11 03 11 11 11 59 PM 11 03 11 11 55 21PM 11 03 11 11 55 24 PM 11 03 11 11 55 36 PM Net Reports NorthWind Friday March 18 2011 Double click will open a report any presented list Right click opens a short menu with option to delete the report result System menu psgsdk com User manual 10 Interface properties Base color LL C Tahoma 8 ENS ER Select language EN Change password WebBrowser HTML Help default Base color the color used into the interface Font system feature not used here Select language the interface labels maybe translated if available Change password to change the login password WebBrowser HTML Help The interface uses a small and simp
20. erry Gravad lax Guarana Fantastica Gudbrandsdalsost Gula Malacca Gumb r Gummib rchen Gustafs Kn ckebr d Pe NP a Be ew 8 6 20 1kg tins 2112 550 ml bottles 8 24 407 tins 4115 300 g rounds 1 10 boxes x 20 bags 1124 12 oz bottles 1 750 cc per bottle 2 48 jars 1112 75 bottes 5116 2 kg boxes 2124 250 ml battles 4112 100 g pkgs 2 12 8 oz jars 8 12 500 g pkgs 1 12 355 ml cans 39 0000 10 0000 18 4000 34 0000 62 5000 18 0000 19 0000 18 0000 22 0000 21 3500 12 7500 263 5000 13 2500 7 0000 21 5000 2 5000 15 5000 38 0000 12 5000 25 0000 25 0000 4 5000 35 0000 19 4500 31 2300 21 0000 31 0000 19 0000 45 0000 4 Lookup Tables from 10 02 11 04 16 08 Supplierid Categoryid Quantitype Unitprice Unitsinsto Unitsonord Reorderlev Discontinu Productid e Alice Mutton 6 20 1kg tins 39 0000 Boston Crab Meat Camembert Pierrot Carnarvon Tigers Chai Chang Chartreuse verte Chef Anton s Cajun Seasoning Chef Anton s Gumbo Mix Chocolade C te de Blaye Escargots de Bourgogne Filo Mix Flotemysost Geitost Genen Shouyu Gnocchi di nonna Alice Gorgonzola Telino Grandma s Boysenberry Spread Gravad lax Guaran Fant stica Gudbrandsdalsost Gula Malacca Gumb r Gummib rchen Gustaf s Kn ckebr d Ikura Inlaad Sill Columns 10 Rows 7 1
21. ivotTable is one of the most advanced data analysis tools available today Requires Microsoft Office x j Type a question for help EUN X ame poe ES tk tt employee A EE o ooo oj od o o o o o em M1997 1 M1997 2 9 j i 19718 4 1760 10474 3 21794 17250 5295 6 7600 12 Chartreuse verte 288 180 90 E 4928 4 13 Chef Anton s Cajun Seasoning 5737 6 405 65 1440 75 51962 2 2345 25 2142 9034 3 814 5 1503 5 34754 8 EX 7 jo 1375 18625 8020 veia 1 psgsdk com 17 NET Reports 3 0 2 4 5 2 4 6 The PivotTable is created by automating Ms Office Depending on Office release different option s are available the last is the best Ms Excel WorkSheet One list is exported to an Excel sheet Alfreds Futterkiste 2 3 4 Antonio Moreno TaquerYa 5 Around the Horn 6 Berglunds snabbk p 7 Blauer See Delikatessen 8 Blondesddsl pere et fils 9 B lido Comidas preparadas 10 Bon app 11 Bottom Dollar Markets 12 B s Beverages 13 Cactus Comidas para llevar 14 Centro comercial Moctezuma 15 Chop suey Chinese 16 ComUrcio Mineiro 17 Consolidated Holdings 18 Die Wandernde Kuh 19 Drachenblut Delikatessen 20 Du monde entier 21 Eastern Connec
22. latform It s robust architecture based on HTTPS for data communication creates a solution that can be used in Intranet or Internet as well High availability access your NET Reports server from virtually anywhere in the world Required Operating system Windows XP or later Windows 2000 2003 Vista 7 Microsoft Office and Ms Query Office setup to run PivotTables reports it work with Microsoft Office 32 bit releases only psgsdk com Introduction User manual User manual 2 User manual 1 Install and setup 2 User Interface 3 Running reports 4 Report types 2 1 Install and setup Download and install the client application nr30setup zip Administrator rights are required as the setup kit need to properly install components under the system account After installation switch to user account open the program from the desktop shortcut and press Setup this settings are kept on local account profile psgsdk com NET Reports 3 0 Server Port 81 180 117 149 127 0 0 1 servers List Set the server address here ask your system administrator for details Server address one of next computer name local network only domain name Server IP or NAT router Internet IP psgsdk com User manual 8 lt Ji E ET is NET Reports 3 0 Server User Password Ent
23. le IE based web browser to present the help file If for any reason you may want to change this you have to set the path and the executable file of the new browser Help file is available with F1 or from the help menu HTML pages are used to present the help file 2 3 Running report There are several report types used by NET Reports To run a report first identify the report into the tree list psgsdk com 11 NET Reports 3 0 Reports Description 1 4 Root Sales Report EM Northwind Customers List E Customers List Excel re Lookup Tables Parameters time period Database Morth Wind Report type Excel PivotTable pe Sales Crosstab Sales PivotTable Right text box will offer information about the reports Double click on the report will open the report parameter interface Time period E 1e Data for 07 1996 12 1997 Enter the parameters and press Each report may have a different interface one can have different controls like textbox datebox listbox combobox checkbox There are common controls that are widely used Set the reports parameters all are required Press the request is sent to the server and a new row will appear into the bottom list psgsdk com User manual Reports in use Report Status Start at Finished Report Type Lookup Tables DONE 11 03 11 23 11 43 11 03 11 23 11 45 Files Sales PivotTable DONE 11
24. ndon iLulea iMannheim Strasbourg Madrid Marseille iTsawassen BC iLondon Buenos Aires iMUxico D F SP iLondon Stuttgart Aachen iNantes iLondon iGraz Sao Paulo SP Madrid Lille Germany 12209 Mexico 05021 Mexico 5023 UK WA1 1DP Sweden 5 958 22 Germany 68306 France 67000 Spain 28023 France 13008 Canada T2F 8M4 UK EC2 5NT Argentina 1010 Mexico 05022 Switzerland 3012 Brazil 05432 043 UK WX1 6LT Germany 70563 Germany 52066 France 44000 UK WX3 6FW Austria 010 Brazil 05442 030 Spain 28034 France 59000 4 ns first DashBoard report IER w 030 0074321 5 555 4729 5 555 3932 171 555 7788 0921 12 34 65 0621 08460 88 60 15 31 91 555 22 82 91 24 45 40 604 555 4729 171 555 1212 1 135 5555 5 555 3392 0452 076545 11 555 7647 171 555 2282 0711 020361 0241 039123 40 67 88 88 171 555 0297 7675 3425 11 555 9857 91 555 94 44 20 16 10 16 Top management report type it can show data from multiple data sources using tables graphs and text fields 18 graph types are available here B D E F G H Contact title Contact Name Address City Region Country Postal Code E LA psgsdk com User manual 18 HTML 1997 Sales Buchanan Steven FirstName LastName Hie Dae Bl Callahan Laura Buchanan 17 10 1993 12 00 00
25. nections between them Ex Sales database and database data will require at least a table codes of employees from both databases if we want to integrate data from both databases to the same report data and structure can be seen this control can be hidden using the vertical shape on right of the control 2 SQL Queries each query should have a name there can be as many as needed the query can be written by hand right text edit or text editor ad or a visual query editor can be used psgsdk com Administrator manual 36 first NorthWind 2 4 Main Main 4 dbo ga Alphabetical list of z Categories Orders OrderDate 4 64 Orders ShippedDate amp HOrderDetails Products ax da Category Sales foi OrderDetails UnitPrice da Current Product Li OrderDetails Quantity OrderID Integer P ProductID Integer d Customer and Sup Products ProductName CustomerID P ProductID Integer V ProductName WideStrin ER CustomerCustome Categories CategoryName EmployeeID Integer UnitPrice BCD SupplierID Integer customerDemogre Suppliers CompanyName OrderDate Datetime Quantity Smallint Category
26. nto cursor second ReturnSQL second All queries can be tested at once by pressing button here psgsdk com 37 NET Reports 3 0 3 4 1 3 Output Each report should have a report output layout Different types of results can be set as output layout as required Files List Print List Excel CrossTab Excel PivotTable Dashboard amp Edit report Test 1 amp s Report data sources Report type Files Create report O Print report Modify report e Ms Excel PivotTable Remove report layout 82e J12qu Get data LS D c lt er jndino seJnpaaoud s 155 10101616 To create or modify a template layout first the records dataset is required Press Get data button to have the queries results 1 Chose the report type and press Create report If a report is already set press Remove report layout chose a new output type and press Create report Files is set by default the queries results will be presented as lists into a tabbed form All others options uses easy wizards and visual interfaces to create the layouts psgsdk com Administrator manual 38 3 4 1 3 1 List Print a Report data sources Report type 32e J18u Sa qe eA 1n0Ae7 s 155 Available fields Selected fields COMPANY NAME
27. ork as the Internet or another Intranet segment Use Set NT Service to set the Windows Service for the PSG server instance B PSG NT Service Service name ee l 0 E WETREPORTS Ruin the server first to check if additional frewall settings are required on Windows Xp Vista and Windows 7 see Help file for more details Remove service use Services Manager to manage the service psgsdk com Administrator manual 24 The PSG server opens two ports to offer his services as application server Traffic on ports will be HTTPSandHTTP Most firewalls need to be configured to allow PSG to run as a server Press Run Server on Windows XP Vista and 7 the Microsoft Firewall will ask if the application should be blocked or not Allow the PSG server to run here Do the same with any other firewall or security software that may run on the computer please refer to the firewall help for more details Set the service name here and press Install service button Add PSG Reports SERVER 1 Check Service time minutes J00 Pause Start miliseconnds 300 Pause End miliseconds Ir User Interface Cancel Generate INI file and INSTALL the service Press Generate INI file and INSTALL the service button Next the server can be started from this interface or from operating system service manager Server certificate setup The PSG server uses HTTPS for data communication The used en
28. ort Connections 01 101010 1 OTE 1 1 mma eno Powered by PSG Tree view explorer Right click on a node for a short menu One report can be copied with copy paste from the short menu Double click on one report to edit Use right text box to write report description Database connections are needed in order to use reports The Connections button opens the database connections window Create the connection string that should work with the database on your server An ODBC connection string is required Press Test connection to verify the connection string Press Create XML to create a metadata XML file of the database to be used later by the reports designer graphic interface psgsdk com Administrator manual Databases connections Add new Delete Connection ID Connection Name TEST Test NorthWind 4 Connection string Driver SOL Server Server adi pc sqlexpress Database northwind Uid sa Pwd 123456 Ok Succesfull connection Description Connection string is OK Connections string samples for different database servers can be found at http www connectionstrings com Check for ODBC connection 3 4 1 Edit report Reports editor each report should have at least one SQL query and an output NET reports allows reports from more databases at a time and users interfaces 30 31
29. r you are located Publisher psgsdk com Production psgsdk com Contents Table of Contents Foreword 0 Part Introduction 2 Eel A tI 2 Part Il User manual 6 Te Install and El mr n 6 2 OA IOS TEE ETE 8 S niue dee c 10 A REDON S RET RE RER EE 12 d M ev ER 12 PEERED gd 14 Mr PES ESP Se 15 Ms Excel PIVOUTADIC MC 16 Ms Excel WoEIKSDBOL 17 DAS AB OSEO da se 17 Part Ill Administrator manual 20 1 Server Install and Set P eode een 20 Ee ME c c 22 3 Users MANAGER canne ima ec mM E iM die 26 1 i em ee RE e 28 eee P 30 Variable
30. ra Inter Saichichae Ac unthg Manager Diago Row C Moratzarzal 86 Spain goumandes Sales Agent Martina Ranc 184 da Tournal Lik France Fokoch f HB Owner Marta Larsson Akergatan 24 Br cke Sweden j ing Man Carine Schmitt Nantes France Honte Bianco 34 Torino Italy Peter Franken Berliner Platz 43 M nchen Germany Furia Bacalhau a Frutos do Mar Seles Manager Uno Rodi gue Jardim des mesen 32 Lisboa Portugal Galeria del Marketing Manager Eduardo Saavedra Rambi de Cataluna 23 Barcelona Spain psgsdk com 15 NET Reports 3 0 2 4 3 CrossTab Report CrossTab report is 3 dimension cube report It is a light option for data analysis H E crosstab report Ea E row subtotals Fiter D e Boum abs A Elfes tot Ch bed ie gii PRODUCT 11997 1 199 2 11997 3 11997 4 M1337 5 199 M133 M133 8 Sir Rodney s Marmalade 0 00 0 00 0 00 5159 00 1215 00 0 00 1201 00 0 00 Sir Rodney s Scones 736 00 640 00 290 00 520 00 210 00 0 00 140 00 470 00 Sirap d rable 364 80 2622 00 0 00 1140 00 055 00 0 00 3420 00 570 00 Spegesild 211 20 336 00 49 00 108 00 0 00 0 00 0 00 26 00 Steeleye Stout 1369 00 115 20 0 00 54 00 1008 00 360 00 472 00 540 00 Tarte au sucre 2955 00 1373 00 0 00 147 30 2958 00 1725 50 986 00 4689 50 Teatime Chocolate Biscuits 306 60 489 10 189 80 0 00 92 00 322 00 0 00 460 00 Th ringer Rostbr
31. s RS ee er ee eee 32 SIR Nee PETENTE 35 OR a 37 CS A PE ET E ET E EEE AE 38 e 41 Ge TaD eea e a O S 42 ExcelPivotTable 4 crit tren wavs rua a nacer ar ce vas Fo cac a arr c EEEE nnne 43 DST E E A A 43 Users access rights a 46 Index 0 Introduction Introduction 2 1 Introduction NET REPORTS 3 0 ms oum Lsm Lm ae it LT ils A client server solution for powerful reports from different databases like MS Sql Oracle Postgress and any other database server Reports can be used in Intranet or Internet as well Access your reports from virtually anywhere Copyright PSGSDK COM 1 1 Overview NET Reports gives easy access to data from different sources by offering the right tools for e queries e reports layouts e reports access management Create integrated reports from all enterprise databases like ERP HR CRM and more psgsdk com NET Reports 3 0 Dynamic reports and a modern style dashboard report are a click away NET Reports 3 0 uses an advanced client server multi tier architecture based on PSG REST services The system is build using PSG 2 0 software development p
32. tion 22 Ernst Handel 23 Familia Arquibaldo 25 Folies gourmandes Ana Trujillo Emparedados y helados 24 FISSA Fabrica Inter Salchichas S A Company Name 7 Sales Representative Owner Owner Sales Representative Order Administrator Sales Representative Marketing Manager Owner Owner Accounting Manager Sales Representative Sales Agent Marketing Manager Owner Sales Associate Sales Representative Sales Representative Order Administrator Owner Sales Agent Sales Manager Marketing Assistant Accounting Manager Assistant Sales Agent Maria Anders Ana Trujillo Antonio Moreno Thomas Hardy Christina Berglund Hanna Moos Fr d rique Citeaux MartYn Sommer Laurence Lebihan Elizabeth Lincoln Victoria Ashworth Patricio Simpson Francisco Chang Yang Wang Pedro Afonso Elizabeth Brown Rita MRiler Sven Ottlieb Janine Labrune Ann Devon Roland Mendel Aria Cruz Diego Roel Martine Ranc Obere Str 57 Avda de la Constituci n 2222 Mataderos 2312 120 Hanover Sq Berguvsvngen 8 Forsterstr 57 24 place Kl ber C Araquil 67 12 rue des Bouchers 23 Tsawassen Blvd Fauntleroy Circus Cerrito 333 Sierras de Granada 9993 Hauptstr 29 dos LusYadas 23 Berkeley Gardens 12 Brewery Adenauerallee 900 Walserweg 21 67 rue des Cinquante Otages 35 King George Kirchgasse 6 Rua 92 C Moralzarzal 86 184 chaussUe de Tournai Berlin iMUxico D F iM xico D F iLo
Download Pdf Manuals
Related Search