Error with running difference in Report Studio report

[scottcooper]

I have a Transformer model that uses IQDs created by Impromptu as data sources and I am trying to recreate these queries in Cognos 8 by creating Report Studio reports.

One of the reports runs fine in Report Studio, retrieving the same data as the original Impromptu report but when I try to use this as a data source in the Transformer model, I am getting the following error message:

-UDA-SQL-0358 Line 19: Syntax error near "union".

-RQP-DEF-0177 An error occurred while performing operation 'sqlPrepareWithOptions' status='-16'. UDA-SQL00358 Line 19: Syntax error near "union".

I have narrowed down the problem to a calculated field in the report that calculates the running-difference.

Does anyone know what could be causing this error and how I can resolve it?

Any help would be much appreciated as this is driving me round the bend.

[MFGF]

Just a quick thought - look at the properties of the query in your Report Studio report and make sure that "Auto Group & Summarize" is set to No.

MF.

[scottcooper]

Autogroup and Summarize was set to Yes but even changing it to No doesn't help. It is definitely the running-difference function that is causing the problem but as the original IQD was created from a report with exactly the same function, I can't understand why it doesn't work.

Thanks for the suggestion though.

[MFGF]

Can you re-create this with GO Sales & Retailers and post up an example?