4,763
Hello all,
When I try to use the select tab on a custom SSRS report, I get the System Message 9809 stating "Invalid data length for dbo.APDOC.BatNbr. he maximum length of this field is -1.
I can't find any reference to this error in the usual places. Has anyone else seen it?
*This post is locked for comments
What it ended up being was that I had just copied the select query from the SSMS query screen. It was formatted with [square brackets] around the field names - when I retyped the query by hand leaving those off, it works just fine.
Hi Butch,
In your view, are you using tablename.fieldname? If you are using an alias, like v.vendid, try using the full tablename instead (vendor.vendid). That has been known to work.
This bug is fixed in version SL 2011. Let me know if this information helps.
Hi Carolyn,
Sorry, I wasn't subscribed to the thread and just saw your answer.
Yes the query is a little on the complex side, joining a ReQlogic table to some SL tables as well as an embedded Select statement.
Based on your suggestion that this might be a problem, I have created a view and am now running the report with a simple select against it. This cause the error to change to a SysMsg 9864 "Unable to determine the database field properties of ...."
In order to pass a parameter to the report I have created a custom field and am using the ripram "longanswer00" to filter the report. This is a problem because i can't get "IN" to work in a recordset filter with more than one value and am stuck only able to select on batch at a time for the report. Obviously this isn't ideal and I would like to allow the user to pick his batches from the tab we have alread trained him to use.
Thanks,
Butch
Hi Butch,
You are running into bug 17895. The problem seems to be with ROISRS and its inability to handle complex select statements. What does the select statement look like that the report is using to get the data? Can you paste it into this post?
#1
Community Member
136
#2
Mohamed Amine Mahmoudi
102
Super User 2025 Season 1
#3
REUser
8
Share
Report
All responses (
Answers (
