edoloughlin

Thanks for the info. We'd also like to allow customers to design their own reports. We can't require/trust them to restrict their reports to their own data - this has to be invisible to them and happen at report execution time. Is this possible?

Hi, not sure if this belongs in this forum or in the JasperReports forum. Apologies if it's the wrong place... I'm looking at user JasperReports/JasperServer where data for several customers will be stored in one schema. The plan is to allow customers to log in and run their own reports. This means that any queries they execute will have to be intercepted and restricted. I.e., something like 'WHERE CUSTOMER_ID=xxx' will have to be automatically added in the background before it is run, where xxx depends on the user's id. Does JasperServer or JasperReports support this type of interception? Thanks, Ed O'Loughlin.