From: sorrytoomuchspamalready@xs4all.nl   
      
   I don't know much about SSRS.   
      
   Having said that, you should at least double check that the column   
   Description is really declared as varchar(50), and not accidentally as   
   varchar(1) (which you would get if your original create script used the   
   datatype "varchar").   
   --   
   Gert-Jan   
      
      
   Wes Groleau wrote:   
   >   
   > (Is there a better NG for SSRS questions?)   
   >   
   > I created three tables in SQL Server 2008, all with   
   >   
   > Code char(1) not null,   
   > Description varchar(50)   
   >   
   > then three sprocs, all by   
   >   
   > create name_menu as   
   > begin   
   > set nocount on;   
   > select Code,   
   >         Code + ' - ' Description as Description   
   >    from name;   
   > end;   
   >   
   > (name being the part that varies)   
   >   
   > Added each sproc to an SSRS 2008 report as a dataset. then added each   
   > dataset as a parameter, with Code as Value, Description as label   
   >   
   > In the report, two of the menus look as expected, but _one_ shows only   
   > the code, the ' - ' and the first letter of the description. If I add   
   > the parameter value to the report as a textbox, the description part has   
   > the "boxes" typical of trying to display UTF-16 little endian in an   
   > ASCII field.   
   >   
   > I searched the XML of the report and found that all non-numeric   
   > datatypes are String or System.String   
   >   
   > The Parameter Properties dialog has a datatype menu which does not   
   > allow for this distinction.  Choices are   
   >    text   
   >    date/time   
   >    integer   
   >    boolean   
   >    float   
   >   
   > The dataset properties dialog has no place to see or say anything   
   > about datatypes.   
   >   
   > I checked   
   >   
   > SELECT inf...schema.columns where DATATYPE = 'NVARCHAR'   
   >   
   > ...and there are none.   
   >   
   > I deleted the sproc and ran the create statement again, then told SSRS   
   > to refresh the fields.   
   >   
   > Older versions of SSRS used to cache data and sometimes would fail to   
   > refresh, so I looked for cache files to delete. Didn't find any.   
   >   
   > I should be able to cast the results, but I shouldn't have to. (And it   
   > wouldn't surprise to be told "you can't do that")   
   >   
   > Advice?   
   >   
   > --   
   > Wes Groleau   
   >   
   >    How to lose an argument gracefully   
   >    http://Ideas.Lang-Learn.us/BlindDog?itemid=4013   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)