Drop Down Boxes in Finished Report

Question

Drop Down Boxes in Finished Report

Neil Burton

SSC-Insane

Points: 23000
More actions
September 19, 2013 at 3:05 am

#278035

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

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

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

Jack Corbett SSC Guru Points: 184394 More actions · Answer 1

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.

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

Neil Burton SSC-Insane Points: 23000 More actions · Answer 2

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