Microsoft Office 2003 Editions: Overview of Developer TechnologiesSeptember 2004
pull information from multiple business systems or has already invested in an Information Bridge Framework infrastructure that provides information for the report.
Here are various report features that you can include using "Visual Studio Tools for Office version 2005 (beta)":
Dynamic display. Many reports are static views whereas some reports are more valuable when the viewer has some control over the data presented. You can use UI elements on document and task panes to give the user various selection options.
Supplementary tools/information. A report could be a solution with complementary content that is presented through a programmable task pane.
Related business actions. The content in a report could lead the user to bring up other reports or want to access related data. This capability is best handled by marking important terms in the report with either smart tags or XML elements. The report could have smart tags and XML elements built in or use smart tags for dynamic labeling. Assuming corporate information coming from a Web service (rather than local desktop storage), Information Bridge Framework is best used to access and present auxiliary enterprise business information (in a task pane or pop-up WinForm window). Using "Visual Studio Tools for Office version 2005 (beta)" you can create a task pane view which retrieves the appropriate data from Information Bridge Framework Web services.
When using Excel and SQL Server 2000
Recommend SQL Server 2000 Reporting Services. Reporting Services provides Visual Studio-based tools to create a sophisticated, dynamic report from SQL Server data easily.
When using Excel
Recommend Web Query and Database Query in Excel for quick, lightweight reports. You can build quick, lightweight reports using the Web Query and Database Query capabilities of Excel to pull data into a report. The Web Query has the advantage of allowing you to pull in data through a loosely coupled connection using URL addressing.
Creating a Word or Excel report on a server
When using Word, Excel
There are two ways to handle this task.
© 2006 Microsoft Corporation. All rights reserved. Page 36 By using or providing feedback on these materials, you agree to the attached license agreement.
To comment on this paper or request more documentation on these developer features, contact us at . We look forward to hearing from you.