Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
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 14:33 Go to next message
JP Redro is currently offline JP RedroFriend
Messages: 181
Registered: July 2009
Location: India
Senior Member

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.


Thanks,
JP
Re: high priority :Quarey problem in BIRT and thanks for Tianli [message #249352 is a reply to message #249161] Mon, 23 July 2007 02:39 Go to previous message
Tianli Zhang is currently offline Tianli ZhangFriend
Messages: 2862
Registered: July 2009
Senior Member
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:
  


Current Time: Tue Jul 23 11:38:45 GMT 2024

Powered by FUDForum. Page generated in 0.04450 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top