Home » Eclipse Projects » Eclipse Platform » Not able to retieve correct data based on date!
| Not able to retieve correct data based on date! [message #329828] |
Mon, 07 July 2008 14:05  |
Eclipse User |
|
|
|
Originally posted by: santoshkumar_m.persistent.co.in
Hi Jason,
I tried with the following workarounds for the date range problem.
1. I tried with the following two sets of expression builders
i) 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 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:
(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.
Can you post your report?
Have you tied the date report parameters to the dataset parameters?
Jason
Santhosh Kumar wrote:
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.
Please suggest me solution for this.
Early suggestions is appriciated.
Thanks & Regards,
Santhosh Kumar
|
|
| |
Goto Forum:
Current Time: Thu Dec 26 11:01:18 GMT 2024
Powered by FUDForum. Page generated in 0.03161 seconds |
] 
Search
Help
Register
Login
Home
