Since we cannot have two interactive reports on the same page, I have two classic reports which includes two columns age and score in both the reports. In interactive reports we can add filters like where age > 30 or score is < 50 etc. Any suggestions on how can we add some sort of filters on Classic reports in the sql. I was thinking maybe we can have two text items, but was wondering if anyone has any ideas or suggestions on adding >, < etc operators which can be added to the report sql?
I guess the other option would be to use the iframe suggestions available online, but I wanted to check if we can use some logic rather than having two pages etc.