sources in Reporting Services. This connector supports images,

sources in Reporting Services. This connector supports images, attachments, rich text, unread marks, parent/response relationships, full-text search, formulas, and much more. (2) Notes Mail Delivery Extension: Allows any scheduled reports in Reporting Services to be routed to subscribers via native Notes mail. (3) Notes Database Delivery Extension: Allows any scheduled reports in Reporting Services to be deposited into Notes/Domino databases (great for building report archiving/workflow/distribution applications). OfficeWriter www.officewriter.softartisans.com SoftArtisans OfficeWriter enables the design, publishing, and delivery of reports directly from Microsoft Excel and Word using SQL Server Reporting Services or ASP.NET. End users design and publish their Reporting Services reports without ever leaving Microsoft Office avoiding design tools, like VS.NET, that are unfamiliar to most business users. OfficeWriter creates Reporting Services reports (RDL files), but unlike Reporting Services Excel output, all Excel features such as pivot tables, VBA, macros, advanced formulas, and charts are preserved by OfficeWriter. Without OfficeWriter, Reporting Services cannot deliver reports in Microsoft Word format. OfficeWriter-rendered documents preserve all the Word features contained in the user s existing Word template. All this is accomplished without the need for Microsoft Office on the server.

Note: If you are looking for good and high quality web space to host and run your application check Lunarwebhost JSP Web Hosting services

Fenestrae www.fenestrae.com Fenestrae extends Microsoft SQL Server Reporting

Panorama Software www.panorama.com Panorama Software offers a powerful and intuitive front end to SQL Server Analysis Services. Panorama extends the Microsoft Platform through integrated business intelligence and corporate performance management solutions. With Panorama, decision makers at all levels and functions can easily analyze data, quickly create and distribute reports, and proactively measure performance. Companies gain a greater understanding of their business and make better decisions. These informed decisions improve profitability, increase revenues, reduce costs and time to market, and mitigate competitive risks. Panorama is a leading innovator of business intelligence solutions and supports customers worldwide in industries such as financial services, manufacturing, healthcare, retail, telecommunications, and life sciences. ProClarity www.proclarity.com Microsoft SQL Server Reporting Services integrates seamlessly with the ProClarity product family, providing customers with a comprehensive and cost-effective reporting and analysis solution that s very easy to implement. The ProClarity Analytics Server allows organizations to publish collections of views onto a middle-tier server for centralized access to analytical information. With Reporting Services, customers can launch relational reports from the ProClarity environment, making both relational and OLAP (online analytical processing) reports within a common context available to the broadest range of decision makers throughout the enterprise. Proposion www.proposion.com Proposion Report Adapter connects Microsoft Reporting Services to Lotus Notes/Domino environments. This product extends Reporting Services in three ways: (1) Notes/Domino Data Extension: A fast, robust, and feature-rich data driver that turns your Notes and Domino databases into first-class data 386 Part VII: The Part of Tens

Note: If you are looking for good and high quality web space to host and run your application check Lunarwebhost Adult Web Hosting services

Fenestrae www.fenestrae.com Fenestrae extends Microsoft SQL Server Reporting

Fenestrae www.fenestrae.com Fenestrae extends Microsoft SQL Server Reporting Services beyond the desktop to make business information more widely available within the company and business partner networks. Fenestrae Communication Server makes Business Intelligence available anywhere, anytime, and on any device. With Fenestrae and SQL Reporting Services, you can ensure real-time, automatic delivery of business information to remote locations, including reports as faxed documents or KPIs as mobile SMS and MMS messages when on the move. GFI www.gfi.com GFI FAXmaker for Exchange/SMTP is a leading network fax server. It integrates with Exchange Server and popular SMTP servers, enabling you to send and receive faxes and SMS/text messages directly from your e-mail client. By using the e-mail server and Active Directory, GFI FAXmaker provides reliable fax administration through your existing infrastructure. GFI FAXmaker fully supports the use of Microsoft SQL Server Reporting Services. It can log all incoming and outgoing faxes to Microsoft SQL Server and enables users to easily create custom reports such as billing/fax usage, fax notifications, and more. OutlookSoft www.outlooksoft.com OutlookSoft CPM is a fully integrated Microsoft-based Corporate Performance Management application. Microsoft Reporting Services extends the reach of OutlookSoft s CPM to a whole new level of detail. Customers can access data from relational tables as well as Analysis Services through the application interface. Reporting Services will be integrated into OutlookSoft solutions to provide greater reporting flexibility to meet business challenges in areas such as Sarbanes Oxley, Line item detail analysis, and Security and audit reporting. OutlookSoft CPM provides access to Reporting Services through a secured browser interface and through a patented Web-based Microsoft Excel interface. Chapter 24: Ten Third Party Tools to Use with Reporting Services 385

Note: If you are looking for good and high quality web space to host and run your application check Lunarwebhost Adult Web Hosting services

Chapter 24 Ten Third Party Tools to Use

such as CICS, IMS, VSAM, COBOL, RPG, DB2, Enscribe, RMS, Oracle, and many others. Founded in 1987 and a Microsoft Partner, Attunity and its worldwide operations support more than 1,000 direct end users. Attunity s support of the Microsoft SQL Server Reporting Services offers customers real-time access to corporate and enterprise data. With Attunity Connect, you have the flexibility to analyze and generate reports with the right data at the right time. Cizer Software www.cizer.com Cizer.Net Reporting for Reporting Services is the Web-based Business Intelligence suite from Cizer Software. It provides full report authoring in the browser, and does not require Visual Studio or any .Net client or download of any kind, including ActiveX controls or Java applets. The built-in Portal features configurable links to Cizer Quick Query ad hoc reports for Business Users, mid-level Cizer Report Builder reports with global libraries, charts, and parameters for intermediate authors, as well as the ability to run advanced Visual Studio reports from the Cizer Portal. Originally launched with Reporting Services in 2004, Cizer.Net Reporting has become a standard component of SQL Server BI implementations, and in December 2004 became the first Reporting Services application to pass the Microsoft Gold-level ISV BI Test. Dundas Software www.dundas.com Dundas Software, founded in 1992, specializes in data visualization solutions for the Microsoft .NET Framework. Data visualization is the graphical presentation of information, with the goal of providing the viewer with a qualitative understanding of the information contents. Portions of Dundas Chart for .NET technology are currently being utilized within Microsoft SQL Server 2000 Reporting Services to display a variety of advanced charts. With the next release of Reporting Services, users will have the ability to create charts using Dundas Chart for Reporting Services, a charting add-on, which will take advantage of the extensive features found in the Enterprise Edition of Dundas Chart for .NET. This additional charting functionality will offer developers more sophisticated charts, new chart types, and many advanced customization options beyond what is standard. 384 Part VII: The Part of Tens

Note: If you are looking for good and high quality web space to host and run your application check Lunarwebhost Clan Web Hosting services

Chapter 24 Ten Third Party Tools to Use

Chapter 24 Ten Third Party Tools to Use with Reporting Services In This Chapter Attunity for real-time access to corporate data Cizer for ad hoc reports Dundas for charts and customization Fenestrae for messaging to mobile units GFI for fax server capabilities Outlooksoft for prepackaged BPM reporting Panorama for a better front-end for analytical reporting ProClarity for improved reporting and analysis Proposion for connecting to Lotus/Domino reports OfficeWriter for publishing and delivery of reports through Excel and Word Microsoft provides an open environment for other software vendors to develop add-ons and extensions to Microsoft Reporting Services. This kind of grass-roots support channel with its software vendor partners gives you more alternatives for how best to leverage Microsoft SQL Server Reporting Services. Consider these ten third-party tools that work well with Reporting Services for special needs you have in your business. Attunity www.attunity.com Attunity provides turnkey adapters for accessing mainframe, enterprise data sources, and legacy applications. Attunity s Adapter Suite is designed for seamless, federated, and bidirectional integration, and includes adapters

Note: If you are looking for good and high quality web space to host and run your application check Lunarwebhost Clan Web Hosting services

Reporting Services Newsgroup If you have a question

scenario. Understanding what MDX is all about can be understood by viewing a very good primer on MDX at: http://msdn.microsoft.com/library/default.asp?url=/library/ en-us/olapdmad/agmdxbasics_4erb.asp A nice set of links to topics related to MDX, ADO-MD, and XMLA is available at: http://msdn.microsoft.com/SQL/sqlmultidata/default.aspx SQL Server Magazine This magazine is a popular one among enthusiasts of the various components of SQL Server. On the magazine Web site, you ll find links for educational or instructional opportunities so that you can find out more or test your current knowledge. You can also find information about organizations that focus on SQL Server (like PASS Professional Association of SQL Server) where you can collaborate with others who are working with the tool. The magazine site is at: www.windowsitpro.com/SQLServer/ SQL Server Development Center MSDN provides an SQL Server Development Center for Reporting Services. This site is intended to provide more information and insight for how Reporting Services can help with your reporting needs. You can find this at: http://msdn.microsoft.com/SQL/sqlwarehouse/Reporting Services/default.aspx General BI Links If you re interested in Reporting Services as it relates to other BI topics, a good general business intelligence (BI) site provides a wealth of links in related topics to reporting and analysis. This site can be found at: www.businessintelligenceiq.com/overview.asp 382 Part VII: The Part of Tens

Note: If you are looking for good and high quality web space to host and run your application check Lunarwebhost Adult Web Hosting services

Reporting Services Newsgroup If you have a question

Reporting Services Newsgroup If you have a question about a Reporting Services feature or want to share your experience of working with Reporting Services, you can navigate to the newsgroup to share with other developers like yourself. The Reporting Services newsgroup has ranked frequently as one of the top five most active newsgroups for all of SQL Server. Here are some ways to get to the newsgroup: If you have Outlook Express, the following link should open Outlook Express and connect to the Web site for the public reporting services newsgroup: news:microsoft.public.sqlserver.reportingsvcs Go to the MSDN (Microsoft Development Network) site, which is a Web version of the previous site: http://msdn.microsoft.com/newsgroups/default.aspx?dg= microsoft.public.sqlserver.reportingsvcs Chat or Webcast As Reporting Services was completed, Microsoft provided a tremendous number of Webcasts that were archived for viewing on demand. A great number of interesting Webcasts exist for Reporting Services. By the time you read this, there will no doubt be many more Webcasts. You may even be able to take part in regular chats to discover more advanced applications with Reporting Services. The site for the Webcasts, where you may find a great archive for viewing on demand is: www.microsoft.com/usa/webcasts/default.asp The site for seeing when chats are scheduled is: www.microsoft.com/communities/chats/default.mspx OLAP Reporting This may be an advanced topic, but when you work with Microsoft Analysis Services, you need to understand how Reporting Services functions in this Chapter 23: Ten Places to Find Reporting Services Support 381

Note: If you are looking for good and high quality web space to host and run your application check Lunarwebhost Adult Web Hosting services

Chapter 23 Ten Places to Find Reporting Services

Reporting Services Web Site The main page within the SQL Server domain for Reporting Services is found at: www.microsoft.com/sql/reporting Here, you can see product overviews and demos, download new service packs and report packs, and take a skills assessment exam. More links are added periodically to move you to new content. Sample Databases for Reporting You may be wondering where to go on the Microsoft site to find some common sample databases to try your hand at reporting in unique and different environments. Some of the popular sample databases include AdventureWorks. The AdventureWorks2000 database is installed by the Reporting Services setup if you select the Documentation and Samples option in the installation. This option installs the complete documentation set for Reporting Services, code samples, report samples, and the AdventureWorks2000 database. In order to find the sample databases for Northwind or pubs, you must use the following link: www.microsoft.com/downloads/details.aspx?FamilyID= 06616212-0356-46a0-8da2-eebc53a68034&DisplayLang=en Report Packs Microsoft has sponsored the development of sample report sets based on popular databases that are being used by mid-market businesses today. So example databases of content related to key functional applications have been constructed to provide a reference base for some interesting Reporting Services databases. Microsoft Report Packs are available to show how Reporting Services reports would work for popular applications. Microsoft provides Report Packs for IIS Logs, Microsoft Business Solutions (MBS), Financial Reporting, Microsoft CRM, and Exchange, as well as sample OLAP reports. These can be downloaded at the following site with all related information on Reporting Services downloads: www.microsoft.com/sql/reporting/downloads/default.asp 380 Part VII: The Part of Tens

Note: If you are looking for good and high quality web space to host and run your application check Lunarwebhost Inexpensive Web Hosting services

Chapter 23 Ten Places to Find Reporting Services

Chapter 23 Ten Places to Find Reporting Services Support In This Chapter Microsoft SQL Server Web site SQL Services Reporting Services Web site Where to find sample databases Reporting Services Report Packs Reporting Services Newsgroups Finding chats and Webcasts Working and better understanding OLAP and MDX SQL Server Magazine MSDN SQL Server development center for Reporting Services General BI Web site You can go to literally hundreds of places on the Internet to get more information or support when using Microsoft Reporting Services. These Web sites may change as the product matures, and Microsoft reserves the right to change their Web site at will. However, in my travels I have found solace in a few Internet knowledge stores that you may benefit from as well. Microsoft SQL Server Of course, one good place to look for information and links to what s new is to look at the vendors Web sites. This is intuitive, but you may not know exactly where to navigate because the home page changes daily and new products are services are being offered. Well, just bookmark the Web site www.microsoft.com/sql and you will be able to find the links for SQL Server. Reporting Services will not be many clicks away and you can see other business intelligence tools from this page.

Note: If you are looking for good and high quality web space to host and run your application check Lunarwebhost Inexpensive Web Hosting services

Clustering Support SQL Server 2005 provides for improved

Cache transparently synchronizes and maintains an updated copy of the data organized specifically for high-speed querying and for isolating endusers from overloading the relational databases. The structure of the cache is automatically derived from the Universal Data Model (UDM) structure and can be finely tuned to balance performance with latency of data. Integration with Microsoft Office Reports created by Reporting Services and executed by the Report Server can run in the context of Microsoft SharePoint Portal Server and Microsoft Office System applications such as Microsoft Word and Microsoft Excel. You can use SharePoint features to subscribe to reports, create new versions of reports, and distribute reports. You can also open reports in Word or Excel to view HTML versions of the reports. 378 Part VII: The Part of Tens

Note: If you are looking for good and high quality web space to host and run your application check Lunarwebhost JSP Web Hosting services