|
|
|
|
Re: Data Source issue which is not picking dynamically [message #1007837 is a reply to message #1007770] |
Thu, 07 February 2013 17:06 |
|
Right, but you say the first report is getting these details just fine. The problem is the drill down report, right? Do you use the same determining method to pick the correct dataSource in the drill down report and it's just not working? If so, you could try creating a report parameter in the drill down report by right clicking on parameters in the data explorer and choosing new parameter. In the parameter editor, you'd select the is hidden check bock. When you go back to the master and go to edit the drill down hyperlink, you should now be able to pass a value through your parameter to the other report. So, if you pass the correct dataSource information from the first report to this parameter, you can now use it in the setup of the second report.
Michael
Developer Evangelist, Silanis
|
|
|
|
|
|
|
|
|
Re: Data Source issue which is not picking dynamically [message #1008483 is a reply to message #1008253] |
Tue, 12 February 2013 17:18 |
|
One possibility would be to check your start and end date parameters. If they're the same, edit your query to be where date = theDate instead of using between.
What kind of date handling code would you like? Just one that shows a start and end date that can handle the situation of the dates the same? Or something else? If you'd like an example report, let me know your BIRT version.
Michael
Developer Evangelist, Silanis
|
|
|
Re: Data Source issue which is not picking dynamically [message #1008507 is a reply to message #1008483] |
Tue, 12 February 2013 18:54 |
K SREEDHAR REDDY Reddy Messages: 8 Registered: February 2013 |
Junior Member |
|
|
Hi Michael,
My Birt version is 3.2.22.
I am passing the date in the following format 06.02.2013.
From date and To date will not be same all the time beacuse of time zone off set if i send the parameter like 06.02.2013 and 12.02.2013 it some time displays the 13.02.2013 values also
oracle stores the value in GMT format but when displaying or doing filtering i need to add time zone to display.
if you can provide me some java script code to get time zone and add to the date.
i tried all the possible ways available on the net but still no advance from there.
Please help me with the code if you have.
Thanks in advance,
Regards,
Sreedhar.
[Updated on: Tue, 12 February 2013 19:02] Report message to a moderator
|
|
|
Re: Data Source issue which is not picking dynamically [message #1008527 is a reply to message #1007543] |
Tue, 12 February 2013 21:09 |
|
Take a look at the beforeOpen script of the dataSet. It takes a string value date dd.MM.yyyy for start and end date. It separates them into a string representation of what the database takes. In this case, it's yyyy-MM-dd. If the parameter values are the same, the query's where statement uses '='. If they're different, it uses between. For the sample database, this wasn't necessary, if the values were the same between worked just fine to show the values from just that day.
As for the timezone offset, you should be able to use the function getTimezoneOffset() to grab the offset in minutes. Then, use the BIRTDateTime functions to add/subtract the minutes to/from your date.
Michael
Developer Evangelist, Silanis
|
|
|
Powered by
FUDForum. Page generated in 0.05271 seconds