Ad Hoc Reporting
Hi all,
Ad Hoc Reporting... I know what it means by reading all the articles from here.
Now, I really need to know how we implement it. Is that any articles on that?
Step by Step instruction on this would be great help.
Thanks,
November 18th, 2010 1:00am
The following page contains a number of useful links related to Report Builder 2.0, the ad-hoc reporting tool:
Designing and Implementing Reports Using Report Builder 2.0
SQL Server 2008
Report Builder 2.0 is a report authoring environment for business users who prefer to work in the familiar Microsoft Office environment. You can use Report Builder 2.0 to work with data, define a layout, preview a report, and publish a report to a report server
or SharePoint site. Report Builder 2.0 includes query builders and an expression editor. It also supports the advanced reporting features found in SQL Server 2008 Reporting Services.
You can use Report Builder 2.0 to create reports with multiple data regions (such as tables and charts), as well as data from multiple data sources within a single report. Report Builder 2.0
also supports queries that run directly against relational data sources and multidimensional data sources, as well as user-friendly data access via published report models.
With Report Builder, you can customize and update reports that were created in Report Designer or Report Builder 1.0. Report Builder 2.0 features easy-to-use wizards that walk you through the
steps to create a simple table, matrix, or chart report.
http://msdn.microsoft.com/en-us/library/dd220530.aspx
Kalman Toth, SQL Server & Business Intelligence Training; SQL 2008 GRAND SLAM
Free Windows Admin Tool Kit Click here and download it now
November 18th, 2010 1:16am