Error 17070 with Group by statement in query

agarrard71

<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>

micajblock

<p>Without being able to access the database it is almost impossible to debug the query. In your workspace directory there is a '.metadata' directory. In there is a.log file. In that file there should be more details on the error. Can you tell us what the details are?</p>