sql server - SSRS truncating parameter -


i have ssrs report populates parameter stored procedure. query works expected. when parameter used in running report, parameter being truncated. choose value abcd, report returns values abc. stored procedure passing parameter runs in ssms , returns abcd data. when test query in query designer or run report, abc data. how ssrs pass in entire parameter?

parameters strings without set length. there's nothing truncate values. have checked values make sure value , label same?

the label see (abcd) while value passed in parameter. don't know if problem if works on local machine though.

enter image description here

if doesn't work can try deleting parameter , recreating - shouldn't work has before.


Comments

Popular posts from this blog

resizing Telegram inline keyboard -

command line - How can a Python program background itself? -

php - "cURL error 28: Resolving timed out" on Wordpress on Azure App Service on Linux -