<p>Hi, looking for some help with this one.</p>
<p>Complex query for Open method, didn't write it, but was asked to add one more field for results.</p>
<p>Works outside of BIRT (Toad), but not within the report.</p>
<p>Since the query uses several expressions with fields, uses the group by statement.</p>
<p>As soon as I added the in order to complete it, it blows up with the error 17070, as soon as I remove it from that statement, runs the report, but of course, no data.</p>
<p>I know sometimes code can be a little quirky in actuate from working with previous versions, and trying to get up to speed on Birt Designer Pro 11.04.</p>
<p>Attached is the query without all the formatting for birt, for some unknown reason, wouldn't let me paste it.</p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
