Eclipse Community Forums: BIRT » high priority :Quarey problem in BIRT and thanks for Tianli

Home » Archived » BIRT » high priority :Quarey problem in BIRT and thanks for Tianli

high priority :Quarey problem in BIRT and thanks for Tianli [message #249161]

Fri, 20 July 2007 10:33

Eclipse User

Hi All & Tianli

First thanks for Tianli for the providing sound result.
yes i am using BIRT sample database. now i can able to run the report with
date parameter.

But:

My Problem in query like:
select * from sas_received_faxes
where sas_received_faxes.RECEIVED_DATE between ? and ?
or sas_received_faxes.FILE_NAME like ?

In this case the 3 parameters are optional, i need any either date vise
or particular fax_name,

but i am getting following error:

OdaDataSet Data Set:
- Error evaluating Javascript expression. Script engine error: missing ;
before statement
Script source: property binding, line: 0, text:
params["From_Date"]params["To_Date"]

Data (id = 67):
- There are errors evaluating script "row["FILE_NAME"]".

could you please assist me in this this is high priority task for me.

Re: high priority :Quarey problem in BIRT and thanks for Tianli [message #249352 is a reply to message #249161]

Sun, 22 July 2007 22:39

Eclipse User

Hi Red

You are so welcome.
First would you please tell me what you specified for the third parameter?
I have tried your case but no exception as you found.
select * from orders where orderdate between ? and ? or status like ?
Three parameters are:
param_1: '2003-03-06'
param_2: '2003-06-06'
param_3: 's%'

Am I right to fill your case?

Regards!

Previous Topic:	Scriped Datasource and Parent/Child relationship
Next Topic:	Drill down Interactivity in PDF

Goto Forum:

-=] Back to Top [=-

Current Time: Sat Aug 16 16:54:49 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter