younos Posted February 10, 2015 Share Posted February 10, 2015 Hi,I use an application for which I create a new database each year, therefore I have some archives of databases from previous years.I would like to know if it is possible in JasperServer that when I want to print a report I can FIRST select a datasource (e.g. 2015, 2014, ...) and THEN select the parameters (e.g. which products, invoices,...). It becomes difficult because some parameters are lists of records taken from a database, then these parameters lists must be updated in function of the database I choose.Is it possible to do something like this? If yes how (in iReport and then in JasperServer)? If no, do you see another mean that can replace it?Thanks in advance,Younos Link to comment Share on other sites More sharing options...
nthapa Posted March 10, 2015 Share Posted March 10, 2015 Please go through this linkhttps://community.jaspersoft.com/documentation/jasperreports-server-ultimate-guide/v55/roles-users-and-profile-attributesJRS has feature called profile attribute in which different values be defined for attribute at different level (server, tenant, user). I am not 100% sure if this will solve your problem but this is worth a look. The link is for v55 but 6.0 and beyond presents more addition to the feature. Those attributes can be used in datasource/domain/adhoc/filter as of amber -2. (which is the work in progress) Link to comment Share on other sites More sharing options...
calculate.machine Posted April 13, 2015 Share Posted April 13, 2015 You can use the user-defined data source function in Jasper to switch among data sources dynamically according to the parameter.This approach requires creating a JAVA class.Try using esProc to help with Jasper if you feel this is too hard. Please refer to http://blog.raqsoft.com/?p=2528 . 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