Width of parameter on MSSQL 2005 Reporting
I am creating a simple one table report with some parameters that have menus associated to them. The menus are query results from another table - for instance "Company Name". Due to a previous design the company name field is 254 characters long although the companies selected vary from only 5 characters to approximately 30 characters. Unfortunately the parameter field a top the report expands the width of the parameter field to 254 characters. Is there a way to control the width of the parameter field either through a property setting or through SQL. I am stuck using an ODBC as the middle piece.
Thank you in advance.
Thank you in advance.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
In the future accept your own answer and select the other anwser as an assist you can still award point anyway you want and it won't require someonelse to do anything someone is going to have to do a little cleanup the way you "resolved" the question
ASKER
Sorry about that technofile - I am new at this - I am hoping that you are rewarded for the poitns.
As long as the moderators read the request correctly and allow it I think it should, its not a huge deal its just another thing that the volunteers here will have to do instead of the automated system handling it. Like i said just for the future.
ASKER
I think it is an ODBC issue in part. I can not use the LTRIM feature in my select statement, nor in the expression area for reporting. It is VarChar(254). And When I changed it to 60 for testing it did decrease the width. Any other thoughts? Or any other way to control the size - I tried converting it to text as well to no avail.
Thanks.