Eclipse Community Forums: BIRT » BIRT Designer report not executing on BIRT engine

Help

Home

Home » Archived » BIRT » BIRT Designer report not executing on BIRT engine

Show: Today's Messages :: Show Polls :: Message Navigator

BIRT Designer report not executing on BIRT engine [message #1480282]

Thu, 20 November 2014 04:24

Nishit Angrish

Messages: 2
Registered: November 2014

Junior Member

This is the query that I am executing in the beforeFactory method of my dataset.

this.queryText = this.queryText + params["filter"].value + " and substring(rep_timestamp, 15, 5)='00:00' and unix_timestamp(rep_timestamp) >= 1414521000 and unix_timestamp(rep_timestamp) < 1414575773 and "+ params["filter_p"].value +" and substring(rep_timestamp,12,2) >=0 and substring(rep_timestamp,12,2)<=23 and availability !=200 ) as p group by " + params["group_by"].value;

filter, filter_p and group_by are 3 parameters that are getting dynamically changed according to what you select. This query works just fine in BIRT Designer. But when I try to run it in an application where BIRT engine has been integrated it throws a syntax error. Any solution to this?

Report message to a moderator

Re: BIRT Designer report not executing on BIRT engine [message #1494654 is a reply to message #1480282]

Mon, 01 December 2014 16:51

Michael Williams

Messages: 1925
Registered: July 2009

Senior Member

Can you post the error stack? Is there any way you can reproduce the error in a way that I can run the report design to see the error and test myself?

Michael

Developer Evangelist, Silanis

Report message to a moderator

Previous Topic:	Report Designer
Next Topic:	Table not showing when data set returns no rows

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 02:52:34 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter