SAP,Business,One,Consultant,Ne computer SAP Business One Consultant Newsflash: Crystal Reports for S
Gone are those times when the companies and the organisations didn't need a hi-tech system to handle them. Owing to the considerable increase in the business sector and thus, an enormous increase in the complexity of the organisational struc ----------------------------------------------------------Permission is granted for the below article to forward,reprint, distribute, use for ezine, newsletter, website,offer as free bonus or part of a product for sale as longas no changes a
CR seems to be the trend for current SB1 2007A/B versions aswell as for the future releases. In thissmall publication we would like to give you Crystal Reports design orientationsession: 1. SAPB1 tables structure. It is described inSAP Business One SDK, however you can easily identify the table in menu bychecking Show System Information. Then,open SB1 form, associated with your targeted object, for example BusinessPartner the table name will be shown on the left bottom cornet of theapplication 2. EarlyWatch and adding objects to SB1 company database. We believe that Early Watch, that reportsdirect access to SB1 tables through SQL custom stored procedures or updatesshould be respected. This is why werecommend you to create separate database something like SB1Customizationsand then place Crystal Reports basing SQL Views or Stored Procedures there 3. CrystalReports SQL side. If you are new toCrystal Reports design, you should probably play with new report buildingwizard, and if your report is really simple, something like showing allBusiness Partners with specific flag, then CR wizard should do the job. However, if you are looking for professionalSB1 CR, you should consider basing it on either SQL Stored Procedure (the mostpowerful way, as it allows you to deploy temporary tables for intermediary dataaggregation) or SQL Views. Plus SQLabstraction opens the door for you to base Crystal Report on Heterogeneous orCross-platform data pulling, when you are pulling data from SB1 and legacy CRMor Business Management Application, hosted in ODBC compliant or SQL drivecompliant non MS SQL Server DB: Oracle, DBII, MS Access, Excel, Sybase,Ingress, MySQL/PHP, or other Linux or Unix database, deploying such drivers asJava JDBC-ODBC Bridge, etc. 4. Ifyou have specific technology challenging question about SAP Business Onereporting, Software Implementation, Customization, Data Conversion question,please give us a call: 1-866-528-0577, [email protected]
SAP,Business,One,Consultant,Ne