SQL Server Reporting Services provides a full range of ready-to-use tools and services to help you create, deploy, and manage reports for your organization, as well as programming features that enable you to extend and customize your reporting functionality. Reporting Services is a server-based reporting platform that provides comprehensive reporting functionality for a variety of data sources. Reporting Services includes a complete set of tools for you to create, manage, and deliver reports, and APIs that enable developers to integrate or extend data and report processing in custom applications. Reporting Services tools work within the Microsoft Visual Studio environment and are fully integrated with SQL Server tools and components. With Reporting Services, you can create interactive, tabular, graphical, or free-form reports from relational, multidimensional, or XML-based data sources. You can publish reports, schedule report processing, or access reports on-demand. Reporting Services also enables you to create ad hoc reports based on predefined models, and to interactively explore data within the model. You can select from a variety of viewing formats, export reports to other applications, and subscribe to published reports. The reports that you create can be viewed over a Web-based connection or as part of a Microsoft Windows application or SharePoint site. Reporting Services provides the key to your business data. For information about other SQL Server components, tools, and resources, see SQL Server Books Online.
|  |
I'm a bit of a newbie with SSRS. I am working with BIDS 2008. I have two separate data sets with completely different queries but the same display fields. I would like to create a report that would allow the user to choose from a drop down list one of two values - or "All". Then run an embedded code function that would set the Dataset corresponding to the selected item.
Is this possible?
Please advise.
Many thanks,
- Rich
- 7/30/2010
- Tournesol
