[news.eclipse.birt.usability] Not able to retieve correct data based on

[santoshkumar_m@xxxxxxxxxxxxxxxx (Santhosh Kumar)]

Hi Birters,

I am using BIRT-2.2.1. I ma new to this tool. I have one issue here. I am 
trying to create a report such that it should retrieve the data, from the 
data base to which it is connected, for a selected period and it should 
show the data in a table or chart. Here, that time perid should be 
provided by the user as an input paramaeter. I have created Report 
parameter for "Bgin Date" and "End date" and for "report period" (like, 
today, yesterday, weekly, last 30 days, last 1 week, last month, last 
quarter, yearly). So, here I am not able to retrieve the correct data 
according to the time slot given by the user.
That is there is no impact of report parameters on data.


How can I tie the date report parameters to the dataset parameters?


I tried with the following workarounds for the date range problem.

I tried with the following two sets of expression builders

1)getStartDateFromGroupNames("Report Period","Begin Date","End Date")
getEndDateFromGroupNames("Report Period","Begin Date","End Date")
getReportPeriodFromGroupNames("Report Period","Begin Date","End Date")

 for this i got the following errors:

The following items have errors: Error evaluating Javascript expression. 
Script engine error: ReferenceError: "getNLS" is not defined.
Script source: source, line: 0, text:
getNLS(params["Report Period"].value) Error evaluating Javascript 
expression. Script engine error: ReferenceError: "getStartDate" is not 
defined.
Script source: source, line: 0, text:
(params["Begin Date"].value != null && params["Begin Date"].value != 
"")?params["Begin Date"].value:getStartDate(params["Report Period"].value) 
Error evaluating Javascript expression. Script engine error: 
ReferenceError: "getEndDate" is not defined.
Script source: source, line: 0, text:


2)(params["End Date"].value != null && params["End Date"].value != 
"")?params["End Date"].value:getEndDate(params["Report Period"].value) ii) 
(params["Begin Date"].value != null && params["Begin Date"].value != 
"")?params["Begin Date"].value:getStartDate(params["Report Period"].value)
(params["End Date"].value != null && params["End Date"].value != 
"")?params["End Date"].value:getEndDate(params["Report Period"].value)
getNLS(params["Report Period"].value)

 for this also i got the similar errors:

The following items have errors: ReportDesign (id = 1): + Error evaluating 
Javascript expression. Script engine error: ReferenceError: 
"getReportPeriodFromGroupNames" is not defined.
Script source: source, line: 0, text:
getReportPeriodFromGroupNames("Report Period","Begin Date","End Date") + 
Error evaluating Javascript expression. Script engine error: 
ReferenceError: "getStartDateFromGroupNames" is not defined.
Script source: source, line: 0, text:
getStartDateFromGroupNames("Report Period","Begin Date","End Date") + 
Error evaluating Javascript expression. Script engine error: 
ReferenceError: "getEndDateFromGroupNames" is not defined.
Script source: source, line: 0, text:
getEndDateFromGroupNames("Report Period","Begin Date","End Date") 2. I 
added the library ?TivoliCommonReporting_v1.0.rptlibrary? to that column 
binding.


Please suggest me solution for this.
Early suggestions is appriciated.


Thanks & Regards,
Santhosh Kumar