jgraham0325

Just an update on this. Using the above method works fine, until the user tries to use the filters in the table component. As soon as a filter is used, the REPORT_CONNECTION object becomes null. If anyone has any other ideas, please let me know. Thanks, James

Hi, I'm trying to create a hyperlink that takes me to a different link depending on which server my report is running on and was wondering if someone could help. The scenario: We have a development server and a live server.I want a link in the report to go to a corresponding link in the development environment if that's where the report is running.If the report is running in the live environment then I want the link to go somewhere else.The link is not another jaspersoft report, it's a spring web application, so I can't use the report execution hyperlink option.I don't want to have to make any changes to the report between the 2 environments, just a straight export.Both enviroments use different databases so I've tried doing it this way: $P{REPORT_CONNECTION}.getMetaData().getURL().contains("live-db") ? "http://livelink.com" : "http://devlink.com"[/code] This approach works for my browser but doesn't seem to work for another persons browser (always taking them to the dev link). I haven't fully investigated why. Does anyone know of a better way to do achieve this? Setup: Jasperserver Pro 4.7 iReport 4.7 Thanks, James

Hi, We're facing the same issue. The only work around seems to be to create seperate dimensions for each of the hierachies. This isn't a great approach from a users perspective because it makes the list of dimensions very messy. Anyone from Jaspersoft looking into this? Thanks