How to auto populate the data in SSRS.

Hi Chandan,

Did you want to use this function in parameter text box? As Visakh16 and Harsh posted earlier, currently, the function is not provide in SSRS. However, we can work around it use ReportView control.

Alternative, we can try to create a separate parameter as a text field to populate a list box of options. More detail information, please refer to the thread below:

http://connect.microsoft.com/SQLServer/feedback/details/582839/

Since the issue is by design, I recommend you to vote above feedback. Your feedback is valuable for us to improve our products and increase the level of service provided.

If you have any questions, please feel free to let me know.

Regards,

Alisa Tang

If you have any feedback on our support, please click here .

---

Alisa Tang

TechNet Community Support