Using SET FMTONLY OFF does not work.

Some suggest using Exec under text in the dataset properties.

But doing this way won't allow me to pass parameters.

So if anyone has a solution...