Hi, I have a scenario in which i need to make a column clickable in tablebox and need to show the detail report in another tab on the basis of a Id. so the problem is when i click on a column then table box filters the records on the basis of that column so I want to stop filtering on that column.
Tricky. You'll need to use the OnAnySelect trigger to clear the selection as soon as it's made. You can use a set analysis expression in the detail report to use the previous (now cleared) selection. For example if you now use sum(Sales) in your report then the set analysis expression would become sum({$1}Sales). The {$1} creates the set for the previous selection.
