![](http://content.invisioncic.com/i328763/set_resources_3/84c1e40ea0e759e3f1505eb1788ddf3c_pattern.png)
jorechnikova
-
Posts
3 -
Joined
-
Last visited
Content Type
Forum
Downloads
Featured Visualizations
Knowledge Base
Documentation (PDF Downloads)
Blog
Documentation (Test Area)
Documentation
Dr. Jaspersoft Webinar Series
Security Advisories
Events
Profiles
Posts posted by jorechnikova
-
-
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
Report Server Wrong filter wiring in Filter Manager - Specify a valid value for type TimestampRange.',field='null'}
in Products
Posted
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?