Alex42 Posted December 7, 2016 Share Posted December 7, 2016 Hello Everyone. I have a strange behaviour when passing parameters through a hyperlink inside a dashboard dashlet. I am ushing Jasperserver 6.3. The scenario is the followingI have a main dashboard that contains 2 reports. Both of the reports have the same input controls(names of parameters are the same so there is no mismatch errors). The input controls are filters inside the dashboard and the parameters are propperly mapped.Each of these reports is a collection of hyperlinks. The hyperlinks are built so that they take the input control values selected and link to either a report or a dashboard with the selections pre filled by the main report.All parameters work well and the values are selected and propagated as expected with the exception of two filters/parameters. They are calendar types and the situation is as below(pease see screenshots)When selecting values from the dashboard filters the url is generated correctly in the text string with the dates populated as they should be The problem is that when i click on the link, the url gets distorted, but only for the two date fields(other parameters are passes OK):http://.../jasperserver-pro/dashboard/viewer.html?_report=repo%3A%2FDEVELOPMENT%2FPerformance_Detail_Dashboard&Start_Date_date=rO0ABXNyAA1qYXZhLnNxbC5EYXRlFPpGaD81ZpcCAAB4cgAOamF2YS51dGlsLkRhdGVoaoEBS1l0%0AGQMAAHhwdwgAAAFYt65AAHg%3D&End_Date_date=rO0ABXNyAA1qYXZhLnNxbC5EYXRlFPpGaD81ZpcCAAB4cgAOamF2YS51dGlsLkRhdGVoaoEBS1l0%0AGQMAAHhwdwgAAAFYzEewAHg%3D#%2FDEVELOPMENT%2FDash_Performance_Sumary&Cascading_Quarter_multi_select=&Brand_multi_select=&Cascading_campaign_multi_select=&Length_multi_select=&Client_multi_select=&Weekof_date=&Start_Date_date=2016-12-01&End_Date_date=2016-12-05The stranger part is, that when i use the report that contais the links by itself, and give it the start_date and end_date from its own input controls the same url is generated but when i cklick on the link it works without the values being distorted. In short the problem appears only when using it form the main dashboardAs a note,in Jasper studio the hyperlink is of type Reference and Target Blank in order to open in a new page.Please let me know if you have any suggestions or if this is a Jasper Server Bug Link to comment Share on other sites More sharing options...
reportdev Posted December 7, 2016 Share Posted December 7, 2016 are you trying to pass date parameters that are of class java.sql.Date or java.sql.Timestamp ?may be you need to properly format those dates. I'm not sure but give it a try. Link to comment Share on other sites More sharing options...
Alex42 Posted December 7, 2016 Author Share Posted December 7, 2016 the parameters are Date type.The input controls are calendar type for picking desired dates. The jasper server configuration has been changed from the default to mm/dd/yy format for dates, however Jasperserver only accepts yyyy-mm-dd format as a valid format when passing parameters in the URL. This is however of no consequence since the values are passed correctly as evidenced by the generated url in the screenshot. If i copy paste that in the browser the propper dashboard, with correct passed values are going to be loaded.Furthermore, as i mentioned, if the report used in the dashlet is run standalone(not in the dashboard), the valus from the input controls(that are filters in the dashboard) are passed correctly to the links and reports/dashboards run as desired.The confounding part is why Jasper changes the generated URL when clicking the link from the dashboard(and only for these input controls, others don't behave like this) but doesn't do it when clicking it from the report? and how can i make it stop behaving this way? :) Link to comment Share on other sites More sharing options...
matthewgreger Posted December 29, 2016 Share Posted December 29, 2016 Does anyone have any ideas on how to solve this? Link to comment Share on other sites More sharing options...
msanjay Posted June 19, 2017 Share Posted June 19, 2017 I am also facing the same issue. At report level everything works fine. but for dashboard hyperlinks getting same issue as mentioned above. Input controls are Date type. Link to comment Share on other sites More sharing options...
psoni_1 Posted November 14, 2018 Share Posted November 14, 2018 I am having the exact same issue. Has anybody found any resolution yet Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now