March 10, 2008 at 10:19 am
REPORTING SERVICES PARAMETER select all is truncating when passing to a stored procedure. I've found the cut off to be between somewhere between 138 and 143 characters. My select all is 1023 characters. I worked my way up to the failing point. I'm not finding anyone else experiencing this problem. Nor am I finding any settings regarding parameter length.
Any ideas?
March 10, 2008 at 11:58 am
The report works with 215 character parameter string but adding one more making it 223 it fails. This has to be something associated with the length of the parameter.
Any suggestions!
March 10, 2008 at 9:18 pm
What is the length of the parameter in the stored procedure?
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
March 11, 2008 at 7:24 am
I have tried nvarchar(8000) and varchar(4000) and varchar(max) all fail. The parameter passed that is stored in the ExecutionLog table is 223 characters. That isn't the 'Select All' option however if I unselect one item making it 215 characters it works.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply