Business Objects Crystal Reports Server 2008
Contents
1. 13 Alley Cat Cycles 2157 9 287 Gm Administration Tools 9 Quarte BM 622008 1 25 4 Never Run Administr ial Ca Gye ane M Se 15 Alley Cat Cycles 2272 10 27 42 S Report Samples JP Variance Analysis Report 6 2 2008 1 25 4 Never Run Administr 16 Alley Cat Cycles 2300 10 30 2 G Demonstration J YTD Variance Cross Tab 6 2 2008 1 25 4 Never Run Administr 17 Alley Cat Cycles 2301 10 31 72 G Feature Samples 18 Alley Cat Cycles 2361 11 17 2 amp Financial 19 Alley Cat Cycles 2394 11 1972 Hra 20 Alley Cat Cycles zaa az a react 21 Alley Cat Cycles 2448 12 2 72 22 Alley Cat Cycles 2455 12 6 72 23 Alley Cat Cycles 2477 12 11 72 24 Alley Cat Cycles 1 27 2 25 Alley Cat Cycles 26 Alley Cat Cycles 27 Alley Cat Cycles 28 Alley Cat Cycles 29 Alley Cat Cycles MoAb h Sheets Sheet Sheet3 3 Figure 3 Filtering Crystal Reports Data Within Microsoft Excel 6 SAP Functions in Detail Crystal Reports Server Ga d 9 0 gt a 2 c Home Insert Design Animations Slide Show Review View Live Office Picture Tools Format By Go To Object gt gt ypy ne B h Modify Object Crystal Web Universe Reports Intelligence Query Insert led Save to BOE Object Actions Publishing eli Create Snapshot iy SF Object Properties F Refresh Options IQ Object in Browser Help resh Open 2 Refresh Objet All Objects ash Save As New to BOE fee BOE Applicatio2. Search SAP BusinessObjects Reports Web applications Office Live Office Developer services Data services Web J2EE software Data services Metadata services development kit ODBC XML and native drivers Management tools Infrastructure services Management Security Collaboration f Management Scheduling Repository tools and alerting storage and Metadata retrieval design 1 J2EE Java 2 Platform Enterprise Edition 2 ODBC open database connectivity Figure 1 Crystal Reports Server Functional Architecture INFOVIEW Home Document List Open Dashboards Help Preferences Ab Inventory dashboard gt Warchouse Monitor _ Warehouse Monitor Operators Sales Inventory Satoty Stock Warning Currant Inventory leve Product is below optirna Monitor tan neport Warehouse A Product 4 October Urta Warehouse A Sum ot Ordered Units Product y z ali l rj 7 7 E a e l E a uct 4 is Minimum Stock 6o00 matn Now value Aguas Product 1 Ordered Order Order Date Mast Shin By Recened 3938 1001 2008 620 10062008 2202008 3612 102172008 1649 10262008 26102008 36 roa 067 11208 12 00 E haan Shipped without Damage Detivered On Time Warehouse Pich Accuracy ae bs ihe as 12 Products un 9757 on Time 4151 10 436 1151 10 70 MTD Results 3386 694 107232008 Warehouse A 4081 10 13 2000 1397 107182008 Product 4 a12 100072000 wao 101372000 October 2008 3406 100472008 532 10 Discussi
3. and faster to integrate Crystal Reports Server and SAP applications with Web based applications and facilitate the deploy ment of Crystal Reports Server and SAP BusinessObjects Enterprise with customized applications Web services are available for document display and refresh and to provide drill down func tionality to end users For developers the Web services provider is deployed on the server side with Crystal Reports Server or SAP BusinessObjects Enter prise For developers the API enables the creation of customized Web sites applications or Web services that access the services in Crystal Reports Server Portal Integration Kits Crystal Reports Server supports inte gration into industry leading portal server environments by delivering com ponents with similar functionality to the end user portal Prebuilt portal integra tion kits for Microsoft Sharepoint IBM and Oracle portals are available for use with Crystal Reports Server These por tal integration kits use portal standards such as JSR 168 and Web Parts Management Tools To support decentralized management functions Crystal Reports Server includes a Web portal for tasks such as password management report sched uling and user access control You can customize and automate management tasks using the Crystal Reports Server SDKs Central Management Console For total system control from a single Web interface you require a powerful yet easy to use admi
4. interactive report viewing dis cussion threads for collaborative deci sion making and integrated scheduling and distribution of Crystal Reports doc uments based on events business cal endars or intervals Security Crystal Reports Server can secure access to reports and dashboards the folders in which they are stored and the actual data that is visible within the reports Building on a hierarchical object level security model Crystal Reports Server supports security rights at both the folder and object lev el and supports full inheritance at the user and group level see Figure 6 Similarly the product supports aggre gation through a flexible group user membership model Data level security is provided by an innovative view time security feature which secures report Central Management Console Windows Internet Explorer a T Go yy je http jingram2 8080 CmcApp App home faces appKind CMC amp ser vice 2FOmcApp 2FApp 2Fape 7 r x Google Central Management Co X group the user is added automatically to that same group within the Crystal Reports Server software When Microsoft operating systems Active Directory and Microsoft SQL Server are used Crystal Reports Server enables single sign on through to the database for your end users In addition an integrated Crystal Reports Server security function is available for those customers who do lol x Enterprise ex Password Res
5. management solution that meets the needs of small businesses and midsize companies The software enables organiza tions to securely open view interact with and share interactive reports and dashboards over the Web in e mail and in Microsoft Office documents Business Challenges Improve decision making with reliable trusted data accessible to all authorized users Eliminate the use of homegrown server applications data integrators and user interfaces that are expensive to develop and maintain and are hard to use Control access to sensitive business data and prevent unauthorized use of reports Key Features Interactive reports and dashboards for all users Answer business questions quicker with interactive business performance dashboards and on report parameter panels sort ing buttons and embedded what if scenarios Report integration Embed refreshable corporate data into Microsoft Office documents and save them on corporate portals Report management and delivery Simplify IT administration work with an intuitive Web portal Data driven publishing Deliver personalized reports to anyone anywhere cost effectively Secure access to information Secure reports at user group object and folder levels a a Ss Business Benefits Enable business users to access and explore report and dashboard data interactively without any dependencies on IT Reduce the cost and effort of securing managing and s
6. CRYSTAL REPORTS SERVER A FUNCTIONAL OVERVIEW Crystal Reports Server software offers user friendly features and tools to simplify your work when you manage reports and dashboards Crystal Reports Server har nesses the same platform as SAP BusinessObjects Enterprise software to offer small businesses and mid size Companies a proven reporting and dashboard solution on a single server It addresses the complete reporting process from data access and report and dashboard design to report management and delivery including content integration with portals and enterprise applications CONTENT 3 Disclaimer 4 Functional Overview 5 Functional Architecture 5 User Interaction Tier 6 Report Viewers for Viewing Printing and Exporting 6 Microsoft Office with SAP BusinessObjects Live Office 7 Web and Application Developer Services 7 Developer Interfaces 7 Services for Microsoft NET and J2EE 7 Web Services 8 Portal Integration Kits 8 Management Tools 8 Central Management Console 9 Central Configuration Manager 9 Infrastructure Services 9 Security 10 System Management 10 Repository Storage and Retrieval 10 Auditing 10 Scheduling and Alerting 10 Publishing 11 Processing and Caching 11 Collaboration 11 Adding Reports to Crystal Reports Server 12 Report and Dashboard Creation 14 Data Services 14 Data Drivers and Connectivity 14 Metadata 15 Conclusion 15 For More Information Disclaimer The availability
7. ER TOOLS Crystal Reports Server is composed of separate yet interconnected com ponents and services optimized for specific tasks see Figure 1 These components and services include a User interaction tier for end user report and dashboard viewing and interaction Developer services such as devel opment kits and portal integration kits to enable flexible integration with Web portals and applications Web based management tools for administration and auditing of Crystal Reports Server services and objects Services for report publishing security and processing Data services for comprehensive and flexible data access User Interaction Tier The end user portal see Figure 2 is a complete production ready Web portal that enables end users to access view and manage their Crystal Reports doc uments rpt and Xcelsius dashboards swf Consumers use the portal to readily find the documents they need They can navigate using an integrated search facility as well as a folder navi gation tree They can also schedule their own Crystal Reports documents to refresh on a regular basis and man age their history list of previously scheduled reports Users can cus tomize their portal by saving multiple layouts of frequently viewed reports and can access SAP BusinessObjects Dashboard Builder to create and view personal and corporate dashboards Report creation User interaction tier Crystal i Portal and Microsoft
8. Server supports efficient report processing through the page server The page server is primar ily responsible for responding to page requests by processing reports and generating them as needed Only the requested page is returned not the entire report This greatly enhances performance and reduces unnecessary network traffic for large reports Crystal Reports Server also supports active data sharing Active data sharing means that in situations where different reports access the same data the doc uments can share the data and the requested report can be rendered with out an additional database hit even though the other report itself may be different This results in significant performance improvement across the entire system including hardware applications and database A major benefit of active data sharing is that as the load and usage increase more data is cached and the system runs more efficiently The cache server in Crystal Reports Server is responsible for han dling all report viewing requests The cache server checks whether or not it can fulfill a request with a cached report page If it cannot it asks the page server to generate the page Collaboration Threaded discussions a fully integrat ed feature of the end user portal enable users to create and maintain comments on any Crystal Reports doc ument accessible in Crystal Reports Server All threaded discussion infor mation is managed and
9. an choose from native open database connectivity ODBC object linking and embedding database OLE DB and Java database connectivity JDBC to databases files logs enterprise appli cations or program elements Report authors can also choose to write their own SQL commands Data from multi ple sources can be joined and synchro nized for use in one report Metadata An abstraction layer over complicated data sources simplifies data connectivi ty This accelerates report design by making it easier to access data In addi tion to this abstraction layer a powerful data security feature called view time 14 SAP Functions in Detail Crystal Reports Server Gain peace of mind with a solution ready for migration at any time to more com prehensive business intelligence solutions such as SAP BusinessObjects Edge solutions and SAP BusinessObjects Enterprise software security is also provided This feature means that end users see only the data they have the rights to see even when the report is scheduled Gain peace of mind with a solution ready for migration at any time to more comprehensive software such as SAP BusinessObjects business intelligence solutions CONCLUSION A COMPLETE REPORT AND DASHBOARD MANAGEMENT SOLUTION Crystal Reports Server is a complete reporting and dash board management so lution that helps small businesses and midsize companies create manage and securely deliver reports a
10. at users see only the data they have the rights to view Page Layout Formulas Data Review View Live Office 7 x Sy Go To Object E efi Create Snapshot ig T Object Properties IQ Object in Browser p Modify Object dl Save to BOE F Refresh Options Heip Crystal Web Universe Open 7 Reports Intelligence Query Refresh Object jis omes R Save As New to BOE from BOE C Application Options P About Live Office Insert l Object Actions Publishing Settings J View A2 G te Alley Cat Cycles ye _ em b G D F 6 H 1 J K n a 1 Customer_Name Order_ID Order_Date Order Amount 2 ley Cat Cycles J 1322 2 21 Ran esr 2 x 3 Alley Cat Cycles 1151 18 2 4 Alley Cat Cycles 1204 1719 4 Choose Document 5 Alley Cat Cycles 4239 _1 28 2 Select the report fie you want to use 6 Alley Cat Cycles 1260 2 4 12 7 Alley Cat Cycles 1656 5 27 2 8 Alley Cat Cycles 1701 6 9 2 ae al mw e J A RE 9 Alley Cat Cycles 1761 6 24 2 LastRun Owner 10 Alley Cat Cycles 1939 __8 5 z G Recent Consolidated Income State 1 Administr 11 Alley Cat Cycles 2081 9 7 2 G My Favorites JP Income Statement 6 2 2008 1 25 4 Never Run Administr 12 Alley Cat Cycles 2153 9 27 2 Public F a Variance Cross Tab 6 2 2008 1 25 4 Never Run Administr
11. ation you don t spend time disputing the validity of the data Instead everyone focuses on making quicker better informed decisions With SAP BusinessObjects Live Office you can be confident the data you access is timely consistent and accu rate From within Microsoft Office see Figures 3 and 4 you can use SAP BusinessObjects Live Office to Access live data refreshed from accurate reports Modify data filters and formulas as needed while retaining all existing formatting and calculations Automatically refresh a single data item or all the data in your document SAP BusinessObjects Live Office architecture uses Web services to eliminate firewall configuration issues and reduce the client side footprint It consists of a client side component that integrates with Microsoft Word Microsoft Excel and Microsoft gus cw Home Insert PowerPoint This client side component uses Web services to communicate with Crystal Reports Server The Java Web component adapter included in the server side installation communicates with the client SAP BusinessObjects Live Office takes advantage of both the report security and data security that Crystal Reports Server provides Users must log in to Crystal Reports Server through the SAP BusinessObjects Live Office client to ensure that they are authorized to see the list of reports presented Data level security is also applied when data is refreshed which means th
12. d Application Developer Services Crystal Reports Server includes comprehensive software development kits SDKs and portal integration kits to enable flexible integration with existing Web environments Developer Interfaces Crystal Reports Server comprises a powerful set of reporting services that are exposed through an extensive set of SDKs All end user interfaces are built on top of these SDKs which means that developers can access all aspects of the software The SDK object model encapsulates all the calls needed to a Extract content listings a Control content processing and delivery a View and interact with content Administer the software All the sample applications included with Crystal Reports Server use this well documented object model Services for Microsoft NET and J2EE Crystal Reports Server provides tight integration with Java and Microsoft based platforms via native Java Micro soft NET and Web services SDKs These kits include robust reporting components sample applications and documentation Developers can install these components on Web application servers including Microsoft IIS BEA WebLogic IBM WebSphere Apache Oracle 10g application server or Sun ONE The SDKs provide a high level application programming interface API so that you can use the development language you prefer to control every aspect of Crystal Reports Server The components process requests from users in the us
13. d no coding is required Your users can create person al dashboards perform what if analy Crystal Reports PRecort Reformating RFT aar Dle gdt yew puert Format Qatabave Report Window Help Cit ME E Shs i a e EmA A World Wide Unit Sales Product Name Optional 2 Active Outdoors Crochet Glove Click here to add new value View Chan o8 BERBERS EE a a a a ad O Repository Explorer ax agx Wa Lopon i Logot o 0 BB Corporate Categories BE Content indexing Fakes E excited from Content Search OB Personal Categories B admnsvewe m acens moine E oigas Total Units by Product Class E Total Sales by Produ For Help press FI osnozoor 23 51 Figure 10 Report with Shockwave Flash File Parameter Panel and Repository Explorer sis and experience interactive visual izations with corporate dashboards that you provide You can use Xcelsius to create dynamic charts and graphs data presentations visual what if scenarios and budget plans The software helps you develop executive summaries and forecast models You can also work with ROI calculators various financial models and scorecards The software helps you build operational dashboards departmental dashboards key perfor mance indicator dashboards and dash boards based on Microsoft Excel or a live data source Please note that Crystal Reports 2008 and Xcelsius Engage 2008 software licenses are n
14. e PDF Microsoft Word and text allowing further user interac tion And you can schedule reports to different destinations including e mail printer or file server You can also com bine report scheduling with user role based security allowing IT and end users to deliver the right information to the people or groups that need it The scheduler in Crystal Reports Server see Figure 7 enables you to schedule reports for automatic distribution to external locations such as file transfer protocol FTP servers e mail distribu tion lists printers and file servers When used in conjunction with securi ty a single report can be run once and distributed with personalized data for specific individuals or groups Publishing Publishing lets you make documents publicly available for mass consumption see Figure 8 Users can create a pub lication by defining source documents selecting recipients tailoring the infor mation that user groups will see and scheduling the publication to multiple destinations and in multiple delivery for mats Your users can also subscribe to or unsubscribe from publications You can extend data driven report delivery beyond your Crystal Reports Server deployment by distributing personalized content to dynamic recipients These recipients are outside the Crystal Reports Server system Using a cus tom data provider such as a database LDAP or active directory you can define these external recipie
15. er interaction tier and then communicate these requests to the appropriate service in the infra structure tier The developer services include support for report viewing and logic to interpret and direct Web requests to the appropriate Crystal Reports Server service Crystal Reports Server uses a Java SDK or a Microsoft NET SDK to run the software with a third party application server which acts as the gateway between the Web server and the rest of Crystal Reports Server The application server is responsible for processing requests from your browser sending certain requests to the Web component adapter and using the SDK to interpret components in JavaServer Pages JSP files or in Active Server Pages aspx files Web Services Crystal Reports Server includes a comprehensive Web services SDK that allows developers to integrate docu ments directly into applications using industry standard technology It con sists of a series of Web based func tions that use Microsoft NET or Java 2 Platform Enterprise Edition J2EE platforms SAP Functions in Detail Crystal Reports Server 7 You can use robust security options for user group object and folder levels to give the right people access to the right infor mation at the right time You can use robust security options for user group object and folder lev els to give the right people access to the right information at the right time Web services make it easier
16. g prompts enable end users to select parameter values from a dynamic list populated at runtime from a data source As a result end users are presented with options that are always valid 12 SAP Functions in Detail Crystal Reports Server Simple and straightforward end user portal and report viewers provide end users with immediate access to information with minimal training A simple and straightforward portal provides end users with immediate access to information with minimal training A parameter panel see Figure 10 means that parameter values can be set without refreshing data Report consumers can view the parameters displayed in the panel change them and have the new values applied direct ly to the saved data in the report Sort and filter features are another solution to reduce the report count as well as IT and development support costs Importing Shockwave Flash SWF files generated by Xcelsius software into your report provides what if scenario models and helps you visualize the potential outcome of business deci sions Please note that the Xcelsius design tool is not included in Crystal Reports Server Crystal Reports Server also lets you view share and manage the SWF files generated by Xcelsius Xcelsius lets you create com prehensive and interactive dashboards from multiple live data sources Prebuilt templates and analytics allow you to create professional looking dashboards in just a short while an
17. haring information with a prebuilt reporting server solution Enhance confidence and reliance on corporate data that is timely consistent and accurate Gain administrative control with a powerful user friendly environment available from a single Web interface For More Information Call your SAP representative or visit us on the Web at www sap com sapbusinessobjects www sap com contactsap 50 093 295 09 10 2009 by SAP AG All rights reserved SAP R 3 SAP NetWeaver Duet PartnerEdge ByDesign SAP Business ByDesign and other SAP products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of SAP AG in Germany and other countries Business Objects and the Business Objects logo BusinessObjects Crystal Reports Crystal Decisions Web Intelligence Xcelsius and other Business Objects products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of Business Objects S A in the United States and in other countries Business Objects is an SAP company All other product and service names mentioned are the trademarks of their respective companies Data contained in this document serves informational purposes only National product specifications may vary These materials are subject to change without notice These materials are provided by SAP AG and its affiliated companies SAP Group for informational purposes only
18. ions El amp Users and Groups Authentication EA a bows License Keys Ez Connections ral 3 Federation ES Query Results il el Temporary Storage 5 EJ v x E Figure 5 Central Management Console 8 SAP Functions in Detail Crystal Reports Server Central Configuration Manager A central configuration manager is designed exclusively for the server management and configuration of the Crystal Reports Server services This tool allows you to start stop enable and disable servers you can also view and configure advanced server settings Infrastructure Services Based on the proven SOA of SAP BusinessObjects Enterprise Crystal Reports Server represents the servic es where actual data processing docu ment processing and end user access take place The server is segmented into a series of specialized services for different tasks and is linked by a highly optimized communication framework For Crystal Reports Server these ser vices all run on a single server The communication framework handles the movement of information between the services and SDKs and provides end user information access delivery and interaction You can access individ ual services via the provided Java Microsoft NET and Web services SDKs so there is no need to directly access or configure the communication framework The server enables end users to view and interact with informa tion inside and outside the firewall It allows
19. n Options P About Live Office Settings View 1 of 24 Clipboard peste al GR Clear all Click an item to paste Li Offi D o r ive Office Demo Objects J an SAP company Ps iveoticeinset Wierd T Choose Document Select the report file you want to use Bg al FEE a pro a n eda Folders Title Date Modified Last Run Owner Recent gt Calculated Member Cross ta 6 2 2008 1 25 4 Never Run Administr Ga My Favorites J Drilldown 6 2 2008 1 25 4 Never Run Administr Public J Grouping and Sorting 6 2 2008 1 25 4 Never Run Administr Administration Tools 4 Interactive Parameters 6 2 2008 1 25 4 Never Run Administr G Feature Samples JP Interactive Parameters Chart 6 2 2008 1 25 4 Never Run Administr E Product Demo 6 2 2008 1 25 4 Never Run Administr E Report Samples art Detail 6 2 2008 1 25 4 Never Run Administr im Demonstration Group amp Chart 6 2 2008 1 25 4 Never Run Administr G Feature Samples JP Optional Parameter DCP 6 2 2008 1 25 4 Never Run Administr amp G Financial G Xcelsius 4 6 2 2008 1 25 2 Never Run Administr amp Navigation Package J Xcelsius 4 5 Charts and Dials 6 2 2008 1 25 4 Never Run Administr G Report Data J XML Exporting 6 2 2008 1 25 4 Never Run Administr e G Search Program w Next gt Cancel Figure 4 Navigating Crystal Reports Server Content Within Microsoft PowerPoint Web an
20. nd visualizations It is built using the proven and trusted SAP BusinessObjects Enterprise software providing a powerful service oriented architecture Available for deployment on either a Microsoft Windows or Linux operating system Crystal Reports Server is a complete reporting and dashboard management solution that helps small businesses and midsize companies create manage and securely deliver reports and visualizations It is built using the proven and trusted SAP BusinessObjects Enterprise software providing a powerful service oriented architecture Plus it includes SAP BusinessObjects Live Office for inte gration with Microsoft Office An inte gration kit for Microsoft Sharepoint Services is also included Regardless of the reporting challenges your organi zation faces today you can benefit from using Crystal Reports Server to address the complete reporting pro cess and convert your data into valu able information wherever your users choose to work For More Information To learn more about Crystal Reports Server and how it can meet the report ing and dashboard needs of your com pany call your SAP representative or visit us on the Web at www sap com sapbusinessobjects SAP Functions in Detail Crystal Reports Server 15 QUICK FACTS Summary Powered by the same platform as SAP BusinessObjects Enterprise software Crystal Reports Server software is a complete report and dashboard
21. nistration environ ment to help you manage a broad set of end user interaction requirements as well as security and access rights Crystal Reports Server includes a central management console a 100 Web based environment for centralized system management deployment and configuration The console see Figure 5 provides flexible powerful and granular control of the environment for tasks that include user role setup security access server administration password management and so on It enables administrators to readily access and configure the software while controlling the overall access rights applications and end user view ing experience IT management and administration personnel benefit from the central repository for all Crystal Reports Xcelsius dashboards folders and user profiles as well as from access to security entitlement data bases for user role and document security Central Management Console Windows Internet Explorer Am BusinessObjects Enterprise Central Management Console J http fjingram2 8080 CmcApp App home faces appKind CMC amp ser vice 2FCmcApp tr x Google fe A deb ish Page G Tools CMCHome Welcome Administrator Preferences Log off About Help az Organize Define Manage S E Folders Access Levels G Instance Manager m E Personal Folders Calendars Applications Categories I Events Settings Bl Personal Categories Sj Sess
22. nts and distribute publications to both internal and external recipients simultaneously lx go SF htp fingam2 6405 CmeApp App home faces appKind CMC8service 2CmcApp ZFApp ZF appService jsp8l0c te X o Pr z We Se a Busnessobjects Central x P BusinessObjects Infoview fh gt B E CA Properties Summary Destinations General Properties Source Documents Select Destinations Show options for selected destinations Enterprise Recipier I Default Enterprise Location Email Dynamic Recipients I Business Objects Inbox Personalization Email I Merge Exported PDF Formats r I Package as ZIP File Destinations JU W Deliver objects to each user Print Settings F File System Fi Delivery Rules rom Xtreme Sports Sales Operations Add placeholder Merged PDF Optior To SI_EMAIL_ADDRESS Add placeholder Seo eas ce Add placeholder Publication Extensic Recurrence Subject Sales by Product Category Add placeholder Notification Message Dear SI_USERFULLNAME Events Scheduling Server January was a successful month for our main product categories and we eranda look forward to more success in the months to come Here are our Advanced revenue results for the month Categories Schedule SI_DOCUMENT_HTML_CONTENT POY Pear a Thie Ret pane undated PP PT PP atecatinvanet Riok 7 Figure 8 Publishing to a List of Dynamic Recipients Processing and Caching Crystal Reports
23. of some functionality may vary depending on license type For full details please visit the licensing terms for Crystal Reports Server on our Web site 4 Crystal Reports Server offers user friendly and powerful features and tools to simplify your work when you manage reports FUNCTIONAL OVERVIEW COMPLETE REPORTING AND DASHBOARD MANAGEMENT SOLUTION Crystal Reports Server software software which is designed using offers small businesses and midsize modern Web standards with an companies a proven reporting and industry standard communication dashboard solution on a single server framework to tie all components and It addresses the complete reporting services together process from data access and report and dashboard design to report man agement and delivery including content integration with portals and enterprise applications Crystal Reports Server is powered by the proven service oriented architecture SOA of SAP BusinessObjects Enterprise software a specialized end user tool that includes Crystal Reports software Xcelsius software SAP BusinessObjects Web Intelligence software SAP BusinessObjects Voyager software and SAP BusinessObjects Dashboard Builder software SAP BusinessObjects Enterprise also includes data integra tion functionality from SAP BusinessObjects Data Integrator SAP Functions in Detail Crystal Reports Server FUNCTIONAL ARCHITECTURE OPTIMIZED COMPONENTS SERVICES AND END US
24. ons Figure 2 Reporting and Dashboard End User Portal in Crystal Reports Server SAP Functions in Detail Crystal Reports Server 5 Report Viewers for Viewing Printing and Exporting Within the end user portal you can select your preferred viewer from a choice of thin and zero client report viewers dynamic HTML DHTML ActiveX viewer and Java applet These viewers provide end users with simple report viewing and interaction func tions including report refreshing printing exporting and searching The portal and the report viewers are simple straightforward and designed to be used by your end users with mini mal training Crystal Reports Viewer software a stand alone rpt file viewer is available via free download for offline report viewing and interaction Export ing is a common end user requirement Crystal Reports Server supports a variety of exporting formats including Adobe PDF Microsoft Excel XML and RTF End users can choose to export a complete report or a specific page Microsoft Office with SAP BusinessObjects Live Office SAP BusinessObjects Live Office software lets you embed refreshable verified corporate data managed by Crystal Reports Server into your Microsoft Office documents With SAP BusinessObjects Live Office your Microsoft Office documents display data from the same trusted reports you manage in Crystal Reports Server When everyone uses the same correct source of inform
25. ot included in Crystal Reports Server 2008 The Crystal Reports Server repository provides a secure central location to store common report elements includ ing custom functions SQL commands dynamic cascading prompts and bit maps You can share these elements across multiple reports and update them from a single location Repository objects are managed in the infrastruc ture tier for secure object sharing and updating SAP Functions in Detail Crystal Reports Server 13 I Standard Report Creation Wizard Data Choose the data you want to report on E Create New Connection Access Excel DAD ADO NET XML Database Files Java Beans Connectivity QJDBC NDI ODBC RDO SLAP OLE DB ADO Salesforce com universes GQXML and Web Services Repository More Data Sources Figure 11 Comprehensive Data Source Access in Crystal Reports Data Services The Crystal Reports report designer provides a variety of flexible data connectivity options For example you can extend report creation tasks to report designers who may have limited knowledge of the underlying data source taking advantage of the seman tic metalayer that masks the complexi ties associated with data access Data Drivers and Connectivity Crystal Reports includes more than 35 data drivers for direct connectivity to relational XML online analytical pro cessing OLAP and in memory data see Figure 10 Report authors c
26. ple a system might maintain that internal users access the environment using a Microsoft NT authentication database while business partner security infor mation is stored in an LDAP database SAP Functions in Detail Crystal Reports Server 9 central Management Console windows Internet Explorer eT Go http jingram2 8080 CmcApp App home faces appKind CMC amp service 2FCmcApp 2FApp 2Fape 7 X Goosle 2 we k g InfoView f Central Management Co x gt GB o gt a page gt G Toos e Obje o A ageme onsole Objects Schedule Navigation Package gox bip gt Default Settings x Properties Recurrence Y Schedule E Instance Title Run object Now X i Recurrence Now e Destination Object will run B Events R Scheduling Serv Number of re Schedule For k Monthly a User Security SEET Nth Day of Month i B History 1st Monday of Month 4 Limits Last Day of Month n X Day of Nth Week of the Month Calendar ww is 2 e Schedule Cancel An al schedule _ carcel ea Total 7 objects Figure 7 Central Management Console Scheduling Window System Management The central management server is a key service responsible for maintaining a database of information about Crystal Reports Server Data in the central management server includes informa tion on users and groups security lev els and reports This information is used to enforce acce
27. ss rights to Crys tal Reports Server and the types of tasks users can perform The central management server also manages access to the report repository and auditing databases Repository Storage and Retrieval Crystal Reports Server stores reports in acentral repository database Although this repository database stores specific information about the objects published to it including users security groups folders and parameters it does not actually store physical copies of the reports It con tains pointers to the physical reports thereby making report retrieval faster The repository database is maintained by using the provided MySQL database or a Microsoft SQL Server Oracle database or IBM DB2 database The database structure can be created automatically during setup of Crystal Reports Server or configured on a different database Auditing Crystal Reports Server records signifi cant events in an auditing database allowing administrators to report against these events and answer ques tions about user and system activity Scheduling and Alerting The report job server provides schedul ing functions for Crystal Reports There are many options available 10 SAP Functions in Detail Crystal Reports Server including scheduling based on a speci fied time a recurring schedule or a business calendar Reports can also be scheduled to output in different formats such as Crystal Reports Microsoft Excel Adob
28. stored in the repository Discussion threads can also be made public or private Adding Reports to Crystal Reports Server Crystal Reports Server is designed to support batch publishing of Crystal Reports documents to the document repository on the Web Using a desk top publishing wizard see Figure 9 your administrators and end users can publish multiple reports to Crystal Reports Server The wizard also lets you configure report processing sched ules security parameters and data base logons SAP Functions in Detail Crystal Reports Server 11 P Publishing Wizard Select Files Figure 9 The Publishing Wizard Report and Dashboard Creation Crystal Reports Server lets you view share and manage the reports designed in Crystal Reports and also dashboards designed in Xcelsius soft ware Crystal Reports is a powerful tool built to address diverse data for matting and presentation requirements For novice report designers Crystal Reports includes intuitive wizards tem plates and experts to simplify common reporting tasks For more advanced users Crystal Reports includes fine grained control over most features including formulas conditional format ting and object positioning to address specific customization requirements It also includes the powerful editable pre view feature which allows report design ers to edit a report template with data retrieved from the database Dynamic cascadin
29. trictions I Enforce mixed case passwords M Must contain at least N Characters User Restrictions I Must change password every N day s Cannot reuse the N most recent password s Must wait N minute s to change password Logon Restrictions I Disable account after N failed attempts to log on Reset failed logon count after N minute s I Re enable account after N minute s Propagate Log On to Data Source Credentials T Enable and update user s Data Source Credentials at logon time Trusted Authentication I Trusted Authentication is enabled Shared secret Shared Secret Validity Period Trusted logon request is timeout after N millisecond s 0 means no limit 0 Update Reset Figure 6 Central Management Console Authentication Window data even for scheduled reports You can integrate with many third party security entitlement database protocols such as lightweight directory access protocol LDAP Kerberos eTrust Site Minder and Active Directory through Microsoft Windows NT and use the information to control user access rights The Crystal Reports Server security function maps to these securi ty databases directly For example when a user is added to an LDAP not currently use an entitlement data base The function also supports the ability to use more than one entitlement database in the same implementation This is particularly important in cases where organizations need to combine different audiences For exam
30. without representation or warranty of any kind and SAP Group shall not be liable for errors or omissions with respect to the materials The only warranties for SAP Group products and services are those that are set forth in the express warranty statements accompanying such products and services if any Nothing herein should be construed as constituting an additional warranty
Download Pdf Manuals
Related Search