title: SSRS- Report parameter not valid for its type- input parameter, no default/available value
body: <p>I am trying to create SSRS report where i will input the <strong>CombinedAccountNumber</strong> - which acts as input parameter in the report with no default/available value. I have provided the datatype as <strong>INT</strong> in the report but whereas in the datatype it is nvarchar.</p>
  
  <p>When I run the report, it throws the error: The value provided for report parameter <strong>CombinedAccountNumber</strong> is not valid for its type.
  Could anyone please assist where I am going wrong, do I need to fix the query or something while adding the parameter in SSRS report?</p>
  
  <p>Here is the query i am using in the Datasets section:-</p>
  
  <pre><code>SELECT
          [QAACTO]
         ,[QAACTA]
         ,[QACKDG]
         ,substring([QACPHA],2,4) as 'Alternate Phone Area'
         ,substring([QACPHP],2,4) as 'Alt Phone Prefix'
        ,[QACPHN] as 'Alt Phone Number'
        FROM [MOCK124].[dbo].[FPQA]
        where 
        ((REPLACE(LTRIM(REPLACE([QAACTO],'0', ' ')),' ', '0'))
        +
        (REPLACE(LTRIM(REPLACE([QAACTA],'0',' ')),' ','0'))
         +
        ([QACKDG])) = @CombinedAccountNumber
  </code></pre>