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.
if doesn't work can try deleting parameter , recreating - shouldn't work has before.
Comments
Post a Comment