I have been asked to replicate an Excel worksheet which includes drop down lists. This form is
completed partially by a member of staff at our end and then sent off to the police who fill in further information and return it. We currently use a report that fills in the information that we provide and is then exported to an Excel worksheet and emailed. This Excel sheet is a standard form used across a range of agencies both Government and non-government.
The form has been updated and now includes drop down lists which require information that we don't hold. I have been asked to update the report we use to match the new format of the form. What I'd like to know is, is there a way to include the drop down boxes on the output
of an SSRS report? I know I can fill in data based on report parameters but as I mentioned before we don't hold a lot of the information requested. The forms have been returned in the past because they don't match the current\correct format so I don't want to just leave the respective boxes without the drop downs in them.
Can anybody help?
On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
—Charles Babbage, Passages from the Life of a Philosopher How to post a question to get the most help