"George" <geomanks@yahoo.com> wrote in message
news:e9dff8e4.0408161516.1fd63b27@posting.google.com...
> Hey Microsoft guys? Any reason no one is responding to this? Did I ask it
wrong?
> Sheila
>
> geomanks@yahoo.com (George) wrote in message
news:<e9dff8e4.0408150802.44783680@posting.google.com>...
> > I tried for hours to pass a parm to a query like this:
> >
> > Select * from Table1 order by @SortField
> >
> > I defined sortfield as a parm in the report parm tab as well as in the
> > sql statement parm tab. I used the generic designer to test it and
> > when it prompted me for the parm I put in the correct column name to
> > sort on. I kept getting a SQL error about passing a wrong parm to an
> > order by clause. It never worked. I didn't know how to see the
> > generated SQL to see what was wrong.
> > I got the same error when I ran the report and passed the same column
> > name.
> >
> > I got around this by turning the SQL into a expression and passing the
> > parm with the parm clause like this
> >
> > ="Select * from Table1 order by " & Parameters!SortField.Value
> >
> > I am glad it is working but why didn't the first way work?
> >
> > Thanks!
> >
> > Sheila