1) Can ad hoc templates be saved? And can they be shared with members of my department, but have restricted access from anyone else?
Yes. Anything that you modify or create as an ad hoc template can be saved, with the option to be saved in 2 different locations. Option 1: Every user has their own “My Reports” folder so anything you build can be easily saved to “My Reports”. Option 2: There are also public folders to simplify sharing.
In terms of saving templates with view restricted to only department members, you can have the Administrator create a public folder with security settings so that only members of your department can access that particular folder. Other members of the enterprise wouldn’t even know the folder exists, since without access it wouldn’t be shown when they went to the server.
Row level security is also available. Meaning that if each individual member has different data that they can access from the database this would automatically render with JReport so that even though a member of your department is accessing the template that you created, if they don’t have access to your data then they would actually only see the data permissible to them. With row level, column level, and folder security, you’re completely covered from the security standpoint with JReport.
2) How up to date is the data in ad hoc reports and dashboards?
Everything in JReport queries directly to the database. All of the examples that you saw in the webinar used instant data directly from a MySQL database, meaning that you can go directly to the database for all your ad hoc reporting and dashboards. However, if you do want to schedule a large query to the database and then keep that data available for people to run reports on, you can do that as well with a cache results set. Using a scheduled cache you can run a report against that data without ever going back to the databases.
3) Can I refresh data in a dashboard on-demand and/or on a schedule i.e. every 5 minutes?
There is an option right on the dashboard screen to manually refresh so users can simply click that icon and all of the components will go back to the database and refresh the data. As an attribute to each of the different components you can also tell the dashboard to update them on a specific schedule. So if you do want the dashboard to update every 5 minutes, you can turn that option on and every 5 minutes the dashboard will automatically go out and get the new data from the database and update all of the components.
Watch this webinar on-demand now!