Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sunder.bugatha
Yak Posting Veteran
66 Posts |
 Posted - 2014-10-21 : 05:51:10
|
| i have a requirement where i have to make a textbox to display a list of values (in dropdown) then when i export it to excel sheet then user should be able to select a value from the dropdown. Has anyone worked on a similar requirement?Hema Sunder |
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2014-10-21 : 09:01:09
|
| There is no way to do this with SSRS directly. You'll need to export the report to Excel then post-process the file produced with VBA or a .NET program to insert the dropdown.FWIW, why not have the user select the textbox item from Report Manager when they run the report? |
 |
|
|
sunder.bugatha
Yak Posting Veteran
66 Posts |
Posted - 2014-10-22 : 02:57:25
|
| My requirement is to have a dropdown in excel sheet so that user can select the appropriate option.Hema Sunder |
|
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2014-10-22 : 09:33:31
|
| well then, you'll have to post-process the spreadsheet produced by SSRS |
|
|
|
sunder.bugatha
Yak Posting Veteran
66 Posts |
Posted - 2014-10-24 : 06:56:34
|
| do you have any sample code to add dropdown list to a textbox?Hema Sunder |
|
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2014-10-24 : 09:16:20
|
| Not handy but here's what I'd do:1. On a new, blank spreadsheet, turn on Macro recorder2. Add a drop down list3. Stop the macro recorder4. Look at the macro and use the code it generates as a template to do what you want. |
|
|
|
|
|
|
How to add a dropdown to a texbox inside a report.