Passing Parameter value to teradata datasource from SSRS

• hishikha.65

  SSC Veteran

  Points: 229

  More actions

  September 18, 2008 at 1:42 am

  #212713

  Below is my query which i'm executing..

  ***************

  select

  site_de,Mfgr_De, cast(EXTRACT(MONTH FROM Dep_Img_Dt) as char(2)) ||'-'||cast(EXTRACT(YEAR FROM Dep_Img_Dt) as char(4)) Img_Date

  ,Div_De,Reg_De,Mkt_De,MSA_De,Prms_De,Apprch_De,Cash_Repl_Vend, case Dep_Img_Ind when 1 then 'IMAGE' else 0 end as Image_Indicator ,

  Trmnl_ID_No, Img_Bsln_Dep_Avg_Ct

  from abcd

  where trim(Reg_De) =@Region;

  ******************

  Getting below Error Message

  TITLE: Microsoft Report Designer

  ------------------------------

  An error occurred while executing the query.

  [NCR][Teradata RDBMS] There is a mismatch between the number of parameters specified and the number of parameters required.

  ------------------------------

  ADDITIONAL INFORMATION:

  [NCR][Teradata RDBMS] There is a mismatch between the number of parameters specified and the number of parameters required. (OLE DB Provider for Teradata)

  ------------------------------

  BUTTONS:

  OK

  ------------------------------

• Niraj-627298

  Hall of Fame

  Points: 3641

  More actions

  September 20, 2008 at 1:02 am

  #874549

  Hi Shikha...

  Please try this;

  ...instead of using...where trim(Reg_De) =@Region;

  try...where trim(Reg_De) In (@Region)....

  I hope...it will work...:)

  Thanks...

  Niraj

• yogesh-603349

  Valued Member

  Points: 61

  More actions

  October 20, 2011 at 7:24 am

  #1397327

  Same Problem for me. How do you make it work?