Hi folks,
Newbie question. Anyone knows how to create dropdown selection boxes in a report just like in the Employee Sales Summary report Cheers!
AdventureWorks Sample Reports
Hot Topic
- SQL Locking up
- How can I get value from data flow control?
- sql statement from webform with dynamic join, how?
- Scatter chart not rendering properly, RS2000
- The connection manager 'OLEDB' is not properly installed on this computer
- Help with Error
- Which sql statement is more efficient
- Management Studio Express CTP update now available
- ForEach Loop utilisation
- Get Minimum day in a continuous series
SQL Server
- HELP plz solve some Queries
- SQLServer2005_SSMSEE.msi or SQLServer2005_SSMSEE_x64.msi ?
- SQL
- ODBC connection failing on 64 version of Windows 2003 server
- What are the best practices for a time dimension?
- Subscriptions and Windows NT Auth?
- Problem : Data got truncatedin reading Excel source
- SQL 2005 & Windows Password Policy
- MCTS Exam 70-431 Database Administration Study Documementation and Samples ?
- RS2005 Performance Test Tool
AdventureWorks Sample Reports
Jan van Wyk
rabbott
If you install the sample reports, you can just open them in report designer and investigate the Report - Report Parameter settings in the VS menu. The Employee Sales Summary report uses a query to determine the valid values list of the parameter - which results in the drop down being shown.
Alternatively, this MSDN topic should get you started: http://msdn2.microsoft.com/en-us/library/ms155917.aspx
-- Robert