Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Development Tools
 Reporting Services Development
 reportin services question

Author  Topic 

charles101
Starting Member

16 Posts

Posted - 2007-02-28 : 23:18:37
Hello Im new too reporting services, I was wondering if it is possible to put controls within a report interface

e.g dropdown list with customer names

or a dropdown list with intervals off year/quarter/day

or something like analysis services where you get to select the dimensions and measures and the data changes depending on which you select.

has someone have a link or example i can use...

thanks

snSQL
Master Smack Fu Yak Hacker

1837 Posts

Posted - 2007-03-01 : 10:08:01
Yes, SSRS has parameters for all reports where the user can select all the parameters for their report before they view or print the report. Various parameter types with various input controls are supported.
See
http://msdn2.microsoft.com/en-us/library/ms155917.aspx
http://en.csharp-online.net/Building_Reports_in_SQL_Server_2005%E2%80%94Setting_Report_Parameters_with_Stored_Procedures
Go to Top of Page
   

- Advertisement -