jorechnikova

I have put together a dashbord consisted of 6 ad hoc view charts, built out of Report Server and without Jaspersoft studio. These views have date filters , either "Month equals" or "Month is on or before" . The Dashboard Filter group has "Month is on or before" $P{Month is on or before} and connected to dashlets via "Month equals" or "Month is on or before" accordingly via parameter mapping. The dashboard works fine , and Filter group date parameter $P{Month is on or before} gets passed properly to all adnoc view dashlets, especially when absolute date is used. BUT ad hoc view dashlet property /hyperlinks Tab /Chat Hyperlinks DOES NOT RESOLVE DATE PROPERLY: 1. It cannot pass $P{Month is on or before} properly to a subreport , got the error (posted below) repo:/organizations/organization_1/my_company/dashboards/MY_SALES_DASHBOARD?Month2_1=$P{Month is on or before} 2. It cannot pass built in dashlet parameter $P{Month} to other dashlets , got the error (posted below). Wrong filter wiring in Filter Manager. <br/>ValidationErrorImpl{errorCode='fillParameters.error.invalidValueforType', arguments=[TimestampRange], properties=null, defaultMessage='Specify a valid value for type TimestampRange.',field='null'} Is it a bug or known issue? How to resolve it?

In JasperReports Dashboards you can use $Date{...} and $P{...} as values in filters and parameters, dashlets and hyperlinks. I was wondering if I could go further and retrieve last day of the month from $Date{...} or evaluate relative default date MONTH-1 parameter, $P{MONTH-1} as Date Any thing re syntax and what could be done with $Date{..} and $P{..} will be really helpful! What other variables could be used in JasperReport Dashboard Designer? Thank you, Julia

Hi, Is it possible to create Dashboard with interactive filtering as below (sorry could not insert jpg here): Parent -> Bar Chart: Sales - Monthly Trend. It shows Sales by month. Child sub-report -> Bar Chart: Sales by Region By clicking on any bar of parent Chart ( say, January sales) , child Chart will show only Sales for the selected month (January). Is it possible in Jasper Server Dashboards ( not Jaspersoft Studio)? Thank you