I'm hoping someone might be able to help me. I'm looking at using SSRS to pre-populate fields, and I'd like to have a dropdown list which our staff can select from, when we have them fill out this form online. Is it possible to have a drop down list in one of the tables? Or is it not possible?
I hope this makes sense.
First supposing what you mean by pre-populate fields is let user to insert data into your database tables using some form then show this data in a report.
Reporting Services is not designed to insert or alter data anyway. Instead it is used commonly for reporting purposes, to show data using charts and controls allowing limited user interaction.
If supposition is wrong and you want to add a drop-down list to filter your data or specify presentation conditions you can use a parameter. Go through this technet tutorial where adding and setting for a report parameter is explained.
It is possible to add custom report items to your report, go to this documentation and check this sample in codeplex.
