Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Drop Down Boxes in Finished Report Expand / Collapse
Author
Message
Posted Thursday, September 19, 2013 3:05 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 7:56 AM
Points: 897, Visits: 2,894
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
Post #1496274
Posted Thursday, September 19, 2013 11:41 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Thursday, July 24, 2014 9:07 AM
Points: 11,157, Visits: 12,899
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

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming

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
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2
Post #1496521
Posted Friday, September 20, 2013 12:57 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 7:56 AM
Points: 897, Visits: 2,894
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
Post #1496725
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse