Drop Down Boxes in Finished Report

  • 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 http://www.sqlservercentral.com/articles/Best+Practices/61537

  • I don't think that there is anyway to have and SSRS report export to Excel and have the spreadsheet have drop-down's. I'm pretty sure you'll need to find another solution for this.

  • Thanks for replying Jack.

    After a bit more searching and asking around I'd reached that conclusion myself too. My boss's response was basically 'they'll just have to live with it then' so I can put this one to bed I think.


    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 http://www.sqlservercentral.com/articles/Best+Practices/61537

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply