Jasper Report Integration: User friendly filters

Travis shared this question 2 years ago
Answered

Is there a way to have Yellowfin prompt the user for filters when using an uploaded jasper report definition. I know you can setup parameter on the report and that Yellowfin will prompt for the value, but we are looking for something more complex. We would like to have the user be prompted for items from a selection list. This list needs to come from the data source similar to how filters can be setup on a normal report. Other things like Date ranges would be useful too. Is there a way to configure this in Yellowfin or something specific that needs to be in the jasper report definition in order for Yellowfin to accommodate this?

Comments (3)

photo
1

Hi Travis,


those sort of filtering options you have described must be set up in the original Jasper report definition as Yellowfin just takes the Jasper report "as-is".


regards,

David

photo
1

Does this mean it is possible to set it up in the report and have the user prompted for a filter from a list of values from the database when Yellowfin executes the report?

photo
1

Hi Travis,


I downloaded a Jasper report (with accompanying script to build a MySQL Data Source) that had cascading filters with drop-down lists of values from this site:


http://ankurthetechie.blogspot.com.au/2014/03/cascading-parameters-in-jasper-reports.html


/EnRRFeGSx8cAAAAASUVORK5CYII=


and imported it into Yellowfin but unfortunately the filters didn't work:


/AVCJFtAtTQW5AAAAAElFTkSuQmCC


regards,

David