CODEWITHSUNDEEP
reporting-services
San
San

Reputation:

Can we set parameter width manually, in SSRS?

Is it possible to set the report parameter's width manually in SSRS? I could see that the parameters are given the width by SSRS itself, and the XML coding does not have any attributes mentioning its width. I'm wondering is there anything that we can add in to

</ReportParameter> </ReportParameter>

to set the report parameter's width?

Upvotes: 0

Views: 1624

Answers (2)

Sanjeev
Sanjeev

Reputation: 11

Simple solution, write your query with UNION, for example:

SELECT empID, empName from Employees
UNION
Select NULL AS empID, 'ALL' as empName

This will solve the small width problem

Upvotes: 1

StrateSQL
StrateSQL

Reputation: 473

None that I am aware of.

Upvotes: 0

Related Questions