Ken had helped me out with getting parameters in the right format on the SQL statement the other day and they worked great (thanks again, Ken). But I spoke too soon when I said all was well. They work fine in the SQL Designer but I can't seem to get them to work on the actual report. When I run the report, it does not ask for the three parameters I put into the SQL statement (it does ask for other parameter values that were created with the report). I thought if I added the parameters to the report as well with the same name I gave them in SQL Designer that would do it but it does not. It asks for my values, but it always returns the first case regardless of the case number I type in. Again, this works fine within SQL Designer, but just does not work in the actual Report itself. I assume I am missing something or need to create some sort of link between the parameters in the SQL statement and parameters in the report...
Again, thanks in advance,
Craig.
Again, thanks in advance,
Craig.