Hi, Thanks for response! The datasource of the data sets is set to SQL Query. We have used VALUEOF("REPO_VARIABLE") within the actual data sets and this has worked, it just will not work as the default value for a parameter. Thanks, Carley

Thanks for the help everyone, we're trying these options out now

Hi Sven, Thanks for the reply. Do you know how the process you've suggested would work with the parameter I mentioned? Is it possible to base the formatting on the value of the parameter? Thanks!

Hi Venkat, Do you have an email address I can send to? Many thanks!

Hi, Thanks for the response! 1. I want it to show the Allowed/Actual Distances for each Lease only once. What it was doing before is repeating the values for each "item" (report lowest granularity is "item" and each lease can have multiple items. What it is doing now is suppressing the distance values even when the lease…

Thank you!

Hi, Do you know if there is a way to make this a bit more advanced, so in the below example: The Actual Distance of lease 8373 has been suppressed, as it is 28250 (same as the one above), but ideally we would like it to only suppress the values for each Lease... does that make sense? Thanks a lot

Great, that's worked! Thanks a lot!

Thank you so much Thomas, the suggestion of using <= and >= instead of BETWEEN worked!

Thanks a lot for your response Thomas! It is version 11.1.1.7.150120. Database is Oracle 12c Enterprise Edition 12.1.0.2.0 Have you had to cast any of your columns to get it to work? What are the datatypes of the 2 columns you're using to pass in values? Thanks again. Oracle BI Publisher 11.1.1.7.150120

Hi again, Just a bit more detail.. The way I have set this up is exactly as you have shown in your screenshots as you can see below: When I try to view data I get a "Failed to load XML" error. I checked the log for more information on the error and can see this error message which I've searched for online and can find…

Thanks Christian