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.

 All Forums
 Development Tools
 Reporting Services Development
 How to add a dropdown to a texbox inside a report.

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?
Go to Top of Page

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
Go to Top of Page

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
Go to Top of Page

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
Go to Top of Page

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 recorder
2. Add a drop down list
3. Stop the macro recorder
4. Look at the macro and use the code it generates as a template to do what you want.
Go to Top of Page
   

- Advertisement -