Using WITH statement

[mihiri2]

Hi,

I have a report which has a data source which uses "WITH"

so it goes on as
WITH CumulativeCashFlow as(select a, b from tableA)
select CumulativeCashFlow .b, Tableb.b
from Tableb
inner join CumulativeCashFlow on Tableb.a = CumulativeCashFlow.a

This works fine if I run the report on SQL Server.
If I run the report on Oracle on designer using preview, i again can see my data fine.

BUT, If I compile the report to be a mrx file then it doesn't work anymore and I receive a blank page.

Is this a know issue? Do you have any ideas how I can overcome this issue?

Thanks

[HighAley]

Hello.

This problem could not be connected with WITH statement.
The mrx-file is not compiled report. Could you specify how do you get this file and how do you use this report then?
If it's possible, please, send us a sample project which reproduces the issue.

Thank you.