"Simon Sellick" <simon.sellick@tesco.net> wrote:
>
>I have a data report whose data source is an SQL query. At design-time the
>query is a command in the data environment. At run time, the same SQL is
>rebuilt (with different parameters) and the report datasource is set to
the
>result of executing the SQL on a connection to the database. The report
complains:
>"The application is using [PARAMETERS!] that are of the wrong type, are
out of acceptable
>range, or are in conflict with one another."
>If I debug.print the SQL just before exec'ing and assigning to the report
>datasource, then copy it and paste it into the data env command and run
the
>report, the report is OK.
>What have I missed? (The technique works OK on another report).
>Thanks in advance for any help.