The datatype on the table is varchar and I'm passing it a string.

When I changed the report parameter to non-hidden so I type in the value, the report does show...

I ran the profiler and it did show the value that I pass it.

<Parameter>

    <Name>PANumber</Name>

    <Type>String</Type>

    <Nullable>False</Nullable>

    <AllowBlank>True</AllowBlank>

    <MultiValue>False</MultiValue>

    <UsedInQuery>True</UsedInQuery>

    <State>HasValidValue</State>

    <Prompt />

    <PromptUser>True</PromptUser>

    <Values>

      <Value>2305</Value>

    </Values>

  </Parameter>

</Parameters>'

This is...