Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
Date and Datetime report parameter conversion
Migrateduser
Question about date and datetime report parameters. Our dashboard report has from/to date report parameters (data type = date). This has a drill through to a summary report which has from/to datetime report parameters (data type = datetime). Assigning the dashboard reports from/to date parameter values to the summary report's from/to datetime parameters in the hyperlink definition caused a data type mismatch error. Using BirtDateTime.addSecond(params["To_Date"],86399) to set the time to 11:59:59 for the "to date" also resolved the data type issue. Ultimately I just used the same function and added 0 seconds to get the "From date" to work, but that seems like a workaround.
What is the correct/best way to convert the value of a date parameter into a valid value for a datetime parameter? And is there an actual Java data type that corresponds to these report parameter data types? For example, is the BIRT datetime data type actually a java.util.Date or java.util.Calendar or java.sql.Date? Hopefully that last part makes sense.
Find more posts tagged with
Comments
There are no comments yet