Hi, I'm writing a report that have strings that I need to split. The only way that I came up with splitting them is by counting the spaces, and then write the remaining character after the specified spaces. My problem is, I'm not sure of the code t...

How do you force the removal of duplicated records. What are the trick of the trades codes or formula that you use to remove these records. I have search all over the internet, but can't find that perfect solution. I tried to use the Previous() State...

How to make a condition on a sum in a report. Do I need to create a another variable that will allow me to take the sum and transfer it to variable and put a "Yes" Or "No" condition on it?

I'm trying to filter on a measure object, but it will not allow me to filter on it. I tried changing it to dimensions, but when I write the IF statement it only executes one side of the rule and not the other. For example, if I do an IF statement lik...