dear all, I am new to this technology. i have started working on report builder and i have gone through some tutorial and done some basic development. now what i would like to know is that is there a way to add an interface like radio button, text box and other controls like in asp.net. and how can i add programming code associate with it .Is there a coding window and design window associated with it. which language can you use to write the code please show me some sample applications and tutorials Regards Roma

Hi Roma Many new report designers who have an application development background tend to treat Reporting Services as an app development tool at it's not. Although you can embed code into a report, you cannot add controls in the same way that you would in a web form or windows form project. Report "controls" are known as "report items" and are generally for displaying data, not gathering input. The report parameters don't give you explicit control over the way users are prompted for input values and typically display values in a drop-down list. If you really need to create a custom interface to prompt for parameter values, you can create a custom web form and then use the ReportViewer control or generate a URL string to launch the report, but this is an exception to the standard reporting experience. You can do a lot of creative things with SSRS but the design approach is much different that application development. For newcomers I recommend that you pick up a good book on Reporting Services and learn the how the product was designed to function, rather than spending a lot of extra effort customizing it. I've reposted this response and added a little more information on this topic: http://www.sqlserverbiblog.com/2011/02/14/CanIAddControlsToAReportingServicesReport.aspx Paul Turley, MVP [Hitachi Consulting] SQLServerBIBlog.com *Please vote if helpful*

Hi Roma Many new report designers who have an application development background tend to treat Reporting Services as an app development tool and it's not. Although you can embed code into a report, you cannot add controls in the same way that you would in a web form or windows form project. Report "controls" are known as "report items" and are generally for displaying data, not gathering input. The report parameters don't give you explicit control over the way users are prompted for input values and typically display values in a drop-down list. If you really need to create a custom interface to prompt for parameter values, you can create a custom web form and then use the ReportViewer control or generate a URL string to launch the report, but this is an exception to the standard reporting experience. You can do a lot of creative things with SSRS but the design approach is much different than application development. For newcomers I recommend that you pick up a good book on Reporting Services and learn the how the product was designed to function, rather than spending a lot of extra effort customizing it. I've reposted this response and added a little more information on this topic: http://www.sqlserverbiblog.com/2011/02/14/CanIAddControlsToAReportingServicesReport.aspx Paul Turley, MVP [Hitachi Consulting] SQLServerBIBlog.com *Please vote if helpful*